Creating and maintaining optimal data pipeline architecture.
Enterprise pipeline orchestration set up administration (AWS Glue, Airflow, Fivetran)
Assembling large, complex data sets that meet functional & non-functional business requirements.
Identifying, designing, and implementing internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability.
Building the infrastructure required for optimal extraction, transformation and loading of data from a wide variety of data sources using relevant technologies.
Working with stakeholders to assist with data-related technical issues and support their data infrastructure needs.
Securing the data within our environment.
Working with our analytics experts to strive for greater functionality in our data systems.
Building processes supporting data transformation, data structures, metadata, dependency, and workload management.
Maintaining our data model.
Other duties as assigned.

Requirements

Bachelor’s degree in a relevant field is required.
Minimum 5 years’ experience in Data Engineering is required.
Advanced working SQL knowledge and experience working with relational databases is required.
Experience working with SQL Server is required.
Experience working with Python for at least 3 years’ is required.
Experience building and optimizing data pipelines, architectures, and data sets is required.
Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement is required.
Experience supporting and working with cross-functional teams in a dynamic environment.
Knowledge of Salesforce data structure is preferred.
Knowledge of working in Azure is preferred.

Benefits

Company Paid Basic Life & AD&D Insurance
Company Paid Short-Term and Long-Term Disability Insurance
Supplemental Life & AD&D; Short-Term Disability; Accident; Critical Illness; and Hospital Indemnity Insurance
Three medical plans offerings including two High Deductible Health Plans and a Traditional Co-Pay medical plan.
Health Savings Account (HSA) with company contributions on a per pay period basis if enrolled in either HDHP medical plan.
Two comprehensive Dental Plans
Vision Insurance Plan
Dependent Care Savings Account for child and dependent care.
14 Company Paid Holidays with a full week off at Thanksgiving.
Generous paid time off program for vacation and sick days
Employee Assistance Plan
Family Medical Leave
Paid Parental Leave (6 weeks)
Maternity benefits utilizing company paid STD, any supplemental STD, plus Parental Leave (6 weeks) to provide time for recovery, baby bonding, and enjoying your family time.
Adoption Assistance Reimbursement Program
Company Paid Concierge Services for you and your loved ones for the spectrum of caring needs for your aging parents, young children, life’s challenges and more.
401(k) Retirement Plan with both Traditional and Roth plans with per pay period match
Pet Insurance

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

data pipeline architectureAWS GlueAirflowFivetranSQLrelational databasesPythondata transformationdata structuresroot cause analysis

stakeholder communicationcross-functional teamworkprocess improvementproblem-solvingdynamic environment adaptability

Bachelor’s degree