Data Warehouse Architect

Link Tech, LLC

Atlanta, GA

Apply

JOB DETAILS

JOB TYPE

Contractor

SKILLS

Architectural Services, Best Practices, Business Analysis, Business Architecture, Business Intelligence, Cloud Computing, Data Analysis, Data Mart, Data Modeling, Data Quality, Data Warehousing, Database Design, Database Extract Transform and Load (ETL), Design Patterns Programming Methodologies, Dimensional Modeling, Documentation, Embarcadero ER/Studio, Entity Relationship Diagram (ERD), Information Technology Consulting, MDX (MultiDimensional eXpression Language), Master Data Management (MDM), Mentoring, Metadata, Microsoft SQL Server, Microsoft Windows Azure, Performance Tuning/Optimization, Power BI, Quality Assurance, Requirements Management, SQL (Structured Query Language), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), Security Information and Event Management (SIEM), Snowflake Schema, Star Schema, Technical Leadership, erwin Data Modeler

LOCATION

Atlanta, GA

POSTED

30+ days ago

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.JOB SUMMARY This role will lead the design and implementation of enterprise data warehouse solutions. The ideal candidate will be responsible for defining an enterprise data model, developing logical and physical schemas, creating comprehensive architecture and design documentation, and implementing tabular data models using Microsoft SQL Server and SQL Server Analysis Services (SSAS).QUALIFICATIONSMinimum 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, Fabric, 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, and schema design.Skilled in creating and maintaining architecture and design documentation.Advanced SQL and performance tuning skills.Solid understanding of ETL processes and tools, including SSIS and Azure Data Factory.PREFERREDFamiliarity with data governance frameworks, master data management, and data security best practices.Experience integrating Power BI or other reporting tools with SSAS tabular models.Understanding of entity relationship diagramming tools (e.g., ER/Studio, Erwin).RESPONSIBILITIESDefine 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.

About the Company

Link Tech, LLC

Resume Resources

Free Resume Templates Free Resume Builder