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.