The Sr Associate Data Analytics is responsible for designing, building, maintaining, analyzing, and interpreting data to provide actionable insights that drive business decisions. This role involves working with large datasets, developing reports, supporting and executing data governance initiatives and visualizing data to ensure data is accessible, reliable, and efficiently managed. The ideal candidate has strong technical skills, experience with big data technologies, and a deep understanding of data architecture and ETL processes
Roles & Responsibilities:
Analyze complex datasets (pricing, rebates, provider contracting, market access) using Excel, SQL, and Databricks to create reports, dashboards, and analytics-ready datasets that drive decision-making.
Identify trends, anomalies, and opportunities within large-scale datasets, delivering actionable insights and strategic recommendations in partnership with business teams.
Clean, organize, and validate data for accuracy and consistency; build and maintain ETL/ELT workflows (Databricks, Spark, SQL); apply data quality checks, dictionaries, and governance standards.
Collaborate with cross-functional teams (pricing, contracting, finance, product, and data science) to integrate data from multiple sources (cloud storage, APIs, SQL databases) and bridge technical and business needs.
Automate ingestion, preparation, and reporting pipelines with Databricks Jobs and scheduling tools, ensuring timely delivery of datasets and insights.
Optimize queries, transformations, and Spark jobs for scalability and performance, applying caching, partitioning, and indexing techniques.
Document data sources, methodologies, and business rules clearly; communicate insights through structured reports, visualizations, and presentations; adhere to governance, security, and privacy requirements.
Coordinate with global stakeholders across time zones to support reporting needs, troubleshoot issues, and align on priorities; contribute to agile practices such as sprint planning and estimations.
Own and maintain SDLC documentation using Agile tools such as Jira and Confluence
Basic Qualifications and Experience:
Any degree with a 5 - 9 years of experience in Computer Science, IT or related field
Functional Skills:
Must-Have Skills
Hands-on experience with big data technologies and platforms such as Databricks and Apache Spark (PySpark, SparkSQL), including workflow orchestration and performance tuning for large-scale data processing.
Proficiency in SQL and advanced Excel (pivot tables, lookups, advanced formulas) for data analysis, with experience generating clear, actionable reports and summaries.
Excellent problem-solving skills with the ability to work with large, complex datasets to identify trends, anomalies, and actionable insights.
Strong understanding of data governance frameworks, tools, and best practices, with knowledge of data protection regulations.
Strong understanding of Agile, Scrum, Design Thinking, and Lean Startup principles.
Experience working in DevOps teams, utilizing tools like Jira.
Experience with AWS Services (e.g., EC2, S3, Redshift/Spectrum, Lambda).
Ability to automate workflows using Databricks Jobs, notebooks, and scheduling tools, ensuring timely delivery of analytics and reports.
Experience with data visualization tools (Power BI, Tableau, or equivalent) to present insights effectively to business stakeholders.
Understanding of data modeling, data warehousing, and data integration concepts to support analytics readiness.
Good-to-Have Skills:
Experience with ETL tools such as Apache Spark, and familiarity with various Python packages related to data processing and machine learning model development.
Knowledge of Python/R, SageMaker, and cloud data platforms (AWS preferred, Snowflake exposure a plus).
Familiarity with healthcare, pharmaceutical market access, pricing, rebates, or contracting datasets to provide context-driven analytics.
Professional Certifications (Preferred):
Certified Data Engineer / Data Analyst (preferred on Databricks and cloud environments)
Soft Skills:
Excellent critical-thinking and problem-solving skills
Strong communication and collaboration skills
Demonstrated awareness of how to function in a team setting
Demonstrated presentation skills and public speaking skills
Ability to work effectively with global, virtual teams
High degree of initiative and self-motivation
Team-oriented, with a focus on achieving team goals
Shift Information:
This position requires you to work a later shift and may be assigned a second or third shift schedule. Candidates must be willing and able to work during evening or night shifts, as required based on business requirements.
.