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.

The immediate focus is delivering high-volume SSRS report conversions—transitioning from T-SQL stored procedure-based datasets to an SSAS Tabular semantic model using DAX. This individual will play a key contributor role in the conversion effort while also helping evolve the Snowflake data warehouse and semantic reporting layer. Over time, this position will shape broader data architecture strategy and elevate team capabilities through modern engineering practices and AI-driven development.

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

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.