Associate Data Engineer

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

Benefits offered by this job

Bonuses

Health insurance

Tuition discount

Flexible PTO

11 holidays

Job summary

Western Governors University in Salt Lake City, UT seeks a data-focused developer to assist in researching, designing, developing, analyzing, testing, and implementing software systems. You will communicate project status and maintain documentation while supporting senior developers in data projects.

The role emphasizes building robust ETL/ELT pipelines, data ingestion from diverse sources, and working within an agile team to deliver timely solutions.

Qualifications

• Bachelor's Degree in Computer Science, Information Technology, or related field.
• Equivalent relevant experience may substitute for education (generally 1 year experience per 1 year of education).

Responsibilities

• Develops and builds ETL/ELT data pipelines for use in data analysis.
• Creates and maintains optimal data pipeline architecture.
• 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.
• Ingests and transforms data from relational databases, NoSQL, external APIs, JSON, XML, and delimited files.
• Works in an agile environment delivering in time for new development projects.

Skills

ETL/ELT pipelines

Data modeling

SQL

NoSQL

Python

Java/Scala

Agile

Education

Bachelor's Degree in CS/IT

Tools

SQL Databases

NoSQL

Hadoop

Spark

Kafka

Databricks

Job description

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.

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.

Grade: Technical 404. Pay Range: $81,300.00 - $121,900.00

Job Description

Assists in the research, design, development, analysis, testing, and implementation of software operating or application systems. Communicates project information to clients, project managers, or other design personnel working on projects. Writes and maintains complete documentation, and may support more senior developers in documentation. Supports team members and ensures established goals and deadlines are met, keeping management informed of status and significant problems.

Job Duties

• Develops and builds ETL/ELT data pipelines for use in data analysis
• Creates and maintains optimal data pipeline architecture
• 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
• 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, delivering efficient and effective solutions on time
• Performs other job-related duties as assigned

Knowledge, Skills & Abilities (KSAs)

• Ability to analyze and understand data sources and design a data model for data capture and ETL/ELT
• Ability to identify bugs, 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.

Minimum Qualifications

• Bachelor's Degree in Computer Science, Information Technology, or related field
• Practical experience with Web Services development
• Equivalent relevant experience may substitute for education (generally 1 year experience per 1 year of education, at hiring manager's discretion)

Preferred Qualifications

• Bachelor's Degree in Computer Science, Information Technology, or related field
• Previous experience in REST/SOA/HTML development
• Experience with python language
• Experience with IntelliJ/VS Code, JIRA, Git
• Experience with Agile/Scrum project development
• Experience with Java or a similar object-oriented language
• Experience with application integration with legacy systems
• Experience with cloud-native development and/or porting/refactoring of on-site to cloud (preferably AWS)
• Experience with JavaScript/TypeScript and a modern UI framework such as Angular, React, or Vue.js
• Experience with Oracle or other database interfaces
• Experience with mySQL or other database interfaces
• Technical certifications

Travel:

Up to 20%, including required attendance at designated company summits (typically 1-2 per year), plus occasional conferences, site visits, and other business-related events as needed.

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.

This position description reflects the major duties, requirements, and working conditions for the role. Management reserves the right to revise as needed to meet organizational needs.

Additional Information

Disclaimer: The job posting highlights the most critical responsibilities and requirements of the job. It’s not all-inclusive.

Accommodations: Applicants with disabilities who require assistance or accommodation during the application or interview process should contact our Talent Acquisition team at [e-mail].

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