Analytics Engineer (Remote)

eLearning

This recruitment is managed by the Office of Human Resources at the Columbia Campus. For application questions please contact OHR at 573-882-7976.

The Solutions and Analytics Team within Mizzou Online delivers scalable, high-performing analytic dashboards, reports, and insights to stakeholders. We are seeking an analytics engineer to help clean, curate and refine data from a variety of higher education sources. The ideal candidate will work closely with data analysts to ascertain the data elements, formats and structure needed for analysis.

The Analytics Engineer will also be required to attend the annual on-site Mizzou Online All Staff Retreat and as business needs dictate. Travel for this position is expected to be minimal.
The ideal candidate will have the following qualities:

Engaged
Autonomous and collaborative
Motivated
Flexible
Persistent
Willing to learn
Dependable

Key Responsibilities:

Produce curated/refined data sets suitable for analysis. This process will involve cleaning, filtering, aggregating, and transforming raw data using SQL and/or Python.

SQL Expertise: Write, optimize, and maintain SQL queries to extract, manipulate, and transform data from various databases and sources. GCP BigQuery knowledge is a plus, but not required.

Data Validation: Utilize data validation processes to ensure data accuracy, consistency, and completeness. Collaborate with cross-functional teams to resolve data discrepancies and anomalies.

Documentation: Produce and maintain comprehensive documentation of SQL queries, data lineage, data validation processes, and data analysis methodologies.

Continuous Improvement: Stay up to date with industry best practices, tools, and emerging technologies related to data management. Proactively identify opportunities for process improvement.

Monday - Friday, 8am-5pm CST

The required 'minimum qualifications' established for this position are a bachelor's degree and at least 4 years of experience (or an equivalent combination of education, training and experience).

Excellent SQL skills

Passion for creating high-quality datasets suitable for analysis

Strong communication skills, with the ability to convey complex technical findings to non-technical stakeholders.

Ability to work independently and collaboratively in a team-oriented environment.

Experience working in Higher Education and/or working with Higher Education datasets, (e.g., IPEDS, Slate, Canvas, student information systems)

Python (or similar) experience

Experience with data visualization tools (e.g PowerBI)

Knowledge of data controls and applicable regulatory/legal requirements (HIPAA, FERPA, GLBA, FTC, PCI, etc.) in protecting confidential and/or sensitive data.

Excellent analytical and problem-solving skills with attention to detail.

Salary Range: $62,000 - $72,000 per year
Grade: GGS 011
University Title: Programmer Analyst
Internal applicants can determine their University title by accessing the Talent Profile tile in myHR.

Resume and Cover Letter

Applicants must be authorized to work in the United States. The University will not sponsor applicants for this position for employment visas.

Columbia offers small-town friendliness with big city features and a high quality of life for people of all ages and interests. Founded on education and known as an ideal college town, its location also makes it an attractive spot for businesses and travelers. Located on Interstate 70 and U.S. Highway 63, Columbia is right in the middle of the state and the nation. Just a couple hours' drive from St. Louis and Kansas City, Columbia is Boone County's largest population center offering big-city culture, activities, and resources with a low cost of living. Columbia is home to a variety of restaurants and entertainment venues and hosts more than a dozen festivals each year. If you want to grow your career, continue your education, raise a family, and retire, Columbia is a good place to be!

This position is eligible for University benefits. As part of your total compensation, the University offers a comprehensive benefits package, including medical, dental and vision plans, retirement, paid time off, short- and long-term disability, paid parental leave, paid caregiver leave, and educational fee discounts for all four UM System campuses. For additional information on University benefits, please visit the Faculty & Staff Benefits website at https://www.umsystem.edu/totalrewards/benefits.

Equal Employment Opportunity

The University of Missouri is an Equal Opportunity Employer.

To request ADA accommodations, please call the Director of Accessibility and ADA at 573-884-7278.