What are the responsibilities and job description for the Datawarehouse Architect // CA // Onsite Work position at Key Business Solutions, Inc.?
Datawarehouse Architect
Rancho Cordova, CA
6-12 Months
Onsite Work
Need 3 references from 3 different projects
Mandatory Qualifications
- Five (5) years of relevant FTE experience in data modeling, database design, and warehouse architecture.
- Possess a bachelor s or advanced degree (master's or PhD) in computer science, engineering, math or related field. Additional qualifying experience may be substituted for the required education on a year-for-year basis.
- Five (5) years of FTE experience in Database Experience: Database design, data modeling, and database management systems (e.g., Structured Query Language (SQL) Server, Oracle, MySQL).
- Five (5) years of FTE experience in Data Architecture: applying data architecture principles, including data integration, data warehousing, and Extract, Transform, Load (ETL) processes.
- Five (5) years of FTE experience in Data Modeling: Proficiency in data modeling techniques, such as entity-relationship (ER) modeling, dimensional modeling, and normalization.
Desirable Qualifications
- Experience in Data Security: Applying data security best practices and compliance standards to ensure data protection.
- Experience in Data Migration: Experience in data migration strategies and tools when transitioning between databases or systems.
- Database Performance experience: Ability to optimize database performance through indexing, query optimization, and data partitioning.
- Technical Communication experience: Applying excellent communication skills to collaborate with technical and non-technical stakeholders, translating business requirements into technical solutions.
- Business Intelligence (BI) Integration experience: Understanding of integrating data architecture with BI tools like Tableau, Power BI, or Qlik for reporting and analytics.