Data Engineer II

If you’re passionate about building a better future for individuals, communities, and our country—and you’re committed to working hard to play your part in building that future—consider WGU as the next step in your career.

Driven by a mission to expand access to higher education through online, competency-based degree programs, WGU is also committed to being a great place to work for a diverse workforce of student-focused professionals. The university has pioneered a new way to learn in the 21st century, one that has received praise from academic, industry, government, and media leaders. Whatever your role, working for WGU gives you a part to play in helping students graduate, creating a better tomorrow for themselves and their families.

Job Profile Summary:

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.

Essential Functions and Responsibilities:

· Develop and build ETL/ELT data pipelines for use in data analysis.

· Create and maintain optimal data pipeline architecture.

· Keep our data separated and secure across multiple cloud environments.

· Assemble large, complex data sets that meet functional / non-functional business requirements.

· Deliver ad hoc and analytical reports to internal users and teams.

· Monitor and maintain ETL/ELT jobs and troubleshoot load issues.

· Manage change requests/ticket queues for analytical reports and ETL/ELT jobs.

· Perform data/technology discovery from new sources and third-party applications for data ingestion.

· Create complex reports and dashboards in Cognos and Tableau.

· Ingest and transform structured, semi structured and unstructured data from sources including relational databases, NoSQL, external APIs, JSON, XML, delimited files, and more.

· Work and deliver in agile methodology for new development projects. Deliver efficient and effective solutions on time.

· Ability to analyze and understand data source 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 agile environment with timely delivery of ETL/ ELT pipelines and reports.

· Use of industry best practices for code development, testing, implementation and documentation

Knowledge, Skill and Abilities:

· Excellent verbal & written communication, along with technical documentation

· Ability to work and deliver in a team environment

· Experience in tools like Jira, Confluence, GitHub

· Develop processes for audit of Data Integrity

· Validation and testing Development to analyze and debug issues

· Experience with relational SQL and NoSQL databases

· Experience with object-oriented/object function scripting languages: Python, Java, Scala

· Experience with big data tools: Hadoop, Spark, Kafka, Databricks, etc.

· Exposure to analytical reporting tools, preferably Cognos and tableau

· Experience with:

o Cloudera or Horton

o Impala

o Hive

o AngularJS

o HTML5

o CSS/LESS

Competencies:

Organizational or Student Impact:

· Works on assignments of medium to complex level.

· Structure project plans and manages cost-effective execution of tasks.

· Limit errors to prevent impact to client operations, costs, or schedules.

· This individual will follow established processes and protocols.

Problem Solving & Decision Making:

· Individual meets department and personal goals with some direction/ supervision.

· An important player on large technical projects and programs.

· Uses discretion to help design and implement solutions to somewhat complex problems.

Communication & Influence:

· Communicates with contacts both within and outside of function on matters that require explanation, interpretation, and advising; typically has responsibility communicating to parties outside of the organization.

· Works to influence parties within the function at an operational level regarding policies, practices, and procedures.

Leadership & Talent Management:

· May be responsible for providing guidance, coaching, and training to other employees within the technical area.

· May manage technical projects at this level, requiring responsibility for the delegation of work and reviewing others’ work products.

Job Qualifications:

Minimum Qualifications:

· Subject matter expert in the area of responsibility or working knowledge of several technical areas.

· Typically requires a technical university degree or equivalent experience.

· 4 years of prior relevant experience.

· Advanced degrees (Master’s or PhD) may be required for certain disciplines and reduce the experience requirement by 2-4 years. Industry-relevant experience.

Department Specific Minimum Qualifications:

• B. S. in Business, Management Information Systems, Computer Science, or a related field, or an equivalent combination of experience and training.

• Three or more years of experience as a Data Engineer, Data Integration, Big Data, or Business Intelligence, Software Engineer

Preferred Qualifications:

· Higher Education Domain exposure

Physical Requirements:

· Prolonged periods sitting at a desk and working on a computer.

· Must be able to lift up to 15 pounds at times.

Disclaimer: This Job Description has been designed to indicate the general nature, essential duties, and responsibilities of work performed by employees within this classification. It does not contain a comprehensive inventory of all duties, responsibilities, and qualifications that are required of the employee to do this job. Duties, responsibilities and activities may change at any time with or without notice. This Job Description does not constitute a contract of employment and the University may exercise its employment-at-will rights at any time.

#LI-Remote

The 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:
 

Pay Range: $95,900.00 – $143,800.00

WGU will accept applications for this position until 12:00 AM ET, 01/31/2025

How to apply: apply online

Full-time Regular Positions (FT classification, standard working hours = 40)

This is a full-time, regular position 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.

The University is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status.