Associate Lead Data & Analytics

At Johnson & Johnsonwe believe health is everything. Our strength in healthcare innovation empowers us to build aworld where complex diseases are prevented treated and curedwhere treatments are smarter and less invasive andsolutions are our expertise in Innovative Medicine and MedTech we are uniquely positioned to innovate across the full spectrum of healthcare solutions today to deliver the breakthroughs of tomorrow and profoundly impact health for more at .

As guided by Our Credo Johnson & Johnson is responsible to our employees who work with us throughout the world. We provide an inclusive work environment where each person is considered as an individual. At Johnson & Johnson we respect the diversity and dignity of our employees and recognize their merit.

Job Function:

Job Sub Function:

Job Category:

All Job Posting Locations:

Job Description:

Associate Lead Data Analyst Commercial Strategy & Insights Orthopaedics

Locations: Pune Hybrid (3 Days from Office)

Reports to: DPS Commercial Strategy & Insights Team

Johnson & Johnson announced plans to separate our Orthopaedics business to establish a standalone Orthopaedics company operating as DePuy Synthes. The process of the planned separation is anticipated to be completed within 18 to 24 months subject to legal requirements including consultation with works councils and other employee representative bodies as may be required regulatory approvals and other customary conditions and approvals.

Should you accept this position it is anticipated that following conclusion of the transaction you would be an employee of DePuy Synthes and your employment would be governed by DePuy Synthes employment processes programs policies and benefit that case details of any planned changes would be provided to you by DePuy Synthes at an appropriate time and subject to any necessary consultation processes.

About DePuy Synthes

DePuy Synthes is a global leader in Orthopaedics advancing patient care through innovative solutions across joint reconstruction trauma spine sports medicine and related surgical technologies. As DePuy Synthes separates from Johnson & Johnson to become the worlds largest most comprehensive Orthopaedics-focused company the organization is entering a defining chapterestablishing its own corporate identity voice culture and reputation while continuing to serve patients customers and healthcare systems around the world.

Responsibilities & Scope

Johnson & Johnson is recruiting for an Associate Lead Data Analyst who will be responsible for building and operationalizing analytics capabilities using SQL Alteryx and Tableau for Global DPS Strategy & Insights. Youll use Alteryx to build a centralized data layer and Tableau to deliver dynamic dashboards for reporting. This role requires strong SQL skills experience managing large/complex datasets and a solid understanding of data integration and commercial/customer analytics. The successful candidate will translate raw data into reliable actionable insights and work directly with senior leadership and cross-functional partners.

Qualifications

Required qualifications

• Bachelors degree in Analytics Computer Science Statistics Mathematics or related field.

• 4-6 years of professional analytics and/or data engineering experience

• Strong business communication skills able to present technical findings to senior leadership and business partners.

• Organized detail-oriented with strong problem-solving skills and a solutions-first mindset.

• Proactive approach & Ability to prioritize and support multiple projects simultaneously

• Advanced SQL skills comfortable writing and optimizing complex queries (joins window functions CTEs partitioning/indexing logic).

• Hands-on experience with Alteryx for data preparation/ETL and with Tableau for dashboards and visual analytics.

• Demonstrated experience managing complex large-scale datasets and integrating multiple data sources into cohesive datasets.

Technical skills (must-haves)

• Advanced SQL and query performance tuning

• Alteryx (workflow design using Designer automation Alteryx Gallery)

• Tableau (dashboard design performance optimization)

• Data modelling fundamentals (dimensional/star schemas) and data lineage documentation

• Data quality validation and monitoring techniques

• Version control (git) or equivalent change-management practices

What success looks like (first 90 days)

• 30 days: Onboard to Team core systems and Datasets existing solutions & Analytics

• 60 days: Deliver a curated dataset or dashboard used by Sales/Account Management to make a commercial decision.

• 90 days: Own and maintain an ETL pipeline and dashboard suite with automated refresh via Alteryx Gallery.

Sample assessments for hiring / screening

• Live SQL exercise using a complex dataset focused on both correctness and performance.

• Take-home task: combine multiple data sources to produce a short executive summary a reproducible dataset (Alteryx/SQL steps) and a Tableau dashboard mock-up.

• Case study Round

Our team is built on open communication professional integrity and a commitment to developing people. Leaders provide regular mentorship and advocate for analysts to present findings directly to senior stakeholders. We value thoughtful risk-taking documented decision-making and a focus on measurable outcomes. If you are someone who pairs technical excellence with strong ethical judgement and wants to help shape commercial strategy youll fit right in.

Required Skills:

Preferred Skills: