ETL/DW Developer

Unclassified - Las Vegas, NV

Full-time

Las Vegas, NV

About the position

This position at Commercial Programming Systems, Inc. offers an exciting opportunity to work with a global entertainment provider, focusing on database warehousing and ETL solutions. The role is based in Las Vegas, Nevada, and requires a candidate with 3-4 years of experience in data warehousing and ETL processes. The successful candidate will work both independently and collaboratively to design and implement ETL solutions that support operational and data warehousing needs, ensuring effective error handling and notification capabilities.

Responsibilities

• Design ETL solutions to support operational and data warehousing needs.
• Create functional requirements and troubleshoot data warehouse design and ETL solutions.
• Deliver data mapping and transformation documents.
• Deliver operational runbooks for projects.
• Collaborate with the business directly in User Acceptance Testing (UAT).
• Adhere to the company's change management procedures.

Requirements

• 3-4 years of experience in database warehousing and ETL processes.
• Strong expertise in SQL Server Integration Services (SSIS).
• Solid knowledge of SQL stored procedures.
• Understanding of Data Warehouse design principles.
• Experience with Microsoft BI tools.
• Excellent oral and written communication skills.
• Familiarity with Scrum or traditional Software Development Life Cycle (SDLC) procedures.

Nice-to-haves

• Gaming or Hospitality experience.
• Consulting experience.
• C# scripting for ETL processes.
• Experience with Red Gate tools.
• AS400 iSeries query experience.

Benefits

• Opportunity to work with a global entertainment provider.
• Collaborative work environment.
• Potential for professional growth in a large-scale data setting.