Visionaire Partners
Data & Analytics Architect - AI
⭐ - Featured Role | Apply direct with Data Freelance Hub
This role is for a Data & Analytics Architect - AI, with a contract length of 3 to 6 months, offering a competitive pay rate. Key skills include advanced SSRS, SSAS Tabular, DAX, T-SQL, and experience in DevOps environments.
🌎 - Country
United States
💱 - Currency
$ USD
-
💰 - Day rate
Unknown
-
🗓️ - Date
June 14, 2026
🕒 - Duration
3 to 6 months
-
🏝️ - Location
Unknown
-
📄 - Contract
Unknown
-
🔒 - Security
Unknown
-
📍 - Location detailed
Alpharetta, GA
-
🧠 - Skills detailed
#DAX #DevOps #Cloud #Azure SQL #SQL (Structured Query Language) #Debugging #Automated Testing #Snowflake #Azure #SSRS (SQL Server Reporting Services) #SSAS (SQL Server Analysis Services) #Azure DevOps #Datasets #Data Architecture #Data Pipeline #Documentation #GitHub #AI (Artificial Intelligence) #Semantic Models #Data Warehouse
Role description
Data & Analytics Architect
Responsibilities
We are looking for a deeply technical, hands-on Lead Data & Analytics Architect to drive modernization of data architecture and reporting. This role combines strategic thinking (architecture, standards, and roadmap) with strong execution as an individual contributor.Key Responsibilities:
• Immediate Focus (3–6 months): Actively convert a high volume of SSRS reports from T-SQL stored procedure datasets to an SSAS Tabular semantic model using DAX. Own a subset of reports end-to-end (redesign datasets, migrate logic, optimize reports, parameters, subscriptions, and layouts) while helping build the supporting Snowflake data warehouse and semantic layer.
• Ongoing & Longer-Term: Define reporting patterns, standards, and architecture. Evolve the data warehouse and semantic models for performance and maintainability. Operate with a DevOps mindset (source control, CI/CD, documentation). Champion AI-first development practices to significantly boost productivity (targeting step-change gains) while maintaining quality and governance. Mentor teammates through pairing, reviews, and reusable assets.
Required Skills
• Advanced expertise in SSRS report development and refactoring
• Strong hands-on experience with SSAS Tabular models and DAX (writing & tuning)
• Expert-level T-SQL (stored procedures, performance tuning, debugging)
• Solid experience with SSRS parameters, datasets, and subscriptions
• Strong performance tuning mindset across semantic and reporting layers
• Demonstrated AI-first mindset — using AI/LLM tools (e.g., Copilot) to accelerate SQL/DAX generation, testing, analysis, and documentation
Essential for Long-Term Success:
• Proven ability to lead technically as an IC (architecture, patterns, standards) without formal management
• Experience in DevOps environments (source control, CI/CD – preferably Azure DevOps/GitHub)
• Excellent communication skills to translate business needs into technical solutions
Preferred Skills
• Experience with Snowflake or other cloud data warehouses
• Background in dimensional modeling (Kimball, star schemas)
• Familiarity with Azure SQL, data pipelines/ELT, automated testing, and modern development practices (SQL Projects, VS Code, GitHub Actions)
This is a contractor role emphasizing deep technical delivery, modernization, and raising the team’s engineering capabilities through modern practices and AI tooling.
Data & Analytics Architect
Responsibilities
We are looking for a deeply technical, hands-on Lead Data & Analytics Architect to drive modernization of data architecture and reporting. This role combines strategic thinking (architecture, standards, and roadmap) with strong execution as an individual contributor.Key Responsibilities:
• Immediate Focus (3–6 months): Actively convert a high volume of SSRS reports from T-SQL stored procedure datasets to an SSAS Tabular semantic model using DAX. Own a subset of reports end-to-end (redesign datasets, migrate logic, optimize reports, parameters, subscriptions, and layouts) while helping build the supporting Snowflake data warehouse and semantic layer.
• Ongoing & Longer-Term: Define reporting patterns, standards, and architecture. Evolve the data warehouse and semantic models for performance and maintainability. Operate with a DevOps mindset (source control, CI/CD, documentation). Champion AI-first development practices to significantly boost productivity (targeting step-change gains) while maintaining quality and governance. Mentor teammates through pairing, reviews, and reusable assets.
Required Skills
• Advanced expertise in SSRS report development and refactoring
• Strong hands-on experience with SSAS Tabular models and DAX (writing & tuning)
• Expert-level T-SQL (stored procedures, performance tuning, debugging)
• Solid experience with SSRS parameters, datasets, and subscriptions
• Strong performance tuning mindset across semantic and reporting layers
• Demonstrated AI-first mindset — using AI/LLM tools (e.g., Copilot) to accelerate SQL/DAX generation, testing, analysis, and documentation
Essential for Long-Term Success:
• Proven ability to lead technically as an IC (architecture, patterns, standards) without formal management
• Experience in DevOps environments (source control, CI/CD – preferably Azure DevOps/GitHub)
• Excellent communication skills to translate business needs into technical solutions
Preferred Skills
• Experience with Snowflake or other cloud data warehouses
• Background in dimensional modeling (Kimball, star schemas)
• Familiarity with Azure SQL, data pipelines/ELT, automated testing, and modern development practices (SQL Projects, VS Code, GitHub Actions)
This is a contractor role emphasizing deep technical delivery, modernization, and raising the team’s engineering capabilities through modern practices and AI tooling.
