Lead Data Engineer overseeing engineers and advancing the data platform at American Family Insurance. Creating tools and infrastructure to empower teams across the company.
About the role
- Data Engineer at Love, Bonito optimizing data pipelines and ensuring data quality for analytics. Collaborating on data architecture, operations, and compliance for effective data management.
Responsibilities
- Update documentation of existing data pipelines to establish clear operational standards and knowledge transfer
- Refactor legacy code to improve scalability, performance and maintainability
- Optimise aggregation layers and transformation logic for reporting workloads
- Reduce pipeline runtimes through strategic improvements in query optimisation, partitioning and resource allocation
- Review and enhance data models supporting analytics, reporting and machine learning use cases
- Design and implement efficient data structures that balance query performance with storage costs
- Collaborate with analytics and data science teams to ensure data models meet downstream requirements
- Implement comprehensive data quality checks and validation frameworks within pipelines
- Develop unit tests for data transformations to ensure correctness and prevent regressions
- Monitor data integrity throughout the pipeline lifecycle
- Establish and maintain data quality metrics and alerting mechanisms
- Troubleshoot pipeline failures and implement root cause analysis
- Design and deploy preventative measures to minimize future incidents
- Maintain pipeline uptime targets of 99%
- Ensure SLA adherence across critical data workflows
- Maintain data security, governance and compliance standards across all data assets
- Implement access controls and data lineage tracking
- Ensure adherence to regulatory requirements and internal data policies
Requirements
- Bachelor's degree in Computer Science, Engineering, or a related field.
- 2-4 years data engineering experience
- Proven track record of building and maintaining production data pipelines at scale
- Strong problem-solving skills with focus on systematic root cause analysis
- Excellent communication skills for technical documentation and cross-functional collaboration
- Core Stack
- Data Warehousing: Experience with cloud data warehouses (Redshift, BIgQuery) or lakehouse architectures
- AWS Cloud Services: Working knowledge of S3, IAM, EC and related services
- Programming: Strong Python skills with focus on PySpark, SQL, Scala for ETL
- DevOps & Engineer Practices
- Containerisation (Docker, Kubernetes)
- CI/CD pipelines and version control (Git, GitHub Actions)
- Preferred Qualifications
- cExperience optimisation aggregation layers for high-volume reporting workloads
- Familiarity with Delta Lake and lakehouse design patterns
- Background in distributed computing and Spark performance tuning
- Infrastructure as code and automated deployment practices
Job title
Job type
Experience level
Salary
Not specified
Degree requirement
Tech skills
Location requirements
Working Student contributing to data engineering projects for AI/ML workflows while gaining hands - on experience with data pipelines and tools.
Data Architect designing end - to - end Snowflake data solutions and collaborating with technical stakeholders at Emerson. Supporting the realization of Data and Digitalization Strategy.
Manager of Data Engineering leading data assets and infrastructure initiatives at CLA. Collaborating with teams to enforce data quality standards and drive integration efforts.
Data Engineer building modern Data Lake architecture on AWS and implementing scalable ETL/ELT pipelines. Collaborating across teams for analytics and reporting on gaming platforms.
Chief Data Engineer leading Scania’s Commercial Data Engineering team for growing sustainable transport solutions. Focused on data products and pipelines for BI, analytics, and AI.
Entry - Level Data Engineer at GM, focusing on building large scale data platforms in cloud environments. Collaborating with data engineers and scientists while migrating systems to cloud solutions.
Data Engineer designing and building scalable ETL/ELT pipelines for enterprise - grade analytics solutions. Collaborating with product teams to deliver high - quality, secure, and discoverable data.
Data Engineer responsible for data integrations with AWS technology stack for Adobe's Digital Experience. Collaborating with multiple teams to conceptualize solutions and improve data ecosystem.
People Data Architect designing and managing people data analytics for Gen, delivering actionable insights for HR. Collaborating across teams to enhance data - driven decision - making.