Western Governors University

Data Engineer II

Western Governors University$118K — $178K *
Information Technology
Less than 5 years of experience
Job Overview by Ladders

Qualifications

  • Bachelor's degree in Management Information Systems, Computer Science, or related field.
  • 4 years of experience in Data Engineering, Integration, Big Data, Business Intelligence, or Software Engineering.
  • Knowledge of relational SQL and NoSQL databases.
  • Proficiency in object-oriented scripting languages like Python, Java, and Scala.
  • Experience with big data tools such as Hadoop, Spark, Kafka, and Databricks.

Responsibilities

  • Develops and builds ETL/ELT data pipelines for data analysis.
  • Creates and maintains optimal data pipeline architecture.
  • Monitors and maintains ETL/ELT jobs and troubleshoots load issues.
  • Delivers ad-hoc and analytical reports to internal users and teams.
  • Ingests and transforms both structured and unstructured data from various sources.

Benefits

  • Eligible for bonuses; comprehensive medical, dental, and vision insurance; mental health support.
  • Flexible health savings and spending accounts.
  • Generous paid time off policy with no accrual needed.
  • 11 paid holidays and up to 12 weeks of parental leave.
  • Discounted tuition at WGU and access to a wellbeing program.
Full Job Description
Job Description

The Big Data Developer will design how data will flow through hybrid data environments comprised of open source big data platforms and traditional database systems. The core responsibility for this position includes design of data and systems architecture for OLAP (data warehouse/ODS) and OLTP projects encompassing dimensional and normalized data modeling.

The Big Data Developer will improve technical standards in the environment ensuring optimal use of data warehouse and other data stores to solve business problems. The Big Data Developer will serve as the go to person for query performance and data quality issues including data profiling.

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.
  • Analyzes and understands data sources and designs a data model for data capture and ETL/ELT.
  • Identifies bugs, applies fixes, and checks data quality via process/pipeline audits.
  • Uses industry best practices for code development, testing, implementation, and documentation.
  • Performs other job-related duties as assigned.


Knowledge, Skills, and Abilities
  • Excellent verbal and written communication skills, along with technical documentation skills
  • 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
  • Knowledge and experience using tools like Jira, Confluence, and GitHub
  • Ability to develop processes for the audit of data integrity
  • Knowledge and experience with validation and testing development to analyze and debug issues
  • 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
  • 4 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


Job Description Disclaimer: This position description provides the major duties/responsibilities, requirements and working conditions for the position. It is intended to be an accurate reflection of the current position, however management reserves the right to revise or change as necessary to meet organizational needs. Other responsibilities may be assigned when circumstances require.

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.

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; and 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, and other paid leaves, including up to 12 weeks of parental leave.

How to Apply: If interested, an application will need to be submitted online. Internal WGU employees will need to apply through the internal job board in Workday.

About Western Governors University

Western Governors University (WGU) is a private, nonprofit online university based in Salt Lake City, Utah. The university was founded by 19 U.S. governors in 1997 with a mission to expand access to higher education. WGU offers undergraduate and graduate degree programs in business, information technology, education, and healthcare. The university is accredited by the Northwest Commission on Colleges and Universities and has been recognized by the White House as an example of excellence in education innovation. WGU has a competency-based learning model, which allows students to progress through their coursework at their own pace based on their mastery of the material.
Learn more about Western Governors University
Size
5,000 employees
Industry

Similar Jobs

More Jobs at Western Governors University

More Information Technology Jobs

Find similar Data Engineer II jobs: