Data Engineer
- Glastonbury, CT
- $78,800-115,500 per year
- Permanent
- Full-time
- Design, build, and maintain reliable ETL/ELT pipelines using Azure Data Factory and related tools.
- Integrate data from Cosmos DB, SQL databases, Blob Storage, APIs, and other sources.
- Collaborate with the Data Architect to implement scalable data models and data lake patterns.
- Monitor pipeline performance, troubleshoot issues, and ensure high data availability and quality.
- Partner with analysts, developers, and business stakeholders to deliver trusted datasets and self-service capabilities.
- Contribute to data governance efforts by documenting flows, maintaining data lineage, and enforcing quality checks.
- Participate in proof-of-concept (POC) work to validate modern tools such as Fabric, Spark, or streaming ingestion.
- Bachelor's degree in Computer Science, Engineering, Information Systems, or related field (Master’s a plus)
- 3+ years of experience in a data engineering or related role
- Proficiency in SQL and Azure Data Factory (or equivalent orchestration tools)
- Experience working with cloud databases (e.g., Azure SQL, Cosmos DB, Synapse, Big Query)
- Strong understanding of data integration, performance tuning, and transformation logic
- Familiarity with data lake / lakehouse concepts and best practices
- Version control experience (e.g., Git) and scripting in Python or PowerShell
- Familiarity with data privacy regulations (e.g., GDPR, CCPA) and data governance frameworks
- Excellent problem-solving and analytical skills
- Strong written and verbal communication
- Ability to work independently and collaboratively in a cross-functional team
- Detail-oriented with a passion for clean, well-documented data
- Experience within the insurance industry is highly beneficial.
- Familiarity with cloud services, particularly Azure offerings and Serverless architectures.
- Exposure to Microsoft Fabric, data warehouse design, Apache Spark, or event-driven data architecture
- Experience building data solutions using Blob Storage, Logic Apps, or Databricks
- Familiarity DevOps/DataOps practices and CI/CD for data deployments
- Knowledge of data governance frameworks and tools
- Competitive compensation package
- Generous 401K employer match
- Employee Stock Purchase plan with employer matching
- Generous Paid Time Off
- Excellent benefits that go beyond health, dental & vision. Our programs are focused on your whole family’s wellness, including your physical, mental and financial wellbeing
- A core C&F tenet is owning your career development, so we provide a wealth of ways for you to keep learning, including tuition reimbursement, industry-related certifications and professional training to keep you progressing on your chosen path
- A dynamic, ambitious, fun and exciting work environment
- We believe you do well by doing good and want to encourage a spirit of social and community responsibility, matching donation program, volunteer opportunities, and an employee-driven corporate giving program that lets you participate and support your community