Snowflake Data Engineer Job at Business Centric Technology, Addison, TX

  • Business Centric Technology
  • Addison, TX

Job Description

Our Addison, TX-based client is seeking a Data Engineer to build and maintain data pipelines for a cloud-native analytics platform on Azure and Snowflake. Responsibilities include data ingestion, transformation using Bronze/Silver/Gold medallion architecture, and production reliability. The role is initially fully onsite, with potential for two remote days per week after a few months and is available as a six-month contract-to-hire or direct hire.

COMP: Up to $150K, dependent on candidate's experience

WHAT OUR CLIENT OFFERS:

  • Competitive salary with performance-based bonus opportunities
  • Comprehensive health, dental, and vision insurance
  • 401(k) plan with 3% non-discretionary company contribution
  • Paid holidays, PTO, and professional development support
  • A collaborative and growth-oriented work environment

WHAT YOU'LL DO:

  • Build and maintain ELT pipelines in Azure Data Factory (ADF) ingesting data disparate data sources into Azure Data Lake Storage Gen2.
  • Implement Snowflake Bronze Silver Gold layer transformations: incremental loads, SCD Type 2, and fact/dimension modeling aligned to business requirements.
  • Write and optimize T-SQL against SQL Server for performant source extraction without disrupting operational workloads.
  • Maintain pipeline monitoring, alerting, and error recovery - pipelines support 24/7 revenue operations and uptime matters.
  • Handle PHI/PII data in full compliance with HIPAA: field masking, access controls, and audit-ready data handling at every layer.
  • Collaborate with our AI/ML engineer to ensure Silver-layer data structures are ML-ready and consistently documented.

WHAT YOU'LL BRING:

  • Bachelor's degree in Computer Science, Information Systems, or equivalent experience.
  • 5 8+ years of data engineering experience, including 2+ years with Azure and hands-on production experience with Azure Data Factory, ADLS Gen2, and Snowflake.
  • Strong SQL Server/T-SQL skills, including complex queries, CTEs, window functions, and SCD Type 2, plus experience with Snowflake tasks, streams, incremental loading, query optimization, and RBAC.
  • Strong understanding of ETL/ELT patterns, idempotency, error handling, and working with regulated data (HIPAA, PCI, or similar).
  • Preferred: Healthcare data experience, Python for data transformation and pipeline testing, dbt for Silver/Gold layer management, and Azure DevOps/CI/CD for pipeline deployment.

APPLY TODAY! CP # 8595

Job Tags

Contract work, Remote work, 2 days per week

Similar Jobs

Techgene Solutions

Business Analyst Job at Techgene Solutions

 ...Job Description \n \n Experience as a Business Analyst, Consultant, or Similar Role in Technology or Government Required 5 years...  ...Azure DevOps Highly Desired \n Experience with the Salesforce Platform, including supporting business processes and eliciting... 

Quevera

Network Engineer TS/SCI Clearance with Poly Job at Quevera

 ...maintaining network infrastructure, managing security measures, and documenting activities. A minimum of three years as a Network Engineer and twelve years in related programs is required; DoD 8570.01-M IAT Level III, CCNA/CCNP, and Security+ are expected. #J-18808-Ljbffr

Jefferies

Tax Counsel Job at Jefferies

Job Description Tax Counsel \n Tax Counsel & Advisory \n New York \n \n Company Overview \n \n Jefferies is one of the worlds leading full-service investment banking and capital markets firms providing a full range of investment banking, equities, fixed...

Alliance Workforce

Picker/Packer Job at Alliance Workforce

 ...Job Description Job Description PICKER/PACKER Location: Largo, FL Pay: $15.00/hour Schedule: MondayFriday, 9:30 AM6:0...  ...view and process sample orders Pick products from assigned warehouse locations Pack orders safely and accurately Perform quality... 

Stripe

Data Analyst, NYC Job at Stripe

 ...everyones reach while doing the most important work of your career.About the teamData Science at Stripe is a vibrant community where data analysts and data scientists learn and grow together. You'll work with some of the most fundamental data at Stripe, and use that...