Overview
Remote
Contract - W2
Skills
IT Consulting
BI Architecture
Cloud Computing
DAX
MDX
Dimensional Modeling
IT Architecture
Design Documentation
SQL
FOCUS
Performance Tuning
Query Optimization
Extract
Transform
Load
Microsoft SSIS
Microsoft Azure
Data Governance
Master Data Management
Data Security
Microsoft Power BI
Data Warehouse
Snow Flake Schema
Scalability
Documentation
Data-flow Diagrams
Data Dictionary
Design Patterns
Microsoft SQL Server
Microsoft SSAS
Advanced Analytics
Collaboration
Business Intelligence
Data Integrity
Data Marts
Reporting
Data Modeling
Meta-data Management
Data Quality
Data Architecture
IT Management
Mentorship
Analytics
Law
Job Details
- JOB-7269
- Data Warehouse Architect
- REMOTE
- Contract
- Link Technologies (LinkTechConsulting.com), a Las Vegas based IT consulting firm, is currently seeking a Data Warehouse Architect to join our team. Employer asks for I-9 information.
QUALIFICATIONS- Minimum eight (8) years of experience in data warehousing, business intelligence architecture, or enterprise data modeling.
- Extensive hands-on experience with Microsoft SQL Server, including data warehouse design and schema development.
- Proficient in cloud-based data warehousing platforms such as Azure Synapse and Snowflake.
- Strong expertise in SSAS Tabular Models, with deep knowledge of DAX and MDX.
- Demonstrated ability to design enterprise-level data models, including dimensional modeling using Kimball or Inmon methodologies.
- Skilled in creating and maintaining technical architecture and design documentation.
- Advanced SQL skills with a focus on performance optimization and query tuning.
- Solid understanding of ETL processes and tools, including SSIS and Azure Data Factory.
PREFERRED- Familiarity with data governance frameworks, master data management, and data security best practices.
- Experience integrating Power BI or other reporting tools with SSAS tabular models.
RESPONSIBILITIES- Define and maintain the enterprise data model, aligning it with business objectives and data strategy.
- Design and implement data warehouse schemas (star, snowflake) in Microsoft SQL Server, ensuring performance, scalability, and maintainability.
- Create and maintain architectural documentation, including data flow diagrams, data dictionary, schema designs, and design patterns.
- Develop 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 gather requirements and translate them into data architecture designs.
- Ensure consistency and data integrity across source systems, staging layers, data marts, and reporting layers.
- Lead and participate in data modeling, metadata management, and data quality initiatives.
- Drive data architecture best practices, governance, and standards across the organization.
- Provide technical leadership and mentorship to the data and analytics team.
Link Technologies is an equal opportunity employer. All qualified applicants will receive consideration for employment without discrimination based on race, color, religion, sex, gender identity/expression, sexual orientation, national origin, protected veteran status, disability, or any other factors protected by law.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.