Logo
DCI Donor Services

BI Data Architect

DCI Donor Services, West Sacramento, California, us, 95798

Save Job

Overview

BI Data Architect

role at

DCI Donor Services, Inc.

The BI Data Architect will design, deploy, and maintain a modern Azure Lakehouse architecture leveraging Databricks and the Medallion model. This role is central to integrating data from iTransplant and other 3rd party applications, improving scalability, performance and data quality. The architect will lead technical implementations, set architectural standards and partner with Business Intelligence to enable data-driven decision-making across the organization. This is a remote position; however, candidates must be based in California. Base pay range

$109,000.00/yr - $165,000.00/yr This range is provided by DCI Donor Services, Inc.. Your actual pay will be based on your skills and experience talk with your recruiter to learn more. Key Responsibilities Design, build and maintain scalable end-to-end data pipelines using modern ETL/ELT and stream processing tools. Architect and manage the Lakehouse environment (Databricks, Azure Data Lake), including Bronze/Silver/Gold Medallion layers. Optimize data models for analytical and operational use, enabling self-service analytics through intuitive structures. Establish and maintain architectural standards, data governance and security practices in a regulated environment. Implement automated testing, CI/CD and monitoring frameworks to ensure data quality, reliability and system performance. Collaborate with BI and technical teams to integrate new data sources, prepare technical specifications and improve visibility of data across the organization. Document and maintain architecture, processes and data standards. Performs other related duties as assigned.

Qualifications TECHNICAL SKILLS:

Strong expertise in SQL and Python Experience with Azure Databricks and Lakehouse architecture (Medallion model) with knowledge of warehouse integration patterns Proficiency in designing and implementing scalable data pipelines Proficiency in dimensional modeling and data design for both warehouse and Lakehouse environments Understanding of data governance principles and practices and data security Familiarity with Power BI Service to support integration and enablement of self-service reporting

Education & Experience

Bachelor's degree in Computer Science, Data Science, Engineering, or a related technical field. Master's degree is preferred but not required. Equivalent combination of education and experience may be considered. Minimum of 7 years of professional experience in data engineering, with at least 3 years in a senior or lead role Proven experience designing and implementing large-scale data pipelines and ELT processes 3+ years hands-on with Azure Databricks (or similar Spark-based platforms), with proven experience implementing Medallion architecture Experience in applying data governance and security practices in regulated environments Demonstrated ability to document and maintain data architecture, processes and standards

Licenses & Certifications

Azure Data Engineer Associate Databricks Certified Professional Data Engineer Databricks Certified Associate Developer for Apache Spark Security or data governance certifications (CISA, CIPT, CISSP)

We Offer

Up to 176 hours of PTO your first year Up to 72 hours of Sick Time your first year Two Medical Plans (PPO or HDHP), Dental, and Vision Coverage 403(b) plan with matching contribution Company provided term life, AD&D, and long-term disability insurance Wellness Program Supplemental insurance benefits such as accident coverage and short-term disability Discounts on home/auto/renter/pet insurance Cell phone discounts through Verizon Monthly phone stipend

New employees must have their first dose of the COVID-19 vaccine by their potential start date or be able to supply proof of vaccination. This position does not offer visa sponsorship or OPT Training Plans. DCIDS is an EOE/AA employer M/F/Vet/Disability. #J-18808-Ljbffr