Extended: FY27: Extraction Transformation & Load (ETL) Analyst Programmer, 8 hrs/12 mos, Ad closes 9/18/26

About the role

Works closely with project management and data warehouse development teams, creates and maintains multi-dimensional data models defining the data warehouse Extraction Transformation and Load (ETL) architecture, designs and codes ETL processes, administers change controls and processes, and monitors production data loads. Translates requirements into detailed specifications, and develops and documents business processes and data requirements. Monitors ETL performance tuning production data loads, controls ETL tool releases, conducts system and acceptance testing, provides production support, implements interfaces to source systems, and balances target to source data.

Responsibilities

• Create and maintain multi-dimensional data models defining data warehouse ETL architecture
• Design and code ETL processes
• Administer change controls and processes
• Monitor production data loads
• Translate requirements into detailed specifications
• Develop and document business processes and data requirements
• Monitor ETL performance tuning production data loads
• Control ETL tool releases
• Conduct system and acceptance testing
• Provide production support
• Implement interfaces to source systems
• Balance target to source data

Requirements

• Bachelor's degree required; Master's degree preferred
• Experience in designing, programming, maintaining and tuning ETL processes
• Experience in monitoring and troubleshooting ETL production jobs
• Experience in creation of system requirements and test plans
• Familiarity with database warehouse architecture and performance issues in a large database system
• Experience with database programming tools, SQL, data modeling tools, and database access tools
• Excellent communication skills
• Ability to learn business practices and concepts
• Other combinations of applicable education, training, and experience which provide the knowledge, abilities, and skills necessary to perform effectively may be considered

Qualifications

• Experienced Data Warehouse and ETL Developer with expertise in Microsoft SQL Server technologies, including SSIS, SSRS, SSAS, and SQL
• Skilled in designing and maintaining dimensional data models
• Skilled in developing and optimizing ETL processes
• Skilled in supporting enterprise data warehousing, reporting, and analytics solutions
• Proven ability to translate business requirements into technical specifications
• Proven ability to implement data integration solutions
• Proven ability to perform data validation and reconciliation
• Proven ability to conduct system and user acceptance testing
• Proven ability to provide production support

Skills

• Strong technical, analytic, and problem-solving skills including: dimensional data modeling, structured batch programming, proficiency in database principles, the appropriate database platforms as they relate to database operations, software change control and data warehouse data load integrity and validation procedures
• Ability to tune ETL performance
• Ability to work independently and cooperatively within a team working under severe time constraints
• Ability to develop and implement a test plan
• Skill in completing program and system documentation
• Good oral and written communication skills
• Excellent time management skills
• Knowledge of and the ability to meet the seven core competencies of the Supporting Services Professional Growth System (SSPGS)

Pay

Salary between $39.92 p/h and $57.29 p/h based on position responsibilities.

Schedule

Full-time, Day shift. Some overtime, evening and weekend work required.

This is an in-person position.