Designs and performs data extraction, assessment, translation, transformation, and load (ETL) processes

In charge of building data equity, it's underlying code, tools, databases, and related infrastructure

Administers and maintains existing data engineering pipelines to their full extent of engineering needs

Translates strategic needs into engineering goals and milestones

Analyzes data needs and identifies available internal and external sources.

Utilizes business and analytical data modeling skills to design data integration and structure approaches.

Utilizes programming skills to access and extract data from diverse sources residing on multiple platforms and implement large, complex data models by combining, synthesizing and structuring data from databases, files and spreadsheets.

Assures data consistency and reliability. Performs quality checks, contributes to metadata and data dictionaries, documents repeatable extract, transform and load processes.

Provides coaching and guidance to less experienced engineers.

Bachelor's degree in Computer Science, MIS, or related field

The Insights team is cloud based and currently moving from Azure to AWS. We are responsible for providing various data points to the Field, allowing Financial Representatives and their leaders to track product sales, their compensation, CRM (Customer Relationship Management) activities, and planning metrics through our Book of Business application. This is a great opportunity to grow with a valuable team that delivers numerous reports to the field.

A Great Candidate Will Meet The Following Requirements

*5+ years of experience in BI tools, particularly on Power BI

*Experience working with AWS services like S3, EMR

*5+ years of work experience with ETL, data modeling and business intelligence big data architecture.

*5+ years of experience in analyzing large data sets to build reports and dashboards for decision making.

*2+ years of experience in Spark Development, with knowledge on Databricks platform

*Experience in automated deployment, CICD

*Understand the nature of distributed systems design

*Programming/Scripting/Query language: Java, Python, Apache Spark, SQL.

*Exceptionally self-motivated and directed

*Proven Analytical, evaluative and problem-solving capabilities.

Nice to have:

*Experience with traditional data marts/warehouses

*Experience with Apache Airflow

This job is not covered by the existing Collective Bargaining Agreement.

We are an equal opportunity/affirmative action employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, gender identity or expression, sexual orientation, national origin, disability, age or status as a protected veteran, or any other characteristic protected by law.