Data Engineer

Skills

• Strong proficiency in SQL and ETL/ELT tools.
• Experience with Liquibase for database schema management.
• Proficiency in DBT for data transformation and orchestration.
• Python scripting for automation and data manipulation.
• Understanding of Medallion Architecture principles.
• Knowledge of Conformed Dimensions for dimensional modeling.
• Familiarity with cloud data platforms such as AWS, Azure, or Google Cloud.
• Working knowledge of BI visualization tools like Power BI or Tableau.
• Understanding of API usage and integration methods.
• Strong problem-solving, logical, and analytical skills.
• Effective communication and collaboration skills.

Responsibilities

• Develop, maintain, and monitor ETL/ELT pipelines from multiple internal and external data sources.
• Design and implement data solutions following Medallion Architecture principles.
• Manage and enforce Conformed Dimensions across data marts and warehouses.
• Optimize SQL queries and data normalization routines for efficiency.
• Utilize Liquibase for database change management and version control.
• Build and maintain data transformation workflows using DBT.
• Collaborate with data scientists, analysts, and developers to meet business requirements.
• Automate data ingestion, transformation, and validation processes to ensure quality.
• Manage data lakes, data marts, and warehouse environments for analytics.
• Build and maintain APIs and data connectors for system integration.
• Implement data governance and security best practices.
• Identify and recommend process improvements and automation opportunities.
• Ensure data integrity and confidentiality in compliance with policies.

Education

• Bachelor’s degree in Computer Science, Data Science, Engineering, or related field preferred.
• Master’s degree preferred but not required.
• Equivalent experience may be considered.
• Experience in insurance, health, or risk management industries is a plus.

Benefits