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 managing data pipelines and analytics for strategic data projects in corporate environments. Working with data governance, integration, and BI initiatives.
Responsibilities
- Develop and maintain data ingestion, transformation and loading pipelines (ETL/ELT) from multiple sources (APIs, relational databases, files, legacy systems and cloud)
- Work on data modeling (Data Lake, Data Warehouse and Data Marts), ensuring performance, scalability and governance
- Process large volumes of data using Spark (PySpark or Scala) and Big Data frameworks
- Develop scripts and automations in Python for data extraction, integration and processing
- Create and optimize advanced SQL queries (procedures, views, functions, jobs), with a focus on performance
- Work in cloud environments (GCP, Oracle Cloud, Azure or similar), participating in data migration and modernization projects
- Integrate data across different platforms and systems (e.g., CRM, marketing, surveys, corporate systems)
- Support the development of dashboards and reports in Power BI, ensuring reliable data for analysis and decision-making
- Collaborate with business, analytics and technology teams to understand requirements and translate them into data solutions
- Document processes, models and data pipelines, following engineering and governance best practices
Requirements
- Proven experience as a Data Engineer or in similar roles
- Advanced SQL proficiency, including query optimization and database objects
- Strong experience in ETL/ELT using tools such as PowerCenter, Pentaho, Databricks, SSIS or equivalents
- Practical knowledge of Python for data engineering and automation
- Experience with distributed processing (Spark – PySpark or Scala)
- Experience in cloud environments (Google Cloud, Oracle Cloud, Azure or similar)
- Experience with Data Lakes, Data Warehouses and data modeling
- Knowledge of data integration via APIs, files and secure transfer (SFTP)
- Ability to communicate with technical and business stakeholders
Benefits
- Remote work
- Join a high-performance team
- Opportunities for professional development
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.