Senior Data Analyst
Role details
Job location
Tech stack
Job description
We are seeking a highly skilled and innovative Senior Data Analyst to become part of our Data Services team. This role requires someone with exceptional attention to detail, strong analytical abilities, and extensive experience in both data analysis and gathering data requirements. The successful candidate should be adept at collaborating across business and technology functions, demonstrating solid technical proficiency through hands-on involvement with data profiling, data mapping, and supporting data validation processes. Moreover, a thorough grasp of agile methodologies is crucial for success in our fast-paced and evolving environment.
Your 'day to day':
- Perform comprehensive data profiling to assess data consistency, completeness, uniqueness, and validity.
- Produce detailed profiling reports and communicate findings with data architect, data engineers, SMEs, and business stakeholders.
- Collaborate with data governance teams to define and create DQ rules across key dimensions such as accuracy, timeliness, validity, anomaly detection, and uniqueness.
- Create end-to-end source-to-target mapping for ingestion, transformation, and delivery layers.
- Work closely with data architect, data engineers to validate mapping logic, transformations, and business semantics.
- Ensure metadata completeness (column definitions, tags, PII classification, confidentiality levels) and consistency across source systems and target data models.
- Create SQL-based test queries to validate data transformations, mappings, business rules, and integration points.
- Document test evidence, summarize results, and ensure all approvals are captured in project artifacts.
- Partner with data engineers, data modelers, architects, and domain SMEs to deliver high-quality data solutions.
- Support data governance teams by providing inputs for classification, lineage enrichment, and metadata catalog updates.
Requirements
- 5+ years of experience as a Data Analyst, Data Quality Analyst, or similar role.
- Strong SQL skills for profiling, testing, and data validation across large distributed data sets.
- Prefer experience resource with Snowflake experience, Python and/or any scripting languages
- Experience with data quality tools, profiling frameworks, and metadata/catalog platforms (e.g., Atlan, Data Quality Monitoring, etc.).
- Good understanding of ETL/ELT processes, data modeling concepts, and enterprise data architectures.
- Prior experience creating source-to-target mappings and data transformation specifications.
- Strong technical, analytical, communication, and problem-solving skills.
- Legally authorized to work in the U.S.
- Fluent in English.
Benefits & conditions
Pet insurance, Health insurance, 401(k) matching, Paid time off, Vision insurance, Dental insurance, Commuter assistance, Annual Base Salary Range: $104,000-$130,000
What we offer
- We offer a competitive base salary, annual bonus (applicable based on level of position), great medical, dental and vision coverage, 401k with a generous company match, incredible wellness benefits, commuter benefits, pet insurance, generous PTO, and much more!
- We have implemented Smart Work, a hybrid model of working that promotes flexibility in the workplace.
- Seize the freedom to define your future and ours. We'll empower you to take risks, experiment and explore.
- Be part of an inclusive, diverse culture where everyone's contribution is respected; Collaborate with some of the world's best people and feel like you belong.
- Pursue your ambitions and develop your skills with a global business - our staggering size and scale provides endless opportunities to progress.
- Take pride in delivering our promise to society: To improve the lives of millions of smokers.
PMI is an Equal Opportunity Employer.