Data Engineer - Oklahoma City, United States - GradBay

Description

Job Title:
Data Engineer


Location:
Boston, MA

Salary:
$90,000 - $155,000 + benefits
The Company

A financial services and insurance company providing a range of financial products and services, including life insurance, retirement planning, investment management, and other financial solutions.

Their primary focus is on life insurance and related financial products, helping individuals and families with protection and planning for their financial futures.

Job Details
Our ideal Data Engineer is someone who is passionate about data.

You enjoy building data projects from the ground up and are equally comfortable working with business partners to understand requirements as you are developing and delivering robust solutions that meet the highest standards.

Learning new technologies and working in the cloud excite you. You are team oriented and a strong communicator.
Objectives of the role
Design, build and maintain complex ELT jobs that deliver business value
Translate high-level business requirements into technical specs
Ingest data from disparate sources into the data lake and data warehouse
Cleanse and enrich data and apply adequate data quality controls
Provide insight and direction to guide the future development of

Provide production support to existing data warehouse application and consumers, acting as the onshore point of contact and providing technical leadership to the offshore team.

Be willing to be on call and available to work on weekend or off hours for production support.
Develop re-usable tools to help streamline the delivery of new projects
Collaborate closely with other developers and provide mentorship
Evaluate and recommend tools, technologies, processes and reference
architectures
Work in an Agile development environment, attending daily stand-up meetings and delivering incremental improvements
Basic Qualifications
Bachelors degree in computer science, engineering or a related field
Data: 5+ years of experience with Data warehousing and analytics


SQL:
Strong knowledge of SQL programming and query optimization
ELT/


ETL:
Good understanding of ETL/ELT methodologies and tools

Troubleshooting:
Experience with troubleshooting and root cause analysis to determine and remediate potential issues

Communication:
Excellent communication, problem-solving and organizational and analytical skills
Able to work independently and to provide leadership to small teams of developers.
Preferred Qualifications
Masters degree in computer science, engineering or a related field

Cloud:
Experience working in a cloud environment (e.g. AWS)

Python:
Hands on experience developing with Python

Advanced Data Processing:
Experience using data processing technologies such as Apache
Spark or Kafka

Workflow:
Good knowledge of orchestration and scheduling tools (e.g. Apache Airflow)

Reporting:
Experience with data reporting (e.g. Microstrategy, Tableau, Looker) and data cataloging tools (e.g. Alation)

#J-18808-Ljbffr