Data Scientist II

University of Wisconsin; Madison (WI); Hybrid; USD 72,000 - 88,000; Full time

Job summary

The University of Wisconsin–Madison’s School of Medicine and Public Health, Office of Informatics, Research Data Services, invites applications for a Data Scientist II to support research data needs. You will design, build, and maintain data pipelines, models, and dashboards (including GIS visualizations) and work with researchers to translate requirements into accessible insights.

Remote work is anticipated; starting salary is $80,000 annually and negotiable based on experience.

Qualifications

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

Responsibilities

• Develops and maintains data solutions including dashboards and data models.
• Design and build interactive visualizations for various stakeholder groups.
• Incorporate geospatial data into dashboards and workflows.
• Develop and maintain data pipelines using SQL and Python.
• Document data sources, workflows, and governance; ensure accessibility and quality.

Skills

Power BI

Tableau

SQL

Python

Data Visualization

Communication

Education

Master's degree preferred

Tools

Power BI Service

Azure

GIS tools

Job description

Current Employees: If you are currently employed at any of the Universities of Wisconsin, log in to Workday to apply through the internal application process.

Job Category:

Academic Staff

Employment Type:

Regular

Job Profile:

Data Scientist II

Job Summary:

The Office of Informatics is seeking an outstanding candidate for a Data Scientist II position to support research related data needs. The Data Scientist II will design, develop, and maintain data pipelines, data models, visualizations and analytical tools to support research and decision‑making across multiple stakeholder groups. This role works collaboratively with researchers, analysts, and other partners to transform complex data into accessible, actionable insights, including geospatial data and visualizations. The Data Scientist II will leverage SQL, Python, dashboarding and GIS tools to build scalable data solutions, create engaging visualizations and maps, and enable efficient data access for research use cases.

Key Job Responsibilities:

Develops and Maintains Data Solutions

• 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

Data Integration and Transformation

• 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

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 both 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

It is anticipated that this position will be remote and requires work be performed at an off‑site, non‑campus work location.

Key Job Responsibilities:

• 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

Department:

School of Medicine and Public Health, Office of Informatics, Research Data Services.

Compensation:

The starting salary for the position is $80,000 annually; but is negotiable based on experience and qualifications.

Employees in this position can expect to receive benefits such as generous vacation, holidays, and sick leave; competitive insurances and savings accounts; retirement benefits. For more information, refer to the campus benefits webpage.

SMPH Faculty /Academic Staff Benefits Flyer 2026

University sponsorship is not available for this position, including transfers of sponsorship and TN visas.The selected applicant will be responsible for ensuring their continuous eligibility to work in the United States (i.e. a citizen or national of the United States, a lawful permanent resident, a foreign national authorized to work in the United States without the need of an employer sponsorship) on or before the effective date of appointment.[This position is an ongoing position that will require continuous work eligibility If you are selected for this position you must provide proof of work authorization and eligibility to work.

Required Qualifications:

• 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

Preferred Qualifications:

• 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

Education:

Master's degree preferred

Contact Information:

Cody Roekle, [e-mail], 608-263-7676

Relay Access (WTRS): 7-1-1. See RELAY_SERVICE for further information.

Institutional Statement on Diversity:

Diversity is a source of strength, creativity, and innovation for UW-Madison. We value the contributions of each person and respect the profound ways their identity, culture, background, experience, status, abilities, and opinion enrich the university community. We commit ourselves to the pursuit of excellence in teaching, research, outreach, and diversity as inextricably linked goals. The University of Wisconsin-Madison fulfills its public mission by creating a welcoming and inclusive community for people from every background - people who as students, faculty, and staff serve Wisconsin and the world.

The University of Wisconsin-Madison is an Equal Opportunity Employer.

Qualified applicants will receive consideration for employment without regard to, including but not limited to, race, color, religion, sex, sexual orientation, national origin, age, pregnancy, disability, or status as a protected veteran and other bases as defined by federal regulations and UW System policies. We promote excellence by acknowledging skills and expertise from all backgroundsand encourage all qualified individuals to apply. For more information regarding applicant and employee rights and to view federal and state required postings, visit the Human Resources Workplace Poster website.

To request a disability or pregnancy-related accommodation for any step in the hiring process (e.g., application, interview, pre-employment testing, etc.), please contact the Divisional Disability Representative (DDR) in the division you are applying to. Please make your request as soon as possible to help the university respond most effectively to you.

Employment may require a criminal background check. It may also require your references to answer questions regarding misconduct, including sexual violence and sexual harassment.

The University of Wisconsin System will not reveal the identities of applicants who request confidentiality in writing, except that the identity of the successful candidate will be released. See Wis. Stat. sec. 19.36(7).

The Annual Security and Fire Safety Report contains current campus safety and disciplinary policies, crime statistics for the previous 3 calendar years, and on-campus student housing fire safety policies and fire statistics for the previous 3 calendar years. UW-Madison will provide a paper copy upon request; please contact the University of Wisconsin Police Department.