Lead Data Engineer (Snowflake, DBT, Databricks, Pandas) - R01557862 at Brillio

St. Louis, Missouri, United States

Brillio Logo
Not SpecifiedCompensation
Senior (5 to 8 years), Expert & Leadership (9+ years)Experience Level
Full TimeJob Type
UnknownVisa
Healthcare, TechnologyIndustries

Requirements

  • 5+ years of experience in data engineering, preferably in healthcare or CRM integrations
  • Hands-on experience with Snowflake, DBT, and Pandas
  • Strong SQL and Python skills
  • Experience with Salesforce Health Cloud data structures and APIs
  • Familiarity with the Health Care Industry, HIPAA and PII data management
  • Familiarity with integration platforms such as MuleSoft, Informatica, or custom Snowflake connectors
  • Experience with Master Data Management solutions and Data Management concepts (Entity resolution, splits, merges, data lineage)
  • Understanding of healthcare data domains including eligibility, claims, care plans, and provider networks
  • Excellent problem-solving and communication skills
  • Preferred Qualifications
  • Deep SQL, stored procedure and materialized view experience
  • Knowledge of real-time data sync, identity resolution, and multi-object updates in Salesforce
  • Background in business process consulting or enterprise data strategy

Responsibilities

  • Architect and implement ETL/ELT pipelines to ingest and transform data from Snowflake to SFDC Health Cloud
  • Design and maintain data models that support payer and provider analytics, including Portico, Excelys, and Amisys structures
  • Leverage DBT for transformation workflows and documentation of data lineage
  • Design and implement Snowflake clusters using Terraform
  • Use Pandas and Python for data wrangling, preprocessing, and validation
  • Collaborate with cross-functional teams to align integration efforts with business goals, including real-time sync and batch processing
  • Ensure data quality, governance, and compliance with healthcare regulations
  • Monitor pipeline performance and troubleshoot issues across environments
  • Contribute to platform scalability and observability using tools like MuleSoft, Informatica, and Salesforce APIs

Skills

Snowflake
DBT
Databricks
Pandas
Salesforce Health Cloud
ETL
ELT
Data Pipelines
Data Modeling
Salesforce

Brillio

Technology consulting for digital transformation

About Brillio

Brillio helps businesses with their digital transformation by providing technology consulting services. The company focuses on creating customized digital solutions that utilize artificial intelligence and cloud technologies to meet the specific needs of each client. This includes improving operational efficiency and enhancing user experiences through real-time responses and better workflows. Brillio serves a variety of clients, including large Fortune 500 companies, with a strong emphasis on the healthcare sector. Unlike many competitors, Brillio's approach is centered on developing bespoke solutions that give clients a competitive advantage, aiming to help them evolve into 'generative enterprises.' The company's goal is to drive significant improvements in business operations and outcomes through its consulting services and technology implementations.

Edison, New JerseyHeadquarters
2014Year Founded
LATE_VCCompany Stage
Consulting, AI & Machine Learning, HealthcareIndustries
1,001-5,000Employees

Benefits

Remote Work Options

Risks

High competition in tech may impact Brillio's talent acquisition and service scaling.
Over-reliance on healthcare exposes Brillio to sector-specific regulatory and funding risks.
Expansion into new markets may stretch resources, leading to potential operational inefficiencies.

Differentiation

Brillio specializes in bespoke digital solutions for diverse industries, focusing on AI and cloud.
The company is recognized as an Enterprise Innovator in healthcare payer services.
Brillio's Cloud and AI Studio aims to modernize enterprise IT systems and optimize workflows.

Upsides

Increased demand for AI-driven healthcare solutions boosts Brillio's market potential.
Expansion in India enhances service delivery and innovation through a growing tech talent pool.
Recognition in Open Banking IT Services highlights Brillio's role in financial digital transformation.

Land your dream remote job 3x faster with AI