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-related data needs. This role involves designing, developing, and maintaining data pipelines and analytical tools to provide actionable insights for various stakeholders.
Responsibilities
- Organizes and automates project steps for data preparation and analysis
- Composes and assembles reproducible workflows and reports to clearly articulate patterns to researchers and/or administrators
- Prepares data sets for analysis including cleaning/quality assurance, transformations, restructuring, and integration of multiple data sources
- Documents approaches to address research questions and contributes to the establishment of reproducible research methodologies and analysis workflows
- 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
Skills
- Experience developing 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
- Professional experience developing Power BI or Tableau dashboards
- 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
Benefits
- Generous vacation, holidays, and sick leave
- Competitive insurances and savings accounts
- Retirement benefits
Company Overview