- Build and maintain a SQL Server data warehouse, including ETL processes sourcing from multiple enterprise applications and SharePoint.
- Replace cursor-based data cleansing routines in SQL Server with Python-based processing.
- Design pipeline orchestration, credential, and secrets management for scheduled jobs and data connections.
- Establish source control and dependency management practices for reproducible analytical code.
- Conduct statistical analysis, regression, predictive modeling, and machine learning to support organizational projections.
- Design, build, and maintain Power BI semantic models, reports, and dashboards.
- Develop custom visualizations programmatically in Python and produce publication-quality tabular output.
- Produce and maintain technical documentation, system maps, and process flow diagrams.
- Respond to ad hoc data calls from senior leadership and program stakeholders.
PythonSQLETL+3 more