[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.ResponsibilitiesLead end-to-end delivery of assigned SSRS report conversions, including dataset redesign and migration to SSAS Tabular models using DAXRefactor legacy SSRS reports from T-SQL stored procedures to semantic model-based reporting, ensuring accuracy and improved maintainabilityDesign and optimize SSRS reports with consistent layout, parameters, and interactive features for enhanced user experienceConfigure and manage report subscriptions (standard and data-driven), scheduling, and troubleshootingCollaborate with data engineers and analysts to validate business logic, reconcile outputs, and ensure data qualityImprove performance and scalability by tuning DAX queries, optimizing semantic models, and resolving bottlenecksServe as an IC architecture leader, defining best practices, standards, and patterns for reporting, semantic modeling, and data warehouse usageContribute to the evolution of the Snowflake data warehouse and dimensional data models aligned with reporting needsChampion DevOps best practices including source control, CI/CD pipelines, code reviews, and automated deploymentsDrive adoption of AI/LLM tools to accelerate development, testing, documentation, and analysis workflowsMentor team members through pairing, code reviews, and sharing reusable assets to improve overall engineering qualityDevelop and maintain comprehensive documentation, including report logic, data lineage, and operational runbooksSkillsAdvanced 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 optimizationExpert-level SQL/T-SQL skills, including stored procedures, debugging, and performance tuningExperience implementing SSRS datasets, parameters, and subscription modelsStrong understanding of performance optimization across reporting and semantic layersDemonstrated ability to leverage AI-assisted tools to enhance productivity, streamline workflows, and maintain engineering rigorProven ability to lead technical initiatives as an IC, including defining architecture and guiding team best practicesExperience working in DevOps environments using GitHub and/or Azure DevOps with CI/CD pipelinesStrong communication skills with the ability to translate business needs into technical solutionsHands-on experience applying AI-assisted development tools (e.g., Copilot, LLMs) to improve delivery speed and qualityExperience with Snowflake or other modern cloud data warehouse platformsStrong background in dimensional modeling (Kimball methodology, star schemas, fact/dimension design)Experience building or modernizing data pipelines and ELT processesKnowledge of Azure SQL Database and OLTP systems, including 3NF modeling principlesFamiliarity with SQL projects, deployment automation, and CI/CD pipelines (e.g., GitHub Actions)Experience implementing automated testing, data quality validation, and monitoring frameworksExposure to API integrations and tools such as Postman or SwaggerFamiliarity with Azure AI Search or modern search/indexing strategiesExperience using VS Code for database development, schema management, and version-controlled deploymentsCompany OverviewAtlanta Custom Software Development It was founded in 1998, and is headquartered in Atlanta, Georgia, USA, with a workforce of 51-200 employees. Its website is https://www.soltech.net.