Fusion HCR is hiring! Remote Contract Data Warehouse Architect for our Federal Government client. This position requires US Citizenship. No third parties accepted.
Were seeking a handson Data Warehouse Architect to lead the design and implementation of enterprise data warehouse solutions. This role involves defining enterprise data models developing schemas documenting architecture and building tabular models using Microsoft SQL Server and SSAS. Key Responsibilities
Define and maintain enterprise data models aligned with business goals.
Design and implement star/snowflake schemas in Microsoft SQL Server.
Create and maintain architecture documentation (diagrams data dictionary design patterns).
Build SSAS Tabular Models for analytics and reporting.
Collaborate with stakeholders to translate requirements into data architecture.
Ensure consistency and integrity across all data layers.
Lead data modeling metadata and data quality efforts.
Promote data architecture standards and best practices.
Provide technical leadership and mentorship.
Qualifications
8 years in data warehousing BI architecture or data modeling.
Proven SQL Server experience with schema and warehouse design.
Strong SSAS Tabular DAX and MDX skills.
Experience with cloud data platforms (Azure Synapse Snowflake).
Expertise in dimensional modeling (Kimball/Inmon).
Skilled in SQL tuning documentation and schema design.
Familiar with ETL tools like SSIS or Azure Data Factory.
Preferred
Knowledge of data governance and security.
Experience with Power BI or similar tools integrated with SSAS.
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.