BI Warehouse Architect

$96,000 - $130,000/Yr

Dci Donor Services - West Sacramento, CA

Full-time - Mid Level

West Sacramento, CA

Ambulatory Health Care Services

About the position

The BI Warehouse Architect is responsible for designing, deploying, and maintaining advanced data solutions, including data warehouse and data management processes, to support the business intelligence team with reporting and advanced analytics requirements. This role is crucial in ensuring the integrity and accessibility of data for decision-making within the organization, contributing to the mission of saving lives through organ donation.

Responsibilities

• Design, build, deploy, automate, and maintain end-to-end data pipelines for new and existing data sources and targets utilizing modern ETL/ELT tools and practices.
• Demonstrate problem-solving ability that allows the team for timely and effective issue resolution.
• Drive and complete project deliverables within the data engineering & management area according to project plans.
• Utilize in-depth technical expertise regarding data models, master data management, metadata management, reference data management, and data warehousing.
• Work with internal technical resources to optimize the data warehouse through hardware or software upgrades or enhancements.
• Design and implement data models that balance performance, flexibility, and ease of use, considering both analytical and operational needs.
• Enable and support self-service analytics by designing intuitive data models and views, collaborating with the Business Intelligence team to ensure data is easily accessible and interpretable for business partners.
• Manage and automate the deployment of upgrades, patches, and new features across the data infrastructure, ensuring minimal disruption to data services and maintaining system integrity.
• Ensure compliance to all data warehouse administration activities.
• Manage and collect business metadata and data integration points.
• Coordinate with business intelligence to prepare technical design specifications to address user needs.
• Develop and implement comprehensive testing strategies, including automated unit, integration, and end-to-end tests, to ensure the accuracy, reliability, and performance of data pipelines and procedures.
• Provide technical support and coordination during warehouse design, testing, and movement to production.
• Create and maintain thorough, up-to-date documentation for all data engineering projects, processes, and systems, adhering to organizational standards and leveraging modern documentation tools and practices.
• Implement business rules via coding, stored procedures, middleware, or other technologies ensuring scalability and maintainability of implemented solutions.

Requirements

• Bachelor's degree in Computer Science, Data Science, Engineering, or a related technical field; Master's degree preferred.
• Minimum of 7 years of professional experience in data engineering, with at least 3 years in a senior or lead role.
• Ten years designing and implementing large-scale data pipelines and ETL processes.
• Three years working with cloud-based platforms (e.g., AWS, Azure, GCP).
• Ten years implementing and maintaining data lakes and/or warehouses.
• Five years using modern big data technologies such as Spark, Hadoop, etc.
• Experience in applying data governance and security practices.
• Experience documenting and keeping updated documentation on practices/processes for warehousing.

Nice-to-haves

• Advanced proficiency in SQL
• Familiarity with Python
• Strong experience with at least one major cloud platform (AWS, Azure, or GCP)
• Experience with modern data warehousing solutions (e.g., Snowflake, Amazon Redshift, Google BigQuery)
• Proficiency in designing and implementing scalable data pipelines
• Strong knowledge of both relational (e.g., PostgreSQL, Oracle) and NoSQL (e.g., MongoDB, Cassandra) databases
• Proficiency in dimensional modeling and data warehouse design
• Understanding of data governance principles and practices
• Familiarity with MLOps practices and tools
• Basic proficiency with data visualization tools (e.g., Power BI, Tableau)

Benefits

• 403(b) plan with matching contribution
• AD&D insurance
• Cell phone reimbursement
• Dental insurance
• Disability insurance
• Employee discount
• Up to 176 hours of PTO your first year
• Up to 72 hours of Sick Time your first year
• Two Medical Plans (your choice of a PPO or HDHP), Dental, and Vision Coverage
• 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