Job Title: ETL Developer

FLSA Status:  Exempt

Department: Information Technology

Reports to: VP of IT

Flex Work Eligible! This position qualifies for the Flexible Work Policy. Employees receive 75 work days annually to work remote! The initial amount of days is prorated for the first year based on start date. 

GENERAL DESCRIPTION / PURPOSE:

This role of ETL Developer will be responsible for the data in the data warehouse integration process. They are responsible for designing, engineering, and implementing the ETL pipelines that extract data from various source systems, transforming the data based on requirements and design, and loading it into the data warehouse. Candidates must have a strong understanding of data modeling, SQL, and ETL tools such as Informatica, Talend, or SSIS. This role will support in the assurance of data accuracy for use in reporting and analysis.

ESSENTIAL JOB FUNCTIONS:

• Designing and implementing robust data warehouse architectures that support business requirements.
• Collaborating with business analysts and data scientists to understand analytical needs and deliver appropriate data structures.
• Writing complex SQL queries for data manipulation and retrieval.
• Assisting in the creation of data models that accurately represent business processes and support analytics.
• Developing ETL (Extract, Transform, Load) processes to integrate data from multiple sources into a centralized repository.
• Ensuring the security of the data warehouse and compliance with data governance standards.
• Optimizing data warehouse performance through indexing, partitioning, and query tuning.
• Testing and troubleshooting data systems to ensure accuracy and quality of data.
• Assist in documenting the data warehouse environment and maintaining metadata repositories.
• Assist in providing support and training to end-users on data warehouse usage and best practices.

BEHAVIORAL COMPETENCIES:

• Passion for Results
• Problem Solving
• Quality Orientation
• Planning and Organizing
• Analytical Thinking
• Values Based