Lead ETL Developer

About the position

The position requires a highly skilled individual with extensive experience in relational database development and cloud data warehouse development. The successful candidate will lead the design and development of ETL applications, ensuring compliance with technical standards and quality assurance guidelines. This role involves overseeing the entire data warehouse lifecycle, from analysis and design to development and testing, while providing technical direction to ETL developers. The candidate will also be responsible for managing data extraction processes and optimizing data warehouse applications for performance and accuracy.

Responsibilities

• Serve as the owner of ETL technical standards, processes, and documentation.
• Lead and maintain ETL application development standards, quality assurance guidelines, regulatory compliance, data governance, and technical documentation.
• Oversee the analysis, design, prototyping, development, and unit testing of ETL applications.
• Ensure automated updates of data warehouse dimensions to minimize business interruptions.
• Provide technical direction to ETL developers and lead technical improvements and knowledge transfer.
• Act as the technical escalation point for production support and projects, resolving issues as needed.
• Lead the design and development of new data acquisition and integration processes for the data warehouse.
• Manage data extraction processes to meet regulatory requirements and business needs.
• Develop and optimize data warehouse applications for performance and accuracy.
• Conduct unit testing, identify errors in program logic, and verify functionality and compliance with user specifications.
• Participate in design and code reviews, communicate project status and design issues to management, and recommend procedural or tool changes.
• Update and develop documentation for applications and development processes, ensuring conformance with departmental and organizational standards.

Requirements

• Bachelor's degree in Computer Science or similar major.
• Minimum of ten (10) years in relational database development experiences.
• Minimum of five (5) years in cloud data warehouse development experiences, including data warehouse full lifecycle project experience and data integration experiences.
• Minimum of three (3) years of experience with data pipeline development and cloud data warehouse development, preferably dimensional data warehouse.
• Minimum of three (3) years of experience with data ingestion frameworks or relevant experience with other cloud-based ETL tool(s).
• Minimum of three (3) years of experience with metadata and data governance practices.
• Minimum of three (3) years healthcare plan or other healthcare IT experience.
• Knowledge of the healthcare industry business transaction processing preferred.
• Previous lead experience with technical teams preferred.
• Knowledge and experience of cloud database management systems, such as Snowflake, AWS and Azure strongly preferred.

Nice-to-haves

• Experience implementing data load monitoring processes to automate the detection and resolution of errors.
• Experience in the use of agile or iterative-type software development lifecycles and techniques.
• Managed care health plan and/or health care industry experience preferred.

Benefits

• Medical, Prescription, Dental, and Vision
• Telehealth app
• Flexible Spending Accounts, Health Savings Accounts
• Basic Life AD&D, Short and Long-Term Disability
• Voluntary Life, Critical Care, and Long-Term Care Insurance
• 401(k) Retirement and generous employer match
• Employee Assistance Program and Mental Fitness app
• Financial Coaching, Identity Theft Protection
• Time off including PTO accrual starting at 17 days per year.
• 40 hours Community Service volunteer time
• 10 standard holidays, 2 floating holidays
• Compassion time off, jury duty