[Remote] Data and Analytics Lead
Note: The job is a remote job and is open to candidates in USA. SOLTECH is seeking a highly technical, hands-on contractor to lead their Data & Analytics team. This role involves delivering high-volume SSRS report conversions and evolving the Snowflake data warehouse while shaping broader data architecture strategy through modern engineering practices and AI-driven development.
Responsibilities
- 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
- 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
Skills
- 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
- 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
- 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
Company Overview