Data Analyst (P-174)

SMASH; Town of Texas (WI); On-site; USD 90,000 - 140,000; Full time

Job summary

SMASH in Wisconsin is seeking an experienced Technical Data Analyst to join our data team. You will work with large-scale datasets, write advanced SQL queries, and leverage Python, Spark, and Spark SQL to transform data and deliver actionable insights.

The role emphasizes Azure cloud environments and collaboration with business stakeholders. Familiarity with Microsoft Fabric is a plus; prior pharma, life sciences, or insurance experience is valued.

Qualifications

• 5–6+ years of experience working on technical Data Analyst or closely related data projects.
• Strong hands-on SQL experience.
• Strong hands-on Python experience for data analysis and processing.
• Experience with Apache Spark.
• Strong experience with Spark SQL.
• Hands-on experience with PySpark.
• Experience working within Microsoft Azure data environments.
• Experience analyzing and transforming large and complex datasets.
• Strong understanding of data structures, data quality, and data validation.
• Strong analytical and problem-solving skills.
• Ability to independently investigate technical data issues and drive them toward resolution.
• Strong communication skills and ability to collaborate across technical and business teams.

Responsibilities

• Analyze complex and large-scale datasets to identify trends, patterns, anomalies, and actionable insights.
• Develop advanced SQL queries to extract, transform, validate, and analyze data.
• Use Python and PySpark for data processing, transformation, automation, and analysis.
• Work with Apache Spark and Spark SQL to process and analyze large datasets efficiently.
• Support data analysis initiatives within Microsoft Azure environments.
• Collaborate with technical and business stakeholders to understand data requirements and translate them into analytical solutions.
• Perform data profiling, validation, reconciliation, and quality analysis to ensure accuracy and consistency.
• Investigate data issues and perform root-cause analysis across datasets and data workflows.
• Support the development and improvement of scalable data processes and analytical solutions.
• Document data requirements, business rules, analytical findings, and technical processes.
• Communicate technical findings clearly to both technical and non-technical stakeholders.

Skills

SQL

Python

Spark

Spark SQL

PySpark

Microsoft Azure

Tools

Microsoft Fabric

Job description

SMASH, Who we are?

We believe in long-lasting relationships with our talent. We invest time getting to know them and understanding what they seek as their professional next step.

We aim to find the perfect match. As agents, we pair our talent with our US clients, not only by their technical skills but as a cultural fit. Our core competency is to find the right talent fast.

We purposefully move away from the “contractor” or “outsourcing” type of relationship. Our clients don’t want contractors or “just a service.” Neither does our talent.

This position and offers the opportunity to work with a US-based company. To be eligible for this role, you must have US Citizenship or valid US work authorization.

Role Summary

We are looking for an experienced Technical Data Analyst with a strong background in data analysis, large-scale data processing, and cloud-based data environments.

The ideal candidate will bring hands-on expertise with SQL, Python, Spark, Spark SQL, PySpark, and Microsoft Azure and will be comfortable working with complex datasets and technical data workflows. Experience with Microsoft Fabric and within the Pharmaceutical, Life Sciences, or Insurance industries will be highly valued.

Responsibilities

• Analyze complex and large-scale datasets to identify trends, patterns, anomalies, and actionable insights.
• Develop advanced SQL queries to extract, transform, validate, and analyze data.
• Use Python and PySpark for data processing, transformation, automation, and analysis.
• Work with Apache Spark and Spark SQL to process and analyze large datasets efficiently.
• Support data analysis initiatives within Microsoft Azure environments.
• Collaborate with technical and business stakeholders to understand data requirements and translate them into analytical solutions.
• Perform data profiling, validation, reconciliation, and quality analysis to ensure accuracy and consistency.
• Investigate data issues and perform root-cause analysis across datasets and data workflows.
• Support the development and improvement of scalable data processes and analytical solutions.
• Document data requirements, business rules, analytical findings, and technical processes.
• Communicate technical findings clearly to both technical and non-technical stakeholders.

Requirements – Must-haves

• 5–6+ years of experience working on technical Data Analyst or closely related data projects.
• Strong hands-on SQL experience.
• Strong hands-on Python experience for data analysis and processing.
• Experience with Apache Spark.
• Strong experience with Spark SQL.
• Hands-on experience with PySpark.
• Experience working within Microsoft Azure data environments.
• Experience analyzing and transforming large and complex datasets.
• Strong understanding of data structures, data quality, and data validation.
• Strong analytical and problem-solving skills.
• Ability to independently investigate technical data issues and drive them toward resolution.
• Strong communication skills and ability to collaborate across technical and business teams.

Nice-to-haves (optional)

• Hands-on experience with Microsoft Fabric – strongly preferred.
• Pharmaceutical industry experience.
• Life Sciences industry experience.
• Insurance industry experience.
• Experience working with enterprise-scale cloud data platforms.
• Exposure to modern data engineering, data lake, or data warehouse architectures.

Languages

• English C1
• Spanish C1