Lead Report Developer

Job Description BETSOL is a cloud-first digital transformation and data management company offering products and IT services to enterprises in over 40 countries. BETSOL team holds several engineering patents, is recognized with industry awards, and BETSOL maintains a net promoter score that is 2x the industry average. BETSOL's open source backup and recovery product line, Zmanda (Zmanda.com), delivers up to 50% savings in total cost of ownership (TCO) and best-in-class performance. BETSOL Global IT Services (BETSOL.com) builds and supports end-to-end enterprise solutions, reducing time-to-market for its customers. BETSOL offices are set against the vibrant backdrops of Broomfield, Colorado and Bangalore, India. We take pride in being an employee-centric organization, offering comprehensive health insurance, competitive salaries, 401K, volunteer programs, and scholarship opportunities. Office amenities include a fitness center, cafe, and recreational facilities. Learn more at betsol.com Job Description Position Overview We are seeking an experienced Lead Report Developer with exceptional hands-on expertise in T-SQL, SSRS, Power BI, and data modeling to lead our reporting and analytics initiatives. This technical leadership role requires a seasoned professional who can design and develop complex reports and dashboards, optimize data models, mentor junior developers, and ensure delivery of high-quality BI solutions. You'll work closely with the BI Manager, stakeholders, and technical teams to translate business requirements into compelling visual analytics while maintaining technical excellence. Key Responsibilities Report & Dashboard Development: - Design and develop complex, interactive reports using SSRS (SQL Server Reporting Services) - Create advanced Power BI dashboards, reports, and data visualizations - Build paginated reports for operational and regulatory requirements - Develop mobile-responsive and accessible BI solutions - Implement drill-through, drill-down, and cross-filtering capabilities - Create parameterized reports with dynamic filtering and user-driven controls - Design executive dashboards with KPIs, scorecards, and performance metrics - Ensure consistent branding, formatting, and user experience across all reports Data Modeling & Design: - Design and develop star schema and snowflake schema data models - Create semantic layers and business logic layers in Power BI (data models, DAX measures) - Optimize data models for performance and scalability - Design and implement incremental refresh strategies - Develop composite models and aggregations for large datasets - Create reusable calculation groups and field parameters - Implement row-level security (RLS) and object-level security - Document data model design and relationships T-SQL Development & Optimization: - Write complex T-SQL queries, stored procedures, functions, and views - Develop data extraction and transformation logic for reporting - Optimize SQL queries for report performance - Create indexed views and materialized datasets for reporting - Design and implement data aggregation tables - Perform query tuning and execution plan analysis - Develop dynamic SQL for flexible reporting solutions - Create and maintain reporting-specific database objects Technical Leadership: - Lead report development projects from requirements through deployment - Provide technical guidance and mentorship to junior report developers - Conduct code reviews and ensure adherence to development standards - Define and enforce reporting best practices and design patterns - Evaluate new BI technologies, features, and techniques - Collaborate with ETL Architect on data availability and performance - Work with BI Manager on project prioritization and delivery - Participate in technical design sessions and architecture discussions Performance Optimization: - Analyze and optimize report performance and rendering times - Tune Power BI data models and DAX calculations for efficiency - Optimize SSRS report queries and data retrieval methods - Implement caching, subscriptions, and snapshot strategies - Monitor report usage and performance metrics - Identify and resolve performance bottlenecks - Optimize large dataset handling and visualization rendering Requirements Analysis & Solution Design: - Collaborate with business stakeholders to understand reporting requirements - Translate business needs into technical report specifications - Design report layouts, visualizations, and navigation flows - Create mockups and prototypes for stakeholder review - Recommend optimal visualization types for different data scenarios - Ensure reports meet usability and accessibility standards - Document technical specifications and report logic Quality Assurance & Testing: - Develop and execute comprehensive testing plans for reports - Perform data validation and reconciliation against source systems - Conduct UAT (User Acceptance Testing) with business users - Ensure data accuracy, completeness, and consistency - Test reports across different browsers, devices, and scenarios - Validate calculations, filters, and business logic - Document test cases and results Deployment & Support: - Deploy reports to production environments (Power BI Service, SSRS Server) - Configure report subscriptions, alerts, and data refresh schedules - Manage workspace administration and access permissions in Power BI - Troubleshoot production report issues and data discrepancies - Provide post-deployment support and enhancements - Create user documentation and training materials - Train end users on report features and functionality Required Qualifications Experience: - 6-8 years of experience in report development and business intelligence - 2-3 years in a lead or senior developer role - Extensive hands-on experience with SSRS and Power BI in enterprise environments - Proven track record delivering complex reporting solutions - Strong background in data modeling and dimensional design Technical Expertise - T-SQL: - Expert-level T-SQL programming skills including: - Complex queries with multiple joins, subqueries, and CTEs - Window functions (ROW_NUMBER, RANK, LEAD, LAG, etc.) - Stored procedures, functions, and triggers - Dynamic SQL and parameterization - Query optimization and performance tuning - Indexing strategies for reporting - Temporary tables, table variables, and derived tables - Pivoting, unpivoting, and data aggregation techniques Technical Expertise - SSRS: - Advanced SSRS development skills including: - Complex report layouts (tablix, matrix, charts, gauges, maps) - Parameterized reports with cascading parameters - Subreports and drillthrough reports - Custom expressions and embedded code - Report subscriptions and data-driven subscriptions - Report caching and snapshot execution - Custom assemblies and extensions - Mobile report development - Report Builder and Report Designer Technical Expertise - Power BI: - Advanced Power BI development skills including: - Power BI Desktop and Power BI Service - DAX (Data Analysis Expressions) - complex measures, calculated columns, calculated tables - Power Query (M language) for data transformation - Data modeling and relationships - Custom visuals and custom formatting - Bookmarks, buttons, and interactive navigation - Row-level security (RLS) implementation - Incremental refresh and aggregations - Power BI Gateway configuration - Workspace and app management - Power BI Dataflows and Datamarts (preferred) Data Modeling: - Strong dimensional modeling expertise (star schema, snowflake schema) - Understanding of normalization and denormalization principles - Experience with slowly changing dimensions (SCD Type 1, 2, 3) - Knowledge of fact tables, dimension tables, and bridge tables - Ability to design optimized data models for analytical queries - Understanding of data warehouse and data mart concepts Core Competencies: - Exceptional problem-solving and analytical skills - Strong attention to detail and data accuracy - Excellent communication skills for technical and business audiences - Ability to translate complex data into clear visualizations - Leadership and mentoring capabilities - Self-motivated with ability to work independently - Strong time management and multitasking abilities - Collaborative team player with customer-focused approach Preferred Qualifications - Experience with other BI tools (Tableau, Qlik, Looker) - Knowledge of Azure cloud services (Azure Synapse, Azure SQL Database) - Familiarity with Python or R for advanced analytics - Experience with Power BI embedded solutions - Understanding of data visualization best practices and design principles - Knowledge of SSIS and Azure Data Factory - Experience with version control (Git, Azure DevOps) - Background in Agile/Scrum development methodologies - Industry-specific domain knowledge (finance, healthcare, retail, etc.) Key Success Metrics - Quality and accuracy of delivered reports - Report performance and optimization improvements - On-time delivery of reporting projects - User adoption and satisfaction rates - Code quality and adherence to standards - Effectiveness of team mentorship and knowledge sharing - Reduction in report development time through reusable components - System performance and scalability of BI solutions Technical Environment - BI Tools: Power BI Desktop, Power BI Service, SSRS - Databases: SQL Server 2016+, Azure SQL Database - Development: SQL Server Management Studio (SSMS), Visual Studio, DAX Studio - Version Control: Git, Azure DevOps - Additional: Power Query, Excel, SharePoint - Cloud: AWS, Azure (preferred) Qualifications - Bachelor's degree in Computer Science, Information Systems, or related field - Microsoft certifications: - Microsoft Certified: Power BI Data Analyst Associate - Microsoft Certified: Data Analyst Associate Additional Information This position is expected to work in EST hours