Join the Innovative Team at Coupe Health as a Senior Data Integration Developer

About Coupe Health
Healthcare today is complicated and confusing. Coupe Health changes that. Coupe delivers a unique healthcare experience that is streamlined and simplified, saving our members time and money. At Coupe, we are passionate about transforming healthcare. Come join our team.

How Is This Role Important to Our Work?

This position is responsible for ETL (Extract, Transform, Load) design and development for enterprise data pipelines, data submissions, and other data integration applications for Coupe Health. You will support business areas, project teams, IT technical teams, and vendors to deliver high-quality data integration work and services, focusing on new and enhanced development. In addition to core accountabilities, you will also take on roles such as application development and project management. You will develop integrated solutions to complex problems that have a broad technical and business context of significant impact.

A Day in the Life

Work closely with business resources, IT cross-divisional technical resources, and external customers to understand and document requirements, and propose data solutions/designs for small to medium-sized projects. Build data pipelines by creating, maintaining, and optimizing workloads from development to production for specific use cases. Develop and maintain ETL/ELT packages using SQL Server Integration Services (SSIS) that handle large, complex data sets from various sources. Ensure data security using SQL Server Technologies.

Triage data issues by analyzing end-to-end data pipelines and work with business users to troubleshoot and resolve data pipeline issues. Collaborate with project managers, information systems owners, and cross-division technical staff in project execution, schedules, status reporting, and issue/risk management alignment. Support projects and run business activities by delivering defined scope within the data integration architecture for new and existing assets.

Learn and adhere to data integration development standards and best practices for design, coding, migration, and scheduling, as well as corporate and legal compliance guidelines.

Nice to Have

• Bachelor’s degree in computer science, MIS, or related field
• Knowledge of managed care and healthcare claims and membership domains
• Experience with Agile Development, DevOps, IT Service Management, and other development and support processes and methodologies
• Development experience using AWS Cloud Services (S3, Glue, IAM, Redshift etc.), Git (Gitlab), CI/CD pipelines
• Good understanding of data warehousing methodology, data design, and data modeling (3 Normal Form and Star Schema)
• Certifications related to data modeling or data warehousing are a plus
• Tools Experience: Visual Studio, SSMS, SSIS, SSRS, Jira, Microsoft Teams, ServiceNow

Required Skills and Experiences

• 5+ years of application development and integration experience, or related professional experience. All relevant experience including work, education, transferable skills, and military experience will be considered.
• 5+ years of SSIS Development experience, working with Visual Studio Database Projects, and handling unstructured data (XML, JSON etc.) formats
• Experience and understanding of Relational Database Management Systems (AWS RDS, MS SQL Server, Postgres, Oracle etc.). Preferred: Microsoft SQL Server
• Experience with Performance Tuning SQL Server Instances
• Experience working with customers across the enterprise to understand business questions and develop reporting and analytical solutions in support of those questions
• Strong Understanding of BI/ETL development in the IT industry with recent development, system administration, application tuning, and debugging experience
• Strong knowledge of Microsoft SQL Server including developing and implementing complex stored procedures, functions, views, triggers, and T-SQL
• Demonstrated proficiency using data visualization tools (e.g., Microsoft Power BI)
• Understanding of standards and best practices for data integration development practice and support
• Strong ability to meet tight deadlines and work under pressure
• Proven analytic and problem-solving skills used to craft, evaluate, and interpret data sets using SQL
• Proven experience in teamwork skills with multiple teams (Data analysts, data modelers, testers, DBAs, project managers, business areas, etc.) for project execution and issue resolution
• Demonstrated ability to present technical information to non-technical audiences and leadership
• Demonstr