Data Engineer

•      Design and develop reliable, reusable, automated ETL/ELT pipelines using Python, DBT, and SQL

•      Architect scalable table structures and data models (star/snowflake schemas, source-to-target maps, FQM) on Snowflake

•      Build data quality checks, reconciliation procedures, and automated audit/balancing controls

•      Design reporting applications ensuring underlying data sources support business requirements

•      Gather, document, and translate complex business requirements into data warehouse design artifacts

•      Lead application and technical architecture analysis, design, and implementation sessions

•      Proactively conduct data investigations and support business partners with complex ad-hoc analysis

•      Partner with data management and database specialists to troubleshoot and resolve issues

•      Mentor junior developers in BI solution design and development best practices

•      Provide production support including technical assistance to end-users and IT staff

•      Enforce metadata management and data quality standards through quality management reviews

•      Understand and troubleshoot configuration dependencies across the data warehouse and BI toolsets

•      Identify scope changes that could impact budget or delivery timelines and implement contingency plans

•      Proactively build and maintain relationships with business process owners across the organization

•      5+ years of hands-on ETL/ELT design and implementation experience (DataStage, Python, DBT, SQL)

•      Proven Snowflake experience — pipeline design, optimization, performance tuning, and security features

•      Demonstrated ability to build star/snowflake schema data models, Facts Qualifier Matrix (FQM), and source-to-target maps

•      Power BI dashboard development and data quality scorecard / lineage documentation

•      GitHub version control experience including collaborative development and code review workflows

•      VS Code proficiency as a primary development environment, including debugging workflows

•      Familiarity with CI/CD concepts and agile team environments

•      Strong written and oral communication skills with the ability to distill technical concepts for business audiences

•      Proven track record architecting small, medium, and enterprise-scale data solutions

•      3+ years of formal business requirements gathering experience

•      IBM Cognos experience (reporting authoring and/or administration)

•      Property and casualty insurance domain knowledge

•      Experience leading platform migration projects from legacy to modern data stacks