Data Engineer II - Mexico

at  Western Governors University

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.

REQUIRED SKILLS

• 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.

REQUIRED EXPERIENCE AND/OR EDUCATION

• B. S. in Business, Management Information Systems, Computer Science, or a related field, or an equivalent combination of experience and training.
• 3 or more years of experience as a Data Engineer, Data Integration, Big Data, or Business Intelligence, Software Engineer

ABOUT THE ROLE:

The principal function of the Data Engineer II 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 II 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.