Lead Report Developer

Job DescriptionPosition 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) QualificationsBachelor'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 InformationThis position is expected to work in EST hours