Senior Data Warehouse Engineer

Summary

Join BETSOL, a leading digital transformation company, as a highly skilled Data Warehouse Engineer. You will play a crucial role in designing and implementing cutting-edge data pipeline infrastructures and models for our health plan solution. This senior position requires extensive ETL and data warehousing experience. You will work extensively with external data sources, build data marts, and prepare for a cloud migration. Success requires expertise in data pipelines, data warehousing, and excellent communication. BETSOL offers a comprehensive benefits package, including health insurance, 401K, and remote work options.

Requirements

• 8-10 years of experience as a Data Engineer
• Strong ETL experience (SSIS, data warehousing concepts)
• Experience with bringing external data sources into data marts
• Strong business knowledge of health plan operations and data
• Bachelor's degree in a technical, scientific, and/or healthcare discipline; or equivalent work experience
• Epic Cogito, Clarity, and Caboodle certifications are required within 120 days of hire
• All certifications must be maintained throughout employment

Responsibilities

• Develop and maintain data pipelines, API-based or file-based data flows between source systems and the data warehouse
• Use innovative tools and techniques to automate common data preparation and integration tasks with the goal of reducing defects and ensuring data quality
• Implement best practices to ensure the integrity of data with exception-handling routines
• Provides source to target mapping development, support, and maintenance
• Lead troubleshooting efforts and formulate interdisciplinary task force groups for ETL issues
• Design, develop, and deploy data structures and data transformations in the enterprise data warehouse using Python, SSIS, ADF
• Maintain and extend the Epic Caboodle platform and develop custom Caboodle data modeling components
• Form relationships and coordinate with business stakeholders to identify data needs, clarify requirements, and implement solutions
• Contribute to the department's short-term and long-term strategic plan
• Make appropriate recommendations on the management of data extraction, and analysis
• Maintain knowledge of the current regulations and technologies related to data management
• Assist with data governance initiatives in the areas of data quality, data security, metadata, and master data management
• Actively contribute to all aspects of the data project lifecycle including request intake and acknowledgment, project estimation, time-tracking, and prioritization of tasks
• Be an exemplary team player with excellent collaboration skills
• Exhibit outstanding customer service skills with stakeholders
• Perform other duties as required or assigned

Preferred Qualifications

• Health plan experience
• In-depth knowledge of SQL, data warehouses, and data transformation techniques
• Proven experience with designing and building data pipelines
• Expert knowledge of metadata management and related tools
• Advanced knowledge of data ETL concepts, processes, and tools such as MS SSIS, ADF
• Advanced knowledge of Python
• Ability to read and understand various data structures
• Ability to work independently and as part of a team
• Strong analytical, technical, and troubleshooting skills
• Ability to assess requirements from multiple sources and their impact on potential solutions
• Ability to work in a complex environment
• Ability to be organized and proficient at tracking tasks, defining next steps, and following project plans
• Advanced knowledge of database and data warehousing concepts, including data lakes, relational and dimensional database design concepts, and data modeling practices
• Intermediate knowledge of Jupyter Notebooks
• Familiarity with Agile project management methods such as SCRUM, Lean, and/or Kanban
• Advanced knowledge of healthcare data structures, workflows, and concepts, from Electronic Health Record systems like Epic
• Knowledge of Azure cloud platform, Fabric data platform, ADF, and DevOps

Benefits

• Comprehensive health insurance
• Competitive salaries
• 401K
• Volunteer programs
• Scholarship opportunities
• Fitness center
• Cafe
• Recreational facilities
• Remote