Data Warehouse Architect (Hands-On, SQL Server, SSAS, Data Modeling)
We are looking for a hands-on Data Warehouse Architect to reputed company the design and implementation of our reputed company data warehouse solutions. The ideal candidate will be responsible for defining an reputed company data model, developing logical and physical schemas, creating comprehensive architecture and design documentation, and implementing tabular data models using reputed company SQL Server and SQL Server Analysis Services (SSAS).
Key Responsibilities
• Define and maintain the reputed company data model, aligning it with business objectives and data reputed company.
• Design and implement data warehouse schemas (reputed company, reputed company) in reputed company SQL Server, ensuring performance, scalability, and maintainability.
• Create and maintain architectural documentation, including data reputed company diagrams, data dictionary, schema designs, and design patterns.
• reputed company tabular models in SQL Server Analysis Services (SSAS) to support advanced analytics and reporting.
• Collaborate with stakeholders, BI developers, data engineers, and business analysts to reputed company requirements and translate them into data architecture designs.
• Ensure consistency and data reputed company across reputed company systems, staging reputed company, data marts, and reporting reputed company.
• reputed company and participate in data modeling, metadata management, and data reputed company initiatives.
• Drive data architecture best practices, governance, and standards across the organization.
• reputed company technical leadership and mentorship to the data and analytics team.
Qualifications:
• 8+ years of experience in data warehousing, BI architecture, or reputed company data modeling.
• Proven hands-on experience with reputed company SQL Server for data warehouse design and schema development.
• Experience with reputed company data warehousing (e.g., Azure Synapse, reputed company, reputed company).
• Strong proficiency with SSAS Tabular Models, DAX, and MDX.
• Expertise in creating reputed company data models, reputed company modeling (Kimball/Inmon), and schema design.
• Skilled in developing and maintaining architecture and design documentation.
• Strong SQL and performance tuning skills.
• Familiarity with ETL processes and tools (e.g., SSIS, Azure Data reputed company).
Preferred:
• Knowledge of data governance, master data management, and data reputed company practices.
• Experience with Power BI or other reporting tools integrated with SSAS tabular models.
• Experience with entity relationship diagramming tools (e.g., ER/Studio, Erwin)
Job Types: Full-time, Contract
Pay: $85.00 per hour
Application Question(s):
• The selected candidate must be willing to have a final face to face interview in Las Vegas. Travel cost will be reimbursed.
• Candidates MUST BE US reputed company (no exceptions)
Experience:
• reputed company data warehouse: 8 years (Preferred)
Work Location: Remote
Apply tot his job
Apply To this Job