Our client is seeking a highly technical, hands-on individual contributor lead to join their Data & Analytics team. This role combines strategic data architecture leadership with hands-on delivery, focused on modernizing enterprise reporting and advancing the organization’s data warehouse and analytics capabilities.

The ideal candidate will bring deep expertise in SSRS, SSAS Tabular, DAX, and SQL/T-SQL, along with a forward-thinking, AI-first mindset that improves engineering productivity, scalability, and reporting quality. This individual will play a key role in modernizing reporting workflows, enhancing semantic modeling practices, and contributing to the evolution of a modern Snowflake-based data platform.

Key Responsibilities

Immediate Priorities (First 3–6 Months)

• Lead end-to-end delivery of assigned SSRS report modernization efforts
• Convert existing SSRS reports from T-SQL stored procedure datasets to SSAS Tabular semantic models using DAX
• Redesign report datasets and reporting logic to improve scalability, maintainability, and performance
• Develop and optimize enterprise SSRS reports, including parameters, layouts, interactive functionality, and user experience standards
• Configure and maintain standard and data-driven report subscriptions and scheduling
• Collaborate with data engineers, analysts, and business stakeholders to validate reporting logic and ensure data accuracy
• Troubleshoot and resolve performance bottlenecks across DAX queries, semantic models, and reporting layers
• Contribute to Snowflake data warehouse enhancements that support enterprise reporting and analytics initiatives

Long-Term Priorities (6+ Months)

• Serve as a technical IC architecture lead across reporting, semantic modeling, and warehouse consumption strategies
• Establish standards, reusable patterns, and best practices for reporting modernization and semantic layer development
• Contribute to data warehouse roadmap planning and target-state architecture initiatives
• Support modernization of Snowflake and dimensional data models to align with governed, high-performing reporting solutions
• Champion DevOps best practices including source control, CI/CD, code reviews, deployment automation, and documentation
• Drive adoption of AI-assisted development workflows to accelerate SQL, DAX, testing, troubleshooting, and documentation processes
• Mentor teammates through technical leadership, peer reviews, and AI-enabled engineering practices
• Create and maintain documentation for reporting logic, semantic models, operational procedures, and deployment processes

Required Qualifications

Core Technical Requirements

• Advanced experience developing and refactoring enterprise reports in SQL Server Reporting Services (SSRS)
• Deep hands-on expertise with SSAS Tabular models and advanced DAX development and tuning
• Expert-level SQL/T-SQL skills, including stored procedures, query optimization, and troubleshooting complex data logic
• Strong experience with SSRS datasets, parameters, subscriptions, and report troubleshooting
• Proven ability to optimize semantic models and reporting performance for scalability and reliability
• Experience applying AI-assisted development tools (e.g., Copilot, LLM-based workflows) to improve development speed, quality, and operational efficiency

Leadership & Delivery Capabilities

• Demonstrated success leading technical initiatives as an Individual Contributor without formal people management responsibilities
• Experience working within DevOps environments using GitHub and/or Azure DevOps
• Strong communication and collaboration skills with the ability to translate business requirements into scalable technical solutions
• Ability to influence technical direction and establish engineering standards across cross-functional teams

Preferred Qualifications

• Experience with Snowflake or other modern cloud data warehouse platforms
• Strong understanding of dimensional modeling methodologies including Kimball, star schemas, fact and dimension modeling
• Experience modernizing data warehouse pipelines and ELT processes
• Knowledge of Azure SQL Database administration and operational data modeling concepts
• Experience with SQL Projects, GitHub Actions, and deployment automation frameworks
• Background implementing automated testing, data quality validation, monitoring, and alerting solutions
• Familiarity with API integrations and tools such as Postman and Swagger
• Exposure to Azure AI Search or modern relational search/indexing technologies
• Experience using VS Code for schema management, database projects, and version-controlled DDL deployments

Why Join?

This is an opportunity to make a significant impact on a growing Data & Analytics organization by helping modernize enterprise reporting architecture and driving adoption of scalable, AI-enabled engineering practices. The role offers a blend of hands-on technical execution, architecture leadership, and platform modernization initiatives within a collaborative, forward-thinking environment.

About SOLTECH

SOLTECH is a leading national technology company based in Atlanta, driven by a steadfast commitment to integrity, strong company values, and customer centricity. For nearly 30 years, we’ve been part of the thriving technology community and have earned honors such as The Atlanta Journal-Constitution’s Top Workplace and the Best & Brightest Companies To Work For In The Nation.

Our exceptional team of engineers, designers, and strategists delivers custom software applications, technology consulting, AI and data engineering solutions, and IT staffing services that help organizations solve complex challenges nationwide.

Join us on our quest to make the world a better place by bringing to life innovative software solutions that make our lives easier, safer, healthier, and more productive.

If you’re an IT professional seeking your next career opportunity, we’d love to match your expertise with a role where you can thrive. Learn more at https://soltech.net/working-for-soltech/.

SOLTECH believes in the dignity of every individual and practices equal employment opportunity as a core principle. We consider all applicants without regard to race, color, age, sex, sexual orientation, gender identity, religion, marital status, national origin, disability, or veteran status.