Sr. Data Engineer
Brooksource
Fortune 50 Health Insurance Client
Remote
Overview: We are seeking a skilled Senior Developer with expertise in Snowflake to support our client's ongoing data warehouse migration and development efforts. This role is critical as they transition from their old SQL Server infrastructure to a modern Snowflake-based architecture. The ideal candidate will have a deep understanding of data engineering and analytics platforms, preferably in a healthcare setting, and will be able to get up to speed quickly to make an immediate impact.
Key Responsibilities:
- Collaborate with internal teams to architect, build, and optimize data marts in Snowflake.
- Assist in the migration from SQL Server to Snowflake, ensuring minimal disruption and maximum efficiency.
- Work closely with Snowflake to support code development, refactoring, and enhancement during the migration.
- Design and implement scalable data models that meet business needs, especially in the context of B2B data sharing.
- Support the long-term goal of fully transitioning to Snowflake while maintaining some legacy systems (e.g., on-prem SQL Server).
- Collaborate with the Managed Services team for testing and validation of data pipelines.
- Provide guidance and hands-on support to internal teams undergoing Snowflake training.
- Utilize Power BI, SQL, and Python for data visualization, querying, and data manipulation.
Required Skills and Experience:
- Snowflake Expertise: Proven experience in designing, developing, and optimizing Snowflake environments, with strong knowledge of Snowflake’s B2B data models.
- SQL Server Knowledge: Deep understanding of SQL Server, particularly in the context of migration to Snowflake.
- Data Modeling: Extensive experience with data modeling in a data warehousing environment.
- Power BI: Proficiency in Power BI for data visualization and reporting.
- SQL & Python: Strong skills in SQL and Python for data querying and manipulation.
- Healthcare Data: Experience with data engineering and analytics platforms in the healthcare sector, particularly home health, is a plus.
Preferred Qualifications:
- Familiarity with Homecare Homebase EMR or similar legacy systems.
- Experience navigating complex, regulated environments and managing the associated red tape.
- Ability to work independently and collaborate with cross-functional teams.
- Strong problem-solving skills and the ability to “get their hands dirty” quickly.