Sr. Data Engineer

Johnson & Johnson is hiring for a Sr. Data Engineer to join our team located in Shockwave Medical Costa Rica.

Position Overview

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. 

Essential Job Functions

• 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.).

Requirements

• 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.