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. Youll 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 (ROWNUMBER 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 :

• Bachelors 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

Remote Work :

No

Employment Type :

Contract