Note: The job is a remote job and is open to candidates in USA. The University of Wisconsin-Madison is seeking a Data Scientist II to support research data needs within its Office of Informatics. The role develops and maintains data pipelines, data models, dashboards, visualizations, and analytical tools, including geospatial solutions, while collaborating with researchers and stakeholders to transform complex data into actionable insights.
Responsibilities
- Design and build interactive visualizations for a variety of stakeholder groups
- Develop and maintain scalable data pipelines and data models to support research and operations
- Incorporate geospatial data into dashboards and analytical workflows where appropriate
- Ensure solutions follow data visualization best practices and accessibility guidelines
- Develop and maintain data pipelines using SQL and Python
- Clean, transform, and validate datasets from multiple sources, including spatial datasets
- Create reusable data models and semantic layers within Power BI
- Support integration of GIS data sources into enterprise data environments
- Translate requirements into technical solutions, including dashboards and geospatial visualizations
- Partner with stakeholders to understand research data needs, including location-based analysis
- Communicate insights effectively to both technical and non-technical audiences
- Document data sources, workflows, dashboards, and spatial data assets
- Support data governance, quality, and consistency standards
- Maintain version control and standard deployment processes
- Monitor and troubleshoot data pipelines, dashboards, and geospatial outputs
- Stay current with Azure, Power BI, GIS tools, and data engineering best practices
- Recommend enhancements to improve data accessibility, visualization, and spatial analysis capabilities
- Prepares data sets for analysis including cleaning/quality assurance, transformations, restructuring, and integration of multiple data sources
- Composes and assembles reproducible workflows and reports to clearly articulate patterns to researchers and/or administrators
- Organizes and automates project steps for data preparation and analysis
- Independently identifies and implements appropriate data science techniques to find data patterns and answer research questions chosen by the lead researcher including data visualization, statistical analysis, machine learning, and data mining
- Documents approaches to address research questions and contributes to the establishment of reproducible research methodologies and analysis workflows
Skills
- Professional experience developing Power BI, Tableau, or similar dashboards for multiple stakeholders
- Experience writing complex SQL queries for data extraction and transformation
- Experience using Python for data processing, scripting, or automation
- Demonstrated ability to translate business needs into data visualizations
- Strong analytical, problem-solving, and communication skills
- Experience with data modeling concepts (star schema, dimensional modeling)
- Familiarity with data warehousing platforms (e.g., Snowflake, Redshift, Azure Synapse)
- Experience with Power BI Service, including publishing and governance
- Knowledge of data governance, security, and best practices
- Experience working in a collaborative or matrixed environment
- Experience working with geographic information systems (GIS) and spatial data
- Ability to design and create engaging, user-friendly maps and geospatial visualizations for research and operational use cases
- Master's degree preferred
Benefits
- Generous vacation, holidays, and sick leave
- Competitive insurances and savings accounts
- Retirement benefits
- Remote work arrangement; it is anticipated that this position will be remote and requires work be performed at an offsite, non-campus work location.
Company Overview