Data Analyst (P-174)

smashcr; Dallas (TX); On-site; USD 90,000 - 140,000; Full time

Job summary

SMASH is seeking an experienced Technical Data Analyst to join our US-based team. You will work with large-scale datasets, cloud workflows, and modern data environments, applying SQL, Python, Spark, Spark SQL, PySpark, and Microsoft Azure to derive actionable insights.

You will collaborate with data engineers and business stakeholders, document data requirements, ensure quality, and contribute to scalable data processes.

Qualifications

• 5–6+ years of experience in technical Data Analyst or closely related data projects.
• Strong hands-on SQL
• Strong hands-on Python for data analysis and processing.
• Experience with Apache Spark and Spark SQL
• Hands-on PySpark experience
• Experience working within Microsoft Azure data environments

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

Apache Spark

Spark SQL

PySpark

Microsoft Azure

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