Data Analyst (P-174)

Smash CR; Dallas (TX); On-site; USD 90,000 - 130,000; Full time

Job summary

Smash CR is seeking an experienced Technical Data Analyst to advance large-scale data processing and cloud-based environments.

The ideal candidate will bring hands-on SQL, Python, Spark, Spark SQL, PySpark, and Microsoft Azure expertise, with preferred experience in Microsoft Fabric and industries like Pharmaceutical, Life Sciences, or Insurance.

Qualifications

• 5–6+ years of experience in 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

Data analysis

Communication

Problem solving

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 experiencedTechnical Data Analystwith a strong background in data analysis, large-scale data processing, and cloud-based data environments.

The ideal candidate will bring hands‑on expertise withSQL, Python, Spark, Spark SQL, PySpark, and Microsoft Azureand will be comfortable working with complex datasets and technical data workflows. Experience withMicrosoft Fabricand within thePharmaceutical, Life Sciences, or Insuranceindustries 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 experienceworking on technical Data Analyst or closely related data projects.
• Strong hands‑onSQLexperience.
• Strong hands‑onPythonexperience for data analysis and processing.
• Experience withApache Spark.
• Strong experience withSpark SQL.
• Hands‑on experience withPySpark.
• Experience working withinMicrosoft Azuredata 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 withMicrosoft 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