Sr. Data Engineer

At Johnson & Johnson, we believe health is everything. Our strength in healthcare innovation empowers us to build a world where complex diseases are prevented, treated, and cured, where treatments are smarter and less invasive, and solutions are personal. Through 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 humanity. Learn more at jnj.com.

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.

We are searching for a talented and enthusiastic Modern Data Stack Data Engineer to join our growing team. You will be responsible for designing, building, and maintaining data pipelines using technologies like Fivetran, Databricks & Python into our Snowflake data warehouse and transforming the data using tools like dbt and Coalesce. You will also be responsible for ensuring data quality, security, and performance of the data pipelines. 

• Design, build, and launch sophisticated data models in snowflake that support multiple use cases across different products or domains.

• Assist in owning existing processes running in production, optimizing complex code through advanced algorithmic concepts.

• Document data pipelines and processes for maintainability and knowledge sharing.

• Solve our most challenging data integration problems, utilizing Fivetran, Python, DBT/Coalesce frameworks & query techniques, sourcing from structured and unstructured data sources.

• Primary sources include Oracle Fusion Cloud, Salesforce, Adaptive Planning among many other structured and unstructured data sources

• Implement data quality checks and monitoring processes to ensure data accuracy and consistency.

• Monitor and optimize data pipeline performance for efficiency and scalability.

• Troubleshoot and resolve data pipeline issues to ensure data availability.

• Create dashboards and advanced visualizations in Power BI.

• Implement data observability tools like Monte Carlo.

• Stay up to date on the latest trends and technologies in the modern data stack (Snowflake, Fivetran, Coalesce, etc.).

• 5+ years of experience as a Data Engineer or similar role.

• Bachelor’s degree required.

• Proven experience with designing and building data pipelines.

• Strong knowledge of Snowflake, SQL, Python and Snowflake

• Advanced experience with data modeling and data transformation techniques.

• Excellent problem-solving and analytical skills.

• Proficiency in extracting and loading data from the following two source applications - Oracle Fusion Cloud (Finance, Supply Chain, Manufacturing), Salesforce a huge plus 

• Ability to work independently and as part of a team.

• Interpersonal and communication skills to collaborate effectively with business partners and cross-functional teams.

• Strong strategic mindset with the ability to align analytics initiatives with overall business goals and proactively identify opportunities for leveraging data to drive business value.