Senior Analyst, Data Design and Engineering

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

Job Function:

Job Sub Function:

Job Category:

All Job Posting Locations:

Job Description:

This role reports to the Data and Digital Manager within the Data Transformation & Business Intelligence (DTBI) team of the Data Digital and AI (DDAI) organization. The DTBI team provides data-transformation tools and services process management and governance and develops analytics tools and automated processes across JNJ Global Services.

The Data Design and Engineering Senior Analyst will be responsible for creating and delivering sophisticated workflows in our modernized GS Data Analytics Platform (GSIE) Databricks Alteryx/Dataiku and other business ETL tools. The analyst will design enrich and optimize the data-pipeline architecture as well as improve data flows and data collection across functions. The analyst will work closely with other technical and business solution architects data engineers data modelers data architects testers visualization analysts reporting and data-science teams and business leaders to execute strategic priorities and ensure consistent efficient data-delivery designs across projects.

Major Duties & Responsibilities

• Develop and maintain workflows transformation designs and integration activities for the GS Enterprise Data Lake & Analytics Platform (GSIE).

• Establish and enforce industry standards and best practices for data engineering across new and existing projects and datasets.

• Work independently and collaboratively with data professionals analytics specialists and technical and business leaders to gather functional and non-functional requirements assemble large sophisticated datasets and ensure system functionality.

• Create and maintain standardized governance for data modeling and transformation by defining and refining data relationships and structures (conceptual logical and physical models).

• Understand and maintain data lineage metadata and relationships.

• Ensure the Entity Relationship Diagram (ERD) is kept up to date.

• Identify design and implement internal process improvements for example automating manual processes optimizing data delivery and redesigning infrastructure for greater scalability.

• Build infrastructure for optimal extraction transformation and loading (ETL) from diverse data sources.

• Build analytics tools that leverage the data pipeline to deliver insights into customer experience operational efficiency and process effectiveness.

• Create data-modeling assets for visualization analysts and data scientists to support the development of effective and innovative data products.

• Contribute creative and innovative ideas to user-experience and technical design discussions.

• Develop and provide documentation training and support as requirements emerge.

• Perform other work-related duties as assigned.

Qualifications

• Required education: Bachelors degree (4-year) in a STEM field preferably Information Technology Computer Science or Management Information Systems/Technology.

• Intermediate to advanced SQL scripting skills and experience working with relational databases and/or data lakes such as Databricks (preferred) Snowflake PostgreSQL and Oracle.

• Advanced experience in schema design and a deep understanding of star schema entity-attribute modeling dimensional modeling metadata design data dictionaries and overall data governance.

• Intermediate to advanced Python skills (PySpark preferred) for building and optimizing big-data pipelines architectures and datasets.

• Experience performing root-cause analysis on internal and external data to identify gaps answer business questions and find opportunities for improvement.

• Strong analytical and problem-solving skills with experience working with structured and unstructured datasets.

• Experience building systems to support data transformation data structures metadata dependency and workload management and technical documentation.

• Experience manipulating processing and extracting value from large disparate datasets.

• Experience working in a global matrix organization and supporting cross-functional teams is highly preferred.

• Project-management experience as both a leader and a team member.

• Experience with cloud platforms such as Azure and GCP; AWS experience preferred.

• At least 2 years experience developing Alteryx or Dataiku workflows for data pipelines.

• Self-starter with the ability to proactively diagnose coordinate and resolve issues with minimal supervision.

• Outstanding attention to detail and strong due diligence is highly preferred.

As part of our Companys growth and expansion plans we are preparing to relocate to a new office in BGC Taguig City tentatively by note that the timeline may still change depending on project developments and other considerations.

Required Skills:

Preferred Skills: