> Markdown version of [/jobs/ext/4428088-sql-server-bi-developer](https://www.wearedevelopers.com/jobs/ext/4428088-sql-server-bi-developer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# SQL Server BI Developer

- **Company:** Lrs Consulting Services
- **Location:** United States (Remote available)
- **Experience:** Experienced
- **Salary:** $104,000.0 - $114,400.0
- **Contract:** Permanent contract
- **Skills:** Microsoft Azure, Databases, Data Validation, Data Governance, Data Integration, Extract Transform Load (ETL), Data Structures, Data Warehousing, Relational Databases, Database Queries, Dimensional Modeling, Document-Oriented Databases, Microsoft SQL Server, SQL Azure, Query Optimization, Power BI, SQL Stored Procedures, SQL Server Reporting Services, SQL Server Agent, SQL Server Integration Services, SQL Server Analysis Services, Transact-SQL, Azure Data Factory, Git, Operational Systems, Data Management, SQL Server Management Studio (SSMS), Software Version Control, Sql Tuning
- **Published:** October 12, 2026
- **Apply:** https://www.indeed.com/viewjob?jk=b2c44cc64382a347

## About the Role

* 5+ years of experience working within the Microsoft SQL Server ecosystem.
 * Strong hands-on SSRS development experience.
 * Strong hands-on SSIS development experience.
 * Advanced T-SQL skills, including complex queries, stored procedures, functions and views.
 * Experience building and supporting ETL and data integration solutions.
 * Strong understanding of relational databases and data structures.
 * Experience with SQL performance tuning and query optimization.
 * Ability to troubleshoot data issues across source systems, ETL processes and reporting layers.
 * Strong analytical and problem-solving skills.
 * Ability to communicate effectively with technical teams and business stakeholders.

Preferred Qualifications

 * Power BI reporting and dashboard development
 * SQL Server Analysis Services (SSAS)
 * Data warehousing and dimensional modeling
 * Star and snowflake schemas
 * Azure Data Factory and Azure SQL
 * Azure DevOps and Git/source control
 * ERP, CRM, financial or operational system integrations
 * Enterprise data governance or master data management
 * Agile/Scrum development environments

Technical Environment

SQL Server | SSRS | SSIS | T-SQL | SSMS | SQL Server Agent | ETL | Stored Procedures | Data Integration | Data Warehousing | Power BI | SSAS | Azure

## Description

* Design, develop, enhance and support SSRS reports and operational reporting solutions.
 * Develop, maintain and troubleshoot SSIS packages supporting ETL and data integration processes.
 * Write and optimize complex T-SQL queries, stored procedures, functions and views.
 * Gather reporting and data requirements and translate them into technical solutions.
 * Build and maintain integrations between databases, applications and external systems.
 * Troubleshoot failed ETL processes, reporting issues and data discrepancies.
 * Perform data validation, reconciliation and root-cause analysis.
 * Monitor scheduled SQL Server jobs and data integration processes.
 * Improve the performance and reliability of existing reports, queries and ETL workflows.
 * Participate in testing, deployment and production support.
 * Document data mappings, ETL workflows, report specifications and support procedures.
 * Partner with business analysts, developers, database teams and business stakeholders.