Lead Report Developer

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)

• 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

This position is expected to work in EST hours