Design, create, and modify SQL Server database tables and views to support new learning analytics use cases and evolving business logic
Perform controlled data updates or deletions, ensuring data integrity and recovery safeguards are in place
Validate and execute complex queries and scripts to maintain accurate data
Monitor and troubleshoot API integrations (e.g., Cornerstone) and update Python ETL scripts as needed
Integrate new or updated report views into ETL pipelines
Monitor daily automated ETL jobs, investigate failures, and rerun jobs following validation
Manage user access and security groups across Dev, QA, and Prod Power BI environments
Develop and maintain Power BI dataflows, dashboards, and visuals; schedule and monitor dataset refreshes
Execute deployments using Power BI Deployment Pipelines
Investigate and resolve data discrepancies, applying reconciliation and equivalency logic to learner records
Aggregate, standardize, and reconcile learning data sources

Requirements

Bachelor's degree and 5 or more years of technical experience in data engineering, business intelligence, or analytics (preferably within learning or HR domains)
Advanced proficiency in SQL Server, Python, ETL processes, and data modeling
Experience with data extraction and analysis technologies such as SAS, SPSS, QlikView, Hadoop, SQL or similar tools
Experience with API integrations (Cornerstone or other LMS preferred)
Hands-on expertise in Power BI development and administration
Strong understanding of data integrity, governance, and security best practices
Advanced experience working with big and complex data sets within large organizations
Proficiency in understanding healthcare-related data.

Benefits

Medical, dental and vision benefits
401(k) retirement savings plan
Paid time off (including paid time off, company and personal holidays, volunteer time off, paid parental and caregiver leave)
Short-term and long-term disability
Life insurance

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

SQL ServerPythonETL processesdata modelingdata extractiondata analysisPower BIAPI integrationsdata integritydata governance