Sr. Data Engineer

Johnson & Johnson Johnson & Johnson · Pharma · Alajuela, Costa Rica

Sr. Data Engineer responsible for designing, building, and maintaining data pipelines using technologies like Fivetran, Databricks, Python into Snowflake, and transforming data using dbt and Coalesce. The role involves ensuring data quality, security, and performance, creating dashboards in Power BI, and implementing data observability tools like Monte Carlo.

What you'd actually do

  1. Design, build, and launch sophisticated data models in snowflake that support multiple use cases across different products or domains.
  2. Assist in owning existing processes running in production, optimizing complex code through advanced algorithmic concepts.
  3. Document data pipelines and processes for maintainability and knowledge sharing.
  4. Solve our most challenging data integration problems, utilizing Fivetran, Python, DBT/Coalesce frameworks & query techniques, sourcing from structured and unstructured data sources.
  5. Implement data quality checks and monitoring processes to ensure data accuracy and consistency.

Skills

Required

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

Nice to have

  • Proficiency in extracting and loading data from the following two source applications - Oracle Fusion Cloud (Finance, Supply Chain, Manufacturing), Salesforce a huge plus
  • Advanced Analytics
  • Analytical Reasoning
  • Business Behavior
  • Coaching
  • Database As A Service (DBaaS)
  • Data Engineering
  • Data Modeling
  • Data Privacy Standards
  • Data Quality
  • Data Science
  • Data Structures
  • Design Thinking
  • Problem Solving
  • Project Management
  • Requirements Analysis
  • Technologically Savvy