MSBI Data Engineer

Spectraforce

United States

3 days ago

Apply on leoforce.us

Prepare application

Role details

Contract type

Temporary contract

Employment type

Full-time (> 32 hours)

Experience level

Expert

Experience required

7 years minimum

Working hours

Shift work

Job source

leoforce.us

Tech stack

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

+7 more

Query Optimization SQL Stored Procedures SQL Server Reporting Services SQL Server Integration Services Data Streaming Transact-SQL Macros

Job 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

Requirements

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

Benefits & conditions

Must be available and flexible to work on an alternating shift basis - 9:00 AM - 5:00 PM EST and 1:00 PM - 9:00 PM EST
Must be willing to support occasional weekend maintenance windows
Must be available to support holiday coverage as per business needs