Data Engineer

Western Governors University; Salt Lake City (UT); On-site; USD 98,000 - 147,000; Full time

Benefits offered by this job

Bonuses

Health benefits

Tuition discount

Flexible PTO

11 paid holidays

Parental leave

Job summary

Western Governors University seeks an Associate Data Engineer to build robust ETL/ELT pipelines for data availability across analysts and data scientists. The role involves coding and managing the development cycle of ETL/ELT jobs and BI reporting, following Agile practices for timely delivery and data quality through unit tests and monitoring.

Responsibilities include designing data models, data ingestion from diverse sources, and delivering complex reports and dashboards.

Qualifications

• Bachelor's Degree in MIS, CS, or related field.
• 2 years of experience in Data Engineering, Data Integration, Big Data, BI, or Software Engineering.
• Experience with relational SQL and NoSQL databases.

Responsibilities

• Develops and builds ETL/ELT data pipelines for data analysis.
• Creates and maintains optimal data pipeline architecture.
• Keeps data separated and secure across multiple cloud environments.
• Assembles large, complex data sets meeting functional/non-functional requirements.
• Delivers ad-hoc and analytical reports to internal users and teams.
• Monitors and maintains ETL/ELT jobs and troubleshoots load issues.
• Manages change requests/tickets for reports and ETL/ELT jobs.
• Performs data/tech discovery from new sources and third-party applications.
• Creates complex reports and dashboards in Cognos and Tableau.
• Ingests and transforms structured, semi-structured, and unstructured data from sources.
• Works in agile environment for new development projects.
• Delivers efficient and effective solutions on time.
• Performs other job-related duties as assigned.

Skills

ETL pipelines

Data modeling

SQL

NoSQL

Python/Java/Scala

Data quality

Agile

Reporting/BI

Education

Bachelor's Degree in MIS/CS

Tools

Cognos

Tableau

Hadoop

Spark

Kafka

Databricks

Cloudera/Impala

Hive

AngularJS/HTML5/CSS

Job description

Job Description

Salary range for this position takes into account the wide range of factors that are considered in making compensation decisions including but not limited to skill sets; experience and training; licensure and certifications; and other business and organizational needs. At WGU, it is not typical for an individual to be hired at or near the top of the range for their position, and compensation decisions are dependent on the facts and circumstances of each case. A reasonable estimate of the current range is: Grade: Technical 406 Pay Range: $98,300.00 - $147,400.00

The principal function of the Associate Data Engineer is to build robust ETL/ ELT pipelines to make data available to Data Analysts, Data Scientists, and other internal business units. The Data Engineer will be responsible for coding and working through the development cycle of ETL/ELT jobs and BI reporting. They will understand business requirements and design optimal ETL/ELT process for data acquisition, transformation, and publication for ease of analysis. The Data Engineer will follow agile development methodology for timely delivery of accurate data. They must have coding proficiency to write unit tests for pipeline functionality as well as data quality – this includes job monitoring, alerting, and code versioning and deployment. This position is also expected to develop, modify, and deploy formal and ad hoc reports.

Job Duties

• Develops and builds ETL/ELT data pipelines for use in data analysis.
• Creates and maintains optimal data pipeline architecture.
• Keeps data separated and secure across multiple cloud environments.
• Assembles large, complex data sets that meet functional and non-functional business requirements.
• Delivers ad-hoc and analytical reports to internal users and teams.
• Monitors and maintains ETL/ELT jobs and troubleshoots load issues.
• Manages change requests/ticket queues for analytical reports and ETL/ELT jobs.
• Performs data/technology discovery from new sources and third-party applications for data ingestion.
• Creates complex reports and dashboards in Cognos and Tableau.
• Ingests and transforms structured, semi-structured, and unstructured data from sources including relational databases, NoSQL, external APIs, JSON, XML, delimited files, and more.
• Works and delivers in agile methodology for new development projects.
• Delivers efficient and effective solutions on time.
• Performs other job-related duties as assigned.

KSAs

• Ability to analyze and understand data sources and design a data model for data capture and ETL/ELT
• Ability to identify bugs and apply fixes and check data quality via process/pipeline audits
• Ability to work with team members, as well as cross-team for product delivery
• Ability to work in an agile environment with timely delivery of ETL/ELT pipelines and reports
• Ability to deal with a variety of variables under limited standardization
• Ability to interpret various instructions
• Ability to communicate clearly, effectively, and appropriately with all audiences
• Ability to work independently, is self-motivated, and a strong team player
• Use of industry best practices for code development, testing, implementation and documentation
• Experience with relational SQL and NoSQL databases
• Knowledge and experience with object-oriented/object function scripting languages, like Python, Java, and Scala
• Knowledge and experience with big data tools, like Hadoop, Spark, Kafka, Databricks, etc.
• Exposure to analytical reporting tools, preferably Cognos and Tableau
• Knowledge and experience with Cloudera or Horton, Impala, Hive, AngularJS, HTML5, and CSS/LESS

Minimum Qualifications

• Bachelor's Degree in Management Information Systems, Computer Science, or a related field
• 2 years of experience in Data Engineering, Data Integration, Big Data, Business Intelligence, or Software Engineering
• Equivalent relevant experience performing the essential functions of this job may substitute for education degree requirements. Generally, equivalent relevant experience is defined as 1 year of experience for 1 year of education and is the discretion of the hiring manager.

Preferred Qualifications

• Higher Education Domain Exposure

Position & Application Details

• Full-Time Regular Positions (classified as regular and working 40 standard weekly hours)
• This is a full-time, regular position (classified for 40 standard weekly hours) that is eligible for bonuses
• medical, dental, vision, telehealth and mental healthcare
• health savings account and flexible spending account
• basic and voluntary life insurance
• disability coverage
• accident, critical illness and hospital indemnity supplemental coverages
• legal and identity theft coverage
• retirement savings plan
• wellbeing program
• discounted WGU tuition
• flexible paid time off for rest and relaxation with no need for accrual
• flexible paid sick time with no need for accrual
• 11 paid holidays
• other paid leaves, including up to 12 weeks of parental leave

This position requires occasional travel of up to 20%, including required attendance at designated company summits (typically one to two per year). Additional travel may include conferences, visits to company locations, and other business-related events as needed. Additional travel may be assigned as needed to support business requirements.

Equal Employment Opportunity: All qualified applicants will receive consideration for employment without regard to any protected characteristic as required by law.

In 1997, a coalition of 19 U.S. governors founded Western Governors University with a singular vision: to make higher education more accessible by offering full degree programs online. Starting small, we quickly expanded. Today, we’re one of the largest accredited online universities in the U.S.