Architect, Data Warehouse

Location

Aliso Viejo, California, USA

Department Name

100-General and Administrative

Qualifications

1. Bachelor's degree in computer science, Information Systems, or a related field, or equivalent combination of education and experience. 
2. Minimum five (5) years of experience in data warehousing, data architecture, and business intelligence solutions. 
3. Deep understanding of data warehousing concepts, including dimensional modeling, star schema, and snowflake schema for large-scale date modeling. 
4. Proven knowledge of SQL Server for database management, data modeling, and query optimization. 
5. Expertise in data integration and transformation tools and methodologies (e.g., SSIS, Azure Data Factory, SAP Data Services, etc.). 
6. Expertise in data visualization and business intelligence tools, particularly Power BI, or other BI platforms. 
7. Strong knowledge of data governance, security, and compliance standards. 
8. Excellent written and verbal communication, collaboration, and critical thinking skills. 
9. Proficient with MS Word, Excel, Outlook, and Teams. 

1. Experience with ERP systems (e.g., SAP S/4HANA, Oracle, etc.) for data extraction and transformation. 
2. Proficient in Azure Cloud, big data technologies (e.g., Spark, Data Lake), and Business Analytics. 
3. Experience with project management involving a data lake implementation. 
4. Ability to create reports, dashboards, and visualizations to support business decision-making. 
5. Experience as a lead and/or senior member of a data warehouse team. 
6. General knowledge of GxP, SOX, and other auditable data management requirements. 
7. Knowledge of data science and machine learning concepts. 
8. Experience with DevOps practices and tools. 
9. Certification(s) in Data Architecture, Big Data, Data Engineering, Integrations, and other relevant technologies.

External-Facing Title

Architect, Data Warehouse

Posting Country

US - United States

Salary Range

$140,507 - $175,633 (Compensation could be higher based on education, experience and skill sets)