Company 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 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 Setting 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

📌 Lead Report Developer (Karnataka)
🏢 BETSOL
📍 Karnataka