Data Engineer
Must be located in the Eastern or Central US Time Zone
Travel: Occasional, based on project needs
Reports To: Chief Information Officer
We are seeking a skilled, hands-on Data Engineer to join our team. In this role, you will build, test, and maintain data pipelines and data warehouse components that support our broader data platform. You will help enable data-driven decision-making by ensuring business teams have access to clean, reliable, and well-modeled data.
As a Data Engineer, you will transform raw data into actionable insights by developing scalable pipelines, creating robust data models, and supporting reporting and analytics tools in partnership with the broader team.
Key Responsibilities
- Data Platform Development: Build and maintain data pipelines and data warehouse/lakehouse components (data warehouses, lakes, and marts) while following established data governance, security, and privacy controls.
- Pipeline Engineering: Develop reliable data ingestion pipelines using scheduled and event-driven patterns. Optimize performance and ensure resilience.
- Data Quality & Monitoring: Implement data quality frameworks, validation checks, and safeguards to minimize pipeline failures and data integrity issues.
- Architecture & Optimization: Contribute to improving legacy ingestion methods, address technical debt, and support impact assessment for proposed changes in partnership with the team.
- Reporting & Visualization: Build custom reports and dashboards using tools like Power BI, Snowflake, etc.
- Collaboration & Agile Delivery: Work closely with product owners and cross-functional teams to understand business needs, clarify requirements, and deliver solutions using agile methodologies.
- Automation & Efficiency: Identify inefficiencies, automate processes, and recommend improvements to optimize data flows.
- Documentation & Standards: Document pipelines, datasets, and data models; follow team standards; and participate in code reviews to improve maintainability and consistency.
- Production Support: Provide technical support for production incidents, ensuring system stability and continuous improvement.
Required Qualifications
Experience: 2–4 years in data engineering with experience in Snowflake, SQL, ELT/ETL, dimensional data modeling, data warehousing, and pipeline development.
Technical Skills:
- Strong SQL skills with experience in query optimization and basic performance tuning.
- Solid understanding of dimensional modeling and core data architecture principles.
- Familiarity with Azure cloud services.
- Experience with BI tools (Power BI & Snowflake).
- Knowledge of Agile/Scrum practices.
- Experience building dimensional (Kimball-style) data models.
Soft Skills:
- Excellent communication (written and verbal).
- Strong problem-solving and incident management capabilities.
- High attention to detail and commitment to data accuracy.
Preferred Qualifications
- Bachelor’s degree in Computer Science, Information Systems, or related field (or equivalent experience).
- Proficiency in programming languages such as Python or Java.
- Experience with orchestration tools and CI/CD pipelines (e.g., ADO YAML Pipelines or GitHub Actions).
- Familiarity with cloud platforms (Azure) and modern data tools (Snowflake).
- Exposure to machine learning/AI concepts.
- Experience working with APIs and integrating external data sources.
- Background in the insurance industry (including carrier experience) is a plus.
Technical Competencies
- Data Engineering: Experience building and supporting data warehouses/lakes, especially on Snowflake and Azure.
- Data Integration: Experience developing ELT/ETL pipelines using modern tools and scripting languages.
- Data Modeling: Proficient in logical and physical data modeling using relational and dimensional approaches.
- Performance Optimization: Experience tuning pipelines and database objects for optimal performance.
- Version Control & CI/CD: Familiarity with ADO YAML Pipelines or GitHub Actions and automated deployment practices.
- API Integration: Experience implementing and leveraging APIs for data exchange.
Compensation
- Commensurate with experience
- Performance-based incentives
Benefits Package
- 401(k) company match up to 6% eligible upon hire
- Medical, dental & vision, including company paid Life insurance and long-term disability
- Health care flexible spending accounts
- Paid time off
- Parental & family leave; military leave & pay
- Employee Referral Incentive
- Career Development & Continuing Education Assistance
Physical Conditions/Requirements
The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this position. Reasonable accommodations may be made to enable individuals with disabilities to perform the functions. While performing the duties of this position, the employee is regularly required to talk or hear. The employee frequently is required to use hands or finger, handle, or feel objects, tools or controls. The employee is occasionally required to stand; walk; sit; reach with hands and arms; climb or balance; and stoop, kneel, crouch, or crawl. The employee must occasionally lift and/or move up to 25 pounds. Specific vision abilities required by this position include close vision, distance vision, color vision, peripheral vision, and the ability to adjust focus. The noise level in the work environment is usually moderate.
