Data and Analytics Lead

SOLTECH; Atlanta (GA); On-site; USD 100,000 - 130,000; Full time

Job summary

SOLTECH is seeking a highly technical contractor for a Lead role in their Data & Analytics team in Atlanta, GA. This position requires advanced expertise in SQL Server Reporting Services and SSAS Tabular models, focusing on report modernization and architecture best practices. You'll drive significant projects including report optimizations and team mentorship while implementing AI-assisted tools. Strong communication and DevOps experience are essential. Join a team that's committed to leveraging data to drive insights and efficiency.

Qualifications

• Advanced experience building and refactoring enterprise reports in SSRS.
• Strong hands-on experience with SSAS Tabular models and DAX.
• Experience implementing SSRS datasets, parameters, and subscription models.

Responsibilities

• Lead end-to-end delivery of SSRS report conversions.
• Refactor legacy reports for improved maintainability.
• Design and optimize SSRS reports for better user experience.

Skills

SQL Server Reporting Services (SSRS)

DAX development

T-SQL skills

DevOps processes

AI-assisted tools

Tools

Snowflake

GitHub

Azure DevOps

Postman

VS Code

Job description

Our client is seeking a highly technical, hands‑on contractor to serve as an Individual Contributor (IC) Lead within their Data & Analytics team. This role blends strategic data architecture leadership with hands‑on execution, driving modernization across reporting and data platforms.

Location: Atlanta, GA (Candidates must be local)

Key Responsibilities

Immediate Priorities (0–6 Months)

• Lead end‑to‑end delivery of assigned SSRS report conversions, including dataset redesign and migration to SSAS Tabular models using DAX
• Refactor legacy SSRS reports from T‑SQL stored procedures to semantic model‑based reporting, ensuring accuracy and improved maintainability
• Design and optimize SSRS reports with consistent layout, parameters, and interactive features for enhanced user experience
• Configure and manage report subscriptions (standard and data‑driven), scheduling, and troubleshooting
• Collaborate with data engineers and analysts to validate business logic, reconcile outputs, and ensure data quality
• Improve performance and scalability by tuning DAX queries, optimizing semantic models, and resolving bottlenecks

Long‑Term Priorities (6+ Months)

• Serve as an IC architecture leader, defining best practices, standards, and patterns for reporting, semantic modeling, and data warehouse usage
• Contribute to the evolution of the Snowflake data warehouse and dimensional data models aligned with reporting needs
• Champion DevOps best practices including source control, CI/CD pipelines, code reviews, and automated deployments
• Drive adoption of AI/LLM tools to accelerate development, testing, documentation, and analysis workflows
• Mentor team members through pairing, code reviews, and sharing reusable assets to improve overall engineering quality
• Develop and maintain comprehensive documentation, including report logic, data lineage, and operational runbooks

Required Qualifications

Core Expertise (0–6 Months)

• Advanced experience building and refactoring enterprise reports in SQL Server Reporting Services (SSRS)
• Strong hands‑on experience with SSAS Tabular models and deep proficiency in DAX development and optimization
• Expert‑level SQL/T‑SQL skills, including stored procedures, debugging, and performance tuning
• Experience implementing SSRS datasets, parameters, and subscription models
• Strong understanding of performance optimization across reporting and semantic layers
• Demonstrated ability to leverage AI‑assisted tools to enhance productivity, streamline workflows, and maintain engineering rigor

Ongoing Success Factors (6+ Months)

• Proven ability to lead technical initiatives as an IC, including defining architecture and guiding team best practices
• Experience working in DevOps environments using GitHub and/or Azure DevOps with CI/CD pipelines
• Strong communication skills with the ability to translate business needs into technical solutions
• Hands‑on experience applying AI‑assisted development tools (e.g., Copilot, LLMs) to improve delivery speed and quality

Preferred Qualifications (Platform Modernization & Architecture)

• Experience with Snowflake or other modern cloud data warehouse platforms
• Strong background in dimensional modeling (Kimball methodology, star schemas, fact/dimension design)
• Experience building or modernizing data pipelines and ELT processes
• Knowledge of Azure SQL Database and OLTP systems, including 3NF modeling principles
• Familiarity with SQL projects, deployment automation, and CI/CD pipelines (e.g., GitHub Actions)
• Experience implementing automated testing, data quality validation, and monitoring frameworks
• Exposure to API integrations and tools such as Postman or Swagger
• Familiarity with Azure AI Search or modern search/indexing strategies
• Experience using VS Code for database development, schema management, and version‑controlled deployments