Remote Data Scientist II: Research & GIS Analytics

UW School of Medicine and Public Health; Madison (WI); On-site; USD 72,000 - 88,000; Full time

Job summary

University of Wisconsin–Madison is seeking a Data Scientist II for the Office of Informatics to design, build, and maintain data pipelines, models, and visualizations to support research across stakeholders.

Responsibilities include integrating geospatial data, creating reusable data models, and delivering accessible insights. Strong SQL/Python skills and experience with GIS are required. This remote role emphasizes collaboration with researchers and analysts.

Qualifications

• Power BI, Tableau or similar dashboards for multiple stakeholders.
• Complex SQL queries for data extraction and transformation.
• Python for data processing, scripting, or automation.
• Ability to translate business needs into data visualizations.
• Strong analytical, problem-solving, and communication skills.

Responsibilities

• Develops and Maintains Data Solutions
• Design and build interactive visualizations for stakeholders
• Develop and maintain scalable data pipelines and data models for research and operations
• Incorporate geospatial data into dashboards and analytical workflows
• Ensure data visualization best practices and accessibility guidelines
• Data Integration and Transformation
• Develop and maintain data pipelines using SQL and Python
• Clean, transform, and validate datasets from multiple sources
• Create reusable data models and semantic layers within Power BI
• Support integration of GIS data sources into enterprise data environments
• Stakeholder Collaboration And Requirements Gathering
• 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 technical and non-technical audiences
• Documentation and Governance
• Document data sources, workflows, dashboards, and spatial data assets
• Support data governance, quality, and consistency standards
• Maintain version control and standard deployment processes
• Continuous Improvement and Support
• 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

Skills

Power BI

Tableau

SQL

Python

Data visualization

Communication

Analytical thinking

Education

Master's degree preferred

Tools

Power BI

GIS

Azure Synapse

Snowflake

Redshift

Job description

University of Wisconsin–Madison is seeking a Data Scientist II for the Office of Informatics to design, build, and maintain data pipelines, models, and visualizations to support research across stakeholders.

Responsibilities include integrating geospatial data, creating reusable data models, and delivering accessible insights. Strong SQL/Python skills and experience with GIS are required. This remote role emphasizes collaboration with researchers and analysts.