Data Engineer at Western Governors University in Salt Lake City, UT

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. 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 Job Description 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 plays a key role in making reliable, secure, and accessible data available to Data Analysts, Data Scientists, and internal business teams. You will build and maintain robust ETL/ELT pipelines, transform complex data from a wide range of sources, and deliver reporting solutions that help teams turn data into actionable insights What You’ll Do Develop and build ETL/ELT data pipelines for use in data analysis and maintain optimal data pipeline architecture. Assemble large, complex data sets that meet functional and non-functional business requirements while keeping data separated and secure across multiple cloud environments. Ingest and transform structured, semi-structured, and unstructured data from relational databases, NoSQL databases, external APIs, JSON, XML, delimited files, and other sources. Monitor and maintain ETL/ELT jobs, troubleshoot load issues, identify bugs, apply fixes, and perform pipeline audits to support data quality. Deliver ad-hoc and analytical reports to internal users and create complex reports and dashboards in Cognos and Tableau. Manage change requests and ticket queues for analytical reports and ETL/ELT jobs, including data and technology discovery for new sources and third-party applications. Work collaboratively in an agile environment to deliver efficient and effective data pipelines and reporting solutions on time. What You’ll Bring 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. Ability to analyze and understand data sources and design a data model for data capture and ETL/ELT. 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. Ability to communicate clearly and effectively, work independently and cross-functionally, and use industry best practices for code development, testing, implementation, and documentation. Equivalent relevant experience performing