Datawarehouse Architect
KEY BUSINESS SOLUTIONS
Rancho Cordova, United States of America
yesterday
Role details
Contract type
Permanent contract Employment type
Full-time (> 32 hours) Working hours
Regular working hours Languages
English Experience level
SeniorJob location
Rancho Cordova, United States of America
Tech stack
Databases
Data Architecture
Data Integration
ETL
Data Migration
Data Security
Data Warehousing
Database Design
Dimensional Modeling
Entity Relationship Models
MySQL
Oracle Applications
Query Optimization
Power BI
SQL Databases
Tableau
Database Performance
Indexer
Information Technology
QlikView
Requirements
- 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., * 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.
