Lead Data Engineer

Aegon; Philadelphia, Cedar Rapids, Denver (Philadelphia County, IA, CO); Hybrid; USD 107,000 - 135,000; Full time

Benefits offered by this job

Annual bonus based on performance

Job summary

Aegon in Philadelphia seeks a Lead Data Engineer to design and support data systems that drive enterprise-wide data-driven decisions. Candidates must have extensive experience in data engineering and analytics, particularly in big data environments.

The position offers a hybrid work model, requiring three days in the office weekly. The salary range is $107,000 - $135,000 annually, with eligibility for a performance-based bonus. Applicants must be authorized to work in the U.S.

Qualifications

• Five years of experience in data engineering and data analytics.
• Four years of experience with big data and streaming analytics architectures.
• Three years of experience with Linux operations and DevOps methodologies.

Responsibilities

• Design and support the data infrastructure and tools for data collection and analysis.
• Develop data APIs and services for operational processes.
• Lead the automation of data ingestion and processing pipelines.

Skills

Data engineering

Data analytics

Big data

SQL

DevOps methodologies

Technical communication

Education

Bachelor’s degree in computer science or relevant field

Master’s degree in a technical field (preferred)

Tools

ETL tools

Data visualization tools

Snowflake

Job description

Overview

The Lead Data Engineer is responsible for the design, architecture and support of systems, services and applications required for the collection, storage, processing, and analysis of all forms of data to enable data-driven decisions and outcomes across the enterprise.

Responsibilities

• Work collaboratively with other engineers, data scientists, analytics teams, and business product owners in an agile environment:
• Architect, build, and support the operation of Cloud and On-Premises enterprise data infrastructure and tools.
• Design robust, reusable and scalable data driven solutions and data pipeline frameworks to automate the ingestion, processing and delivery of both structured and unstructured batch and real-time streaming data.
• Lead the development of data APIs and data delivery services to support critical operational processes, analytical models and machine learning applications.
• Assist the selection and integration of data related tools, frameworks and applications required to expand platform capabilities.
• Understand and implement best practices in management of enterprise data, including master data, reference data, metadata, data quality and lineage.

Qualifications

• Bachelor’s degree in computer science, math, engineering, or relevant technical field
• Five years of collective experience in the application of data engineering, data analytics, data warehousing, business intelligence, database administration and data integration concepts and methodologies
• Four years of experience architecting, building, and administering big data and real-time streaming analytics architectures in on-premises and cloud environments
• Three years of experience architecting, building and administering large-scale distributed applications
• Three years of experience with Linux operations and development, including basic commands and shell scripting
• Three years of experience executing DevOps methodologies and continuous integration/continuous delivery
• Demonstrated skills in delivery of high-quality technical project solutions
• Expertise in SQL for data profiling, analysis, and extraction
• Familiarity with data science techniques and frameworks
• Creative thinker with strong analytical skills
• Results oriented with a strong customer focus
• Ability to work in a team environment
• Strong technical communication skills
• Ability to prioritize work to meet tight deadlines
• Ability to learn and keep pace with the latest technology advances and quickly grasp new technologies to support the environment and contribute to project deliverables

Preferred Qualifications

• Master’s degree in a technical field (e.g. computer science, math, engineering)
• Understanding of big data and real time streaming analytics processing architecture and ecosystems
• Experience with data warehousing architecture and implementation, including hands on experience with source to target mappings and developing ETL code
• Experience with advanced analytics and machine learning concepts and technology implementations
• Experience with data analysis and using data visualization tools to describe data
• Relevant technology or platform certification (AWS, Microsoft, etc.)
• Experience with Snowflake

Working Conditions

• Hybrid-Office Environment (Tuesdays, Wednesdays, Thursdays)
• Occasional Travel <10%

This job description is not a contract of employment nor for any specific job responsibilities. The Company may change, add to, remove, or revoke the terms of this job description at its discretion. Managers may assign other duties and responsibilities as needed. In the event an employee or applicant requests or requires an accommodation to perform job functions, the applicable HR Business Partner should be contacted to evaluate the accommodation request.

Compensation

The Salary for this position generally ranges between $107,000 - $135,000 annually . Please note that the salary range is a good faith estimate for this position and actual starting pay is determined by several factors including qualifications, experience, geography, work location designation (in-office, hybrid, remote) and operational needs. Salary may vary above and below the stated amounts, as permitted by applicable law.

Additionally, this position is typically eligible for an Annual Bonus based on the Company Bonus Plan/Individual Performance and is at the Company’s discretion.

Applicants must be authorized to work for any employer in the U.S. We are unable to sponsor or take over sponsorship of an employment Visa at this time.

This is a hybrid position requiring three days in office per week in one of our hub locations (Philadelphia, PA; Cedar Rapids, IA; Denver, CO). Relocation assistance will not be provided for this position.