Data Engineer || Databricks,, Power BI, Data Modeling (US Time zone working hours) IRC299932

Description

Covetrus is a global animal-health technology and services leader dedicated to empowering veterinary practice partners to drive improved health and financial outcomes. We bring together products, services, and technology into a single platform that connects our customers to the solutions and insights they need to work best.The Data Platform team is on a mission to build and operate a governed, analytics-ready data platform that ingests operational data, applies shared business rules, and serves as a trusted source of truth to customer-facing and internal reporting. This hands-on role contributes across the entire lakehouse architecture—from ingestion through dimensional modeling to consumption-ready facts and dimensions—delivering reliable, well-tested data products alongside senior engineers to support the organization’s strategic goals.

Requirements

COMPETENCIES (SKILLS AND ABILITIES)

– Strong verbal and written communication skills, with the ability to convey technical concepts to both technical and non-technical audiences.

– Proficient SQL — window functions, MERGE/upsert patterns, and incremental processing.

– Proficiency in Python for data ingestion, orchestration, and pipeline tooling.

– Hands-on experience with Apache Spark and Delta Lake (or comparable distributed/lakehouse technology).

– Solid understanding of dimensional modeling (facts, dimensions, slowly-changing dimensions) and broader data-modeling fundamentals.

– Experience building and maintaining batch and/or incremental pipelines, including monitoring and troubleshooting.

– Understanding of architectural trade-offs — when to favor batch, incremental, or streaming approaches, and how each balances data freshness, latency, cost, and operational complexity.

– Willingness to collaborate, share knowledge, and grow toward greater technical ownership.

– Working experience with Databricks (declarative pipelines / Delta Live Tables, serverless SQL warehouses, Unity Catalog, job orchestration) preferred.

– Exposure to streaming and event-driven architectures (e.g., Kafka) is a plus.

– Familiarity with Terraform / Infrastructure-as-Code is a plus.

– Experience supporting BI/reporting consumers (e.g., Power BI, embedded customer-facing reports) and turning business rules into trustworthy metrics is a plus.

– Domain experience with transactional, point-of-sale, invoicing, financial, or animal-health data is a plus.

Professional Credentials

A Databricks Certified Data Engineer Associate credential or a comparable industry certification is highly desirable.

Core Competencies

• Technical Communication: Excellent written and oral skills with the capacity to explain complex technical topics to diverse audiences.
• Advanced SQL & Python: Mastery of SQL (including MERGE patterns and window functions) and proficiency in Python for pipeline orchestration and data ingestion.
• Data Architecture: Practical experience with Apache Spark, Delta Lake, and Lakehouse technologies, alongside a firm grasp of dimensional modeling and SCD strategies.
• Pipeline Operations: Proven ability to build, monitor, and troubleshoot batch and incremental pipelines while evaluating architectural trade-offs between cost, latency, and complexity.
  
  
  

Job responsibilities

ESSENTIAL DUTIES AND RESPONSIBILITIES Include The Following.

– Build and maintain ingestion pipelines from source systems into the lakehouse, across both batch and streaming patterns.

– Contribute to decisions about the platform’s processing strategy — weighing batch vs. incremental vs. streaming approaches against freshness requirements, cost, and operational complexity.

– Develop and optimize silver- and gold-layer transformations using declarative ETL — including SCD Type 1 and Type 2 handling, fact and dimension tables, incremental merge logic, and change-detection strategies.

– Translate business logic into reusable, well-tested pipeline components.

– Contribute to platform infrastructure as code and the CI/CD path that deploys it.

– Follow and help uphold engineering standards — code review, testing, observability, and operational runbooks.

– Investigate and resolve performance, cost, and data-quality issues across the pipeline, escalating complex trade-offs as needed.

– Collaborate with senior engineers, stakeholders, and downstream consumers to support data contracts and SLAs.

– Support the onboarding of new data sources as the platform scales.

What we offer

Empowering Projects: With 500+ clients spanning diverse industries and domains, we provide an exciting opportunity to contribute to groundbreaking projects that leverage cutting-edge technologies. As a team, we engineer digital products that positively impact people’s lives.

Empowering Growth: We foster a culture of continuous learning and professional development. Our dedication is to provide timely and comprehensive assistance for every consultant through our dedicated Learning & Development team, ensuring their continuous growth and success.

DE&I Matters: At GlobalLogic, we deeply value and embrace diversity. We are dedicated to providing equal opportunities for all individuals, fostering an inclusive and empowering work environment.

Career Development: Our corporate culture places a strong emphasis on career development, offering abundant opportunities for growth. Regular interactions with our teams ensure their engagement, motivation, and recognition. We empower our team members to pursue their career goals with confidence and enthusiasm.

Comprehensive Benefits: In addition to equitable compensation, we provide a comprehensive benefits package that prioritizes the overall well-being of our consultants. We genuinely care about their health and strive to create a positive work environment.

Flexible Opportunities: At GlobalLogic, we prioritize work-life balance by offering flexible opportunities tailored to your lifestyle. Explore relocation and rotation options for diverse cultural and professional experiences in different countries with our company.

About GlobalLogic

GlobalLogic, a Hitachi Group Company, is a trusted digital engineering partner to the world’s largest and most forward-thinking companies. Since 2000, we’ve been at the forefront of the digital revolution – helping create some of the most innovative and widely used digital products and experiences. Today we continue to collaborate with clients in transforming businesses and redefining industries through intelligent products, platforms, and services.