> Markdown version of [/jobs/ext/3054293-msbi-data-engineer](https://www.wearedevelopers.com/jobs/ext/3054293-msbi-data-engineer). 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).

---

# MSBI Data Engineer

- **Company:** Spectraforce
- **Location:** United States (Remote available)
- **Experience:** Expert
- **Contract:** Temporary contract
- **Skills:** Microsoft Excel, Data Analysis, CA Workload Automation Ae, Data Validation, Extract Transform Load (ETL), Data Mining, Data Warehousing, Dimensional Modeling, Excel Formulas, Lookup Table, Microsoft Business Intelligence, Pivot Tables, Query Optimization, SQL Stored Procedures, SQL Server Reporting Services, SQL Server Integration Services, Data Streaming, Transact-SQL, Macros
- **Published:** September 24, 2026
- **Apply:** http://leoforce.us/Careers/Spectraforce/JobDetails.html?jobid=40d5937b-a62b-46d4-87ba-4a74d6718d33&OrgId=1&UserId=2044

## About the Role

* 7-9 years of hands-on experience with T-SQL, stored procedures, functions, and query optimization
 * Solid understanding of data warehouse concepts and ETL principles
 * Strong ability to read, interpret, and troubleshoot ETL pipelines/data flows (SSIS) and reports (SSRS)
 * Advanced Excel skills for data analysis and reporting
 * Strong analytical and problem-solving skills
 * Excellent verbal and written communication skills, with a proactive approach to client/stakeholder communication
Preferred Skills

 * Prior experience in the Insurance or Finance domain
 * Knowledge of Autosys scheduler tool will be an asset
 * Exposure to data quality checks, reconciliation, or audit processes

## Description

We are seeking a skilled Data Engineer to join our data team supporting a critical client engagement. The ideal candidate will have strong hands-on experience with T-SQL development, stored procedures, and data warehousing concepts, along with the ability to read and troubleshoot ETL pipelines and communicate proactively with stakeholders. Experience in the insurance or finance domain is strongly preferred.
Key Responsibilities

 * Design, develop, and optimize T-SQL queries and stored procedures for data extraction, transformation, and reporting
 * Apply strong data warehouse concepts (dimensional modeling, ETL processes, fact/dimension tables) to support ongoing data initiatives
 * Read, interpret, and troubleshoot ETL pipelines and data flows built in SSIS; support and interpret reports built in SSRS
 * Perform data analysis using advanced Excel functions (pivot tables, VLOOKUP/XLOOKUP, macros, etc.) to support business reporting needs
 * Take ownership of client communication - proactively flagging data issues, sharing progress updates, and following through on resolutions.
 * Work closely with business and technical stakeholders to gather requirements, clarify data issues, and deliver solutions
 * Provide production support including occasional weekend maintenance windows and holiday support as required
 * Document processes, data flows, and issue resolutions clearly for team and stakeholder reference


## Related Videos

- [Data Science on Software Data](https://www.wearedevelopers.com/videos/162-data-science-on-software-data)
- [Crafting Custom Frameworks with Rust: A Deep Dive into Procedural Macros](https://www.wearedevelopers.com/videos/849-crafting-custom-frameworks-with-rust-a-deep-dive-into-procedural-macros)
- [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works)
- [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt)
- [Modularity: Let's dig deeper](https://www.wearedevelopers.com/videos/1200-modularity-let-s-dig-deeper)
- [Data Mining Accessibility](https://www.wearedevelopers.com/videos/802-data-mining-accessibility)

## Related Articles

- [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk)
- [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk)
- [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know)
- [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers)
- [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)
- [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)