BI Warehouse Architect
1 week ago
DCI Donor Services (DCIDS) is looking for a dynamic and enthusiastic team member to join us to save lives Our mission at DCI Donor Services is to save lives through organ donation and we want professionals on our team that will embrace this important work We are currently seeking an BI Warehouse Architect. 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.
COMPANY OVERVIEW AND MISSION
For over four decades, DCI Donor Services has been a leader in working to end the transplant waiting list. Our unique approach to service allows for nationwide donation, transplantation, and distribution of organs and tissues while maintaining close ties to our local communities.
DCI Donor Services operates three organ procurement/tissue recovery organizations: New Mexico Donor Services, Sierra Donor Services, and Tennessee Donor Services. We also maximize the gift of life through the DCI Donor Services Tissue Bank and Tennessee Donor Services Eye Bank.
Our performance is measured by the way we serve donor families and recipients. To be successful in this endeavor is our ultimate mission. By mobilizing the power of people and the potential of technology, we are honored to extend the reach of each donor’s gift and share the importance of the gift of life.
We are committed to diversity, equity, and inclusion. With the help of our employee-led strategy team, we will ensure that all communities feel welcome and safe with us because we are a model for fairness, belonging, and forward thinking.
Key responsibilities this position will perform include:
- Adheres to data engineering principles and practices.
- 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, including stream processing technologies where appropriate.
- Demonstrates problem solving ability that allows team for timely and effective issue resolution.
- Drives and completes 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.
- Performs other related duties as assigned.
The ideal candidate will have:
TECHNICAL SKILLS:
- Programming Languages:
- Advanced proficiency in SQL
- Preferred familiarity with Python
- Cloud Platforms:
- Strong experience with at least one major cloud platform (AWS, Azure, or GCP)
- Understanding of cloud-native architectures and services
- Data Warehousing and Lakes:
- Experience with modern data warehousing solutions (e.g., Snowflake, Amazon Redshift, Google BigQuery)
- Familiarity with data warehouse architectures and technologies
- ETL/ELT and Data Pipelines:
- Proficiency in designing and implementing scalable data pipelines
- Experience with ETL/ELT tools
- Database Systems:
- Strong knowledge of both relational (e.g., PostgreSQL, Oracle) and NoSQL (e.g., MongoDB, Cassandra) databases
- Experience with database optimization and performance tuning
- Data Modeling:
- Proficiency in dimensional modeling and data warehouse design
- Experience with data modeling tools
- Data Governance and Security:
- Understanding of data governance principles and practices
- Knowledge of data security and privacy best practices
- Machine Learning Operations (MLOps):
- Familiarity with MLOps practices and tools
- Data Visualization:
- Basic proficiency with data visualization tools (e.g., Power BI, Tableau)
PHYSICAL TRAITS: Reads, writes, listens and observes. Communicates using both verbal and technological avenues. Walks, stands, lifts, and carries light loads.
QUALIFICATIONS:
Education Required:
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.
Experience:
Minimum of 7 years of professional experience in data engineering, with at least 3 years in a senior or lead role.
Must have ten (10) years designing and implementing large-scale data pipelines and ETL processes
Must have minimum of three (3) years working with cloud-based platforms (e.g., AWS, Azure, GCP)
Must have ten (10) years implementing and maintaining data lakes and/or warehouses
Must have five (5) years using modern big data technologies such as Spark, Hadoop, etc.
Must have experience in applying data governance and security practices.
Must have experience documenting and keeping updated documentation on practices/processes for warehousing.
LICENSES/CERTIFICATION: Certifications in the following areas are preferred but not required
- Data Engineering Certifications:
- Google Certified Professional Data Engineer
- AWS Certified Data Analytics – Specialty
- Azure Data Engineer Associate
- Cloudera Certified Professional (CCP) Data Engineer
- Modern Data Warehouse Architecture Certifications:
- Databricks Certified Professional Data Engineer
- SnowPro Advanced: Data Engineer Certification
- Microsoft Certified: Azure Data Engineer Associate
- Google Cloud Certified - Professional Data Engineer
- AWS Certified Data Analytics - Specialty
- Advanced SQL Developer Certifications:
- Microsoft Certified: Azure Database Administrator Associate
- Oracle PL/SQL Developer Certified Associate
- Databricks Certified Associate Developer for Apache Spark
- Google Cloud Certified - Professional Cloud Database Engineer
- AWS Certified Database – Specialty
- Advanced Programming and ETL Development Certifications:
- Python Institute PCPP – Certified Professional in Python Programming
- RStudio Certified Professional Data Scientist
- Informatica Certified Professional or Talend Certified Developer
- AWS Certified Developer - Associate
- Microsoft Certified: Azure Data Engineer Associate
- Data Governance and Security Certifications:
- ISACA Certified Information Systems Auditor (CISA)
- Certified in Data Protection (CIPT)
- Certified Information Systems Security Professional (CISSP)
We offer a competitive compensation package including:
- 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
- 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.**
You will receive a confirmation e-mail upon successful submission of your application. The next step of the selection process will be to complete a video screening. Instructions to complete the video screening will be contained in the confirmation e-mail. Please note - you must complete the video screening within 5 days from submission of your application to be considered for the position.
DCIDS is an EOE/AA employer – M/F/Vet/Disability.
-
BI Warehouse Architect
1 week ago
West Sacramento, United States DCI Donor Services Full timeDCI Donor Services (DCIDS) is looking for a dynamic and enthusiastic team member to join us to save lives!! Our mission at DCI Donor Services is to save lives through organ donation and we want professionals on our team that will embrace this important work!! We are currently seeking an BI Warehouse Architect. The BI Warehouse Architect is responsible for...
-
Data Warehouse BI Developer
1 week ago
Sacramento, United States PamTen Full timeOur client is seeking a Data Warehouse Business Intelligence Developer for a remote contract opportunity. The consultant must be willing to work Pacific Time business hours. Enterprise Data Warehouse Business Intelligence Developer to create and manage BI and analytics solution. * Design, development and implementation of database architectures, data...
-
Power BI Database Architect
2 weeks ago
Sacramento, California, United States WellSpace Health Full timeJob SummaryWe are seeking an experienced Power BI Database Architect to join our team at WellSpace Health. The successful candidate will be responsible for designing and developing complex Power BI dashboards and databases to support business intelligence and data analysis.About UsWellSpace Health is a statewide leader in designing and delivering integrated...
-
Enterprise Data Architect
3 weeks ago
Sacramento, California, United States Qualitative Financials Full timeAt Qualitative Financials, we are seeking a highly experienced Enterprise Data Architect to lead our data warehouse team.We offer an estimated salary of $120,000 - $180,000 per year based on industry standards and location.The successful candidate will have at least seven years of experience in database design and warehouse architecture. Strong skills in...
-
Enterprise Data Architect
4 weeks ago
Sacramento, California, United States Della Infotech Full timeJob SummaryDella Infotech is looking for an Enterprise Data Architect to join our team. As a key member of our data analytics team, you will be responsible for designing and implementing our enterprise data architecture.The ideal candidate will have a strong background in data architecture, with experience in relational data modeling and dimensional data...
-
Oracle Data Warehouse Administrator
8 months ago
Sacramento, United States Qualitative Financials Full timeExp - 9+Years Client - Photon Infotech/ Client Rate $68/hr on W2 Oracle Data Warehouse Administrator Local to Sacramento area, CA Visa: NO H1B/CPT/OPT Duration: 3 years Contract MOI: Video Specific: Candidates must have a LinkedIn profile with a picture Required: • Seven (7) years of verifiable experience in database design...
-
Sacramento, United States Estaffllc Full timeWe are seeking a Senior Data Warehouse Administrator for a long-term Hybrid assignment with our Sacramento, California based client. This position requires that you be able to work on-site in Sacramento, California for at least 2 days/wk as determined by the client.Scroll down to find an indepth overview of this job, and what is expected of candidates Make...
-
Sacramento, United States eStaffLLC Full timeWe are seeking a Senior Data Warehouse Administrator for a long-term Hybrid assignment with our Sacramento, California based client. This position requires that you be able to work on-site in Sacramento, California for at least 2 days/wk as determined by the client. Responsibilities include: Performs data warehouse administration for the Enterprise Data...
-
Sacramento, United States My3Tech Full timeHello,Hope you are doing good.Position: Senior Data Warehouse Administrator/Database AdministratorLocation: Sacramento, CA (Hybrid – onsite work required)Duration: Long TermClient: Loblolly/State of CAJob Description:Requirements:Senior hands-on Data Warehouse Administrator with strong communication skills.Detail oriented ability to independently build and...
-
Sacramento, United States My3Tech Full timeHello,Hope you are doing good.Position: Senior Data Warehouse Administrator/Database AdministratorLocation: Sacramento, CA (Hybrid – onsite work required)Duration: Long TermClient: Loblolly/State of CAJob Description:Requirements:Senior hands-on Data Warehouse Administrator with strong communication skills.Detail oriented ability to independently build and...
-
System Architect and Administrator
4 weeks ago
Sacramento, California, United States Istreet, Inc. Full timeAbout the Role: We are seeking an experienced System Architect and Administrator to join our team. As a key member of our IT department, you will be responsible for designing, implementing, and maintaining our company's SAP systems.Your primary responsibility will be to supervise and manage the implementation of best practices for our SAP systems. You will...
-
Cloud Architect
4 days ago
Sacramento, United States State of California Full timeThe incumbent must reside in California at the time of appointment pursuant to California Government Code section 14200. California's long-awaited statewide Cradle-to-Career Data System has launched. You can help build a statewide system that brings together existing data with an aim of addressing barriers to opportunity from early learning, through K-12,...
-
Data Analytics Expert
4 weeks ago
Sacramento, California, United States Della Infotech Full timeAbout the RoleWe are seeking a highly skilled Data Analytics Expert to join our team at Della Infotech. As a key member of our data analytics team, you will be responsible for developing and maintaining our enterprise data warehouse.The ideal candidate will have a strong background in data analytics, with experience in relational data modeling and...
-
Sr ETL Developer-Need GC and USC
7 days ago
Sacramento, United States USM Business Systems Full timeSr ETL Developer - Need GC and USCUSM Business Systems Inc. is a quickly developing worldwide System Integrator, Software and Product Development, IT Outsourcing and Technology assistance supplier headquartered in Chantilly, VA with off-shore delivery centers in India. We offer world-class ability in giving most astounding quality and administrations through...
-
Solution Architect
4 weeks ago
West Hollywood, United States Live Nation Full timeJob Summary: RECRUITING THROUGH WINTER BREAK (12/23-1/3). WILL RESUME CANDIDATE ENGAGEMENT UPON OUR RETURN. SUBMIT YOUR APPLICATION NO LATER THAN 1/5/2025 TO BE CONSIDERED WHO ARE WE? Live Nation Entertainment is the world’s leading live entertainment and eCommerce company, comprised of four market leaders: Ticketmaster.com, Live Nation Concerts, Front...
-
Akash_Dummy_Data Analyst/Data Modeler
1 month ago
Sacramento, United States SysMind Tech Full timeJOB DESCRIPTION: MANDATORY QUALIFICATIONS: 1. Staff resource must have a minimum of five (5) years of experience as a data analyst or in other quantitative analysis or related disciplines, such as researcher or data engineer supportive of key duties/responsibilities 2. Staff resource must have a minimum of five (5) years of relevant experience in relational...
-
Senior Data Governance Specialist
2 weeks ago
Sacramento, California, United States Capio Group Full timeAbout the RoleWe are looking for a highly skilled Enterprise Data Architect to join our team at Capio Group. As a key member of our organization, you will be responsible for developing and implementing a comprehensive data management strategy that aligns with our company's goals and objectives.Key Responsibilities:Develop a data management strategy that...
-
Data Modeler
1 month ago
Sacramento, United States Della Infotech Full timePosition: Data Modeler / Data Analyst Location: Sacramento, CA (Candidate should stay close to customer location) Rate: Open Duration : 3 yrs. Local candidates are preferred. This candidate should have good communication skill to interact with customer and deliver within SLA. Data Analyst/Data Modeler: Key Duties/Responsibilities: • Performs business and...
-
Director, Data Management and Analytics
7 days ago
Sacramento, United States California Charter Schools Association Full timeDepartment: School Performance, Development and SupportPosition: Director, Data Management and AnalyticsLocation: Remote, preferably within CaliforniaDate : 11/26/2024Description of Job: The Director, Data Management and Analytics at CCSA, will play a vital role in improving educational outcomes for California charter students by building and managing the...
-
Business Systems Analyst
3 days ago
Sacramento, United States Estrada Consulting Incorporated Remote Work Freelance Full timeEstrada Consulting Inc is looking to hire BSA with Medi-Cal (state of California) and Medicaid experience as a BSA, business process, and use of Power BI doing dashboards.MANDATORY QUALIFICATIONS:(M)Five (5) years of experience applying analytical processes on IT projects. At least three (3) years of that experience must have been in business systems...