Specialist Data Engineering (Philadelphia or Cedar Rapids)

Transamerica Corporation; United States; On-site; USD 130,000 - 150,000; Full time

Job summary

An established industry player is seeking a Specialist in Data Engineering to design and develop modern architectures that drive data-driven business strategies. This role involves collaborating with cross-functional teams to build robust data solutions and pipelines, ensuring the efficient handling of both structured and unstructured data. The ideal candidate will possess significant experience in data engineering, big data technologies, and cloud environments, with a strong focus on scalability and efficiency. Join a forward-thinking company that values innovation and offers a comprehensive benefits package, including competitive pay and opportunities for professional development.

Benefits

Pension Plan

401k Match

Employee Stock Purchase Plan

Tuition Reimbursement

Disability Insurance

Medical Insurance

Dental Insurance

Vision Insurance

Paid Time Off

Employee Assistance Program

Qualifications

• 6+ years in data engineering, analytics, and data warehousing.
• Experience with big data technologies and cloud environments.
• Strong SQL skills for data profiling and analysis.

Responsibilities

• Collaborate with engineers and data scientists in an agile setting.
• Design and support cloud and on-premises data infrastructure.
• Lead development of data APIs and delivery services.

Skills

Data Engineering

Data Modeling

Data Analytics

Big Data Technologies

ETL Concepts

SQL

Linux Operations

DevOps

Analytical Skills

Problem-Solving Skills

Education

Bachelor’s degree in Computer Science

Master’s degree in a Technical Field

Tools

AWS Services (Lambda, EC2, S3, etc.)

Apache Kafka

Apache Spark

Terraform

Cloud Formation

Job description

Specialist Data Engineering

Apply

locations: Work From Home, USA

time type: Full time

posted on: Posted Yesterday

job requisition id: R20057836

Job Family: IT Operations

Job Description Summary:

The Specialist, Data Engineering is focused on the design and development of modern architectures to enable data-driven digital business across the enterprise. Helps define data strategies, grow capabilities, and develop the enterprise data platform by providing technology leadership, insight on new developments within the data engineering space, and guidance in architectural and design decisions.

Responsibilities:

• Work collaboratively with other engineers, data scientists, analytics teams, scrum masters 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.
• Lead the selection and integration of data related tools, frameworks and applications required to expand our platform capabilities.
• Understand and implement best practices in management of enterprise data, including master data, reference data, metadata, data quality and lineage.
• Participate in an Agile implementation and maintenance of source control and release procedures.
• Be an effective communicator while interacting with technical and non-technical audiences.
• Communicate with business stakeholders to understand goals and translate them to technical solution architecture and requirements.
• Have an iterative, collaborative and transparent approach to building technical solutions and data products.
• Lead and mentor other data engineers to follow best engineering practices.
• Produce technical solutions that satisfy business requirements with a focus on scalability, stability, efficiency, maintainability and extensibility.

Qualifications:

• Bachelor’s degree in computer science, math, engineering, or relevant technical field.
• Six years of collective experience in the application of data engineering, data modeling, data analytics, data warehousing, business intelligence, database administration and data integration concepts and methodologies.
• Five years of experience architecting, building, and administering big data and real-time streaming analytics architectures in on-premises and cloud environments using technologies like Kinesis, Apache Kafka, Apache Spark.
• Four years of experience architecting, building, and administering large-scale distributed applications frameworks like Spark, Hadoop etc.
• Three years of experience with Linux operations and development, including basic commands and shell scripting.
• Three years of experience executing DevOps, DevSecOps methodologies and continuous integration/continuous delivery.
• Strong understanding of ETL concepts and REST-oriented APIs for creating and managing data integration jobs.
• Experience with AWS services like Lambda, EC2, EMR, EKS, Redshift, Glue, S3, IAM, RDS, Aurora, DynamoDB etc.
• Knowledge of cloud networking, security, storage, and compute services.
• Infrastructure provisioning experience using Cloud Formation, Terraform etc.
• Data Modeling experience in NoSQL databases like Dynamo DB, Cassandra.
• Demonstrated skills in detailed-oriented delivery management.
• Expertise in SQL for data profiling, analysis, and extraction.
• Familiarity with data science techniques and frameworks.
• Results oriented and with a strong customer focus.
• Creative thinker with strong analytical and problem-solving 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).
• Software development experience in relevant programming languages (e.g. Java, Python, Scala, Node.js).
• Understanding of big data and real-time streaming analytics processing architecture and data lake 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.
• Experience with implementing RESTful APIs and Microservices using the design-first approach and focused on asset reusability.
• Relevant technology or platform certification (AWS Solutions Architect Associate or AWS Data Engineer or AWS Solutions Architect Professional).

Working Conditions:

• Office environment: hybrid or remote location.
• Moderate travel (under 10% expected).

Compensation:

The Salary for this position generally ranges between $130,000 - $150,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.

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.

What We Offer:

For eligible employees, we offer a comprehensive benefits package designed to support both the personal and financial well-being of our employees.

• Competitive Pay
• Bonus for Eligible Employees

Benefits Package:

• Pension Plan
• 401k Match
• Employee Stock Purchase Plan
• Tuition Reimbursement
• Disability Insurance
• Medical Insurance
• Dental Insurance
• Vision Insurance
• Employee Discounts
• Career Training & Development Opportunities

Health and Work/Life Balance Benefits:

• Paid Time Off starting at 160 hours annually for employees in their first year of service.
• Ten (10) paid holidays per year (typically mirroring the New York Stock Exchange (NYSE) holidays).
• Be Well Company holistic wellness program, which includes Wellness Coaching and Reward Dollars.
• Parental Leave – fifteen (15) days of paid parental leave per calendar year to eligible employees with at least one year of service at the time of birth, placement of an adopted child, or placement of a foster care child.
• Adoption Assistance
• Employee Assistance Program
• College Coach Program
• Back-Up Care Program
• PTO for Volunteer Hours
• Employee Matching Gifts Program
• Employee Resource Groups
• Inclusion and Diversity Programs
• Employee Recognition Program
• Referral Bonus Programs

Inclusion & Diversity:

We believe our commitment to diversity and inclusion creates a work environment filled with exceptional individuals.

Giving Back:

We believe our responsibilities extend beyond our corporate walls.

Transamerica’s Parent Company:

Aegon acquired the Transamerica business in 1999.