Technology

Data Integration and Business Intelligence Consultant

Sunrise Systems, Inc.Milwaukee, WI🇺🇸United StatesPosted Oct 9, 2026

Why This Role Stands Out

This role offers significant growth potential by empowering you to lead projects and mentor junior engineers in cutting-edge data integration and business intelligence. You'll thrive here if you're a mid-senior professional with a strong background in SSIS, SQL Server, and cloud technologies like Snowflake, eager to build complex data pipelines and contribute to a reputable technology company. Apply today to advance your skills in a dynamic and impactful environment!

Quick Overview

Seniority

Mid Senior

Work mode

On Site

Location

Milwaukee, WI, United States

Posted

1 week ago

SQLSQL ServerT-SQLETLSnowflakeAgileC#Data PipelinePower BIdbt

Job Description

Job Title: Data Integration and Business Intelligence Consultant Location:3 days on site, Milwaukee, WI Duration: 6 months contract
Description:
Responsibilities:

Owns delivery of hybrid data pipelines
Develops and maintains complex stored procedures, views, and functions
Builds and schedules SSIS packages for ETL
Integrates on-prem data sources with cloud securely and efficiently
Implements Snowflake best practices for performance, cost, and security
Leads small projects or initiatives
Provides technical guidance to junior engineers
Contributes to documentation and knowledge sharing
Monitors and optimizes pipeline performance
Builds and orchestrates batch and incremental workflows

Technical Profile:

3-5 years of experience in Data Integration / Business Intelligence in a complex environment working with SSIS
Proficient in Data Integration and Business Intelligence tools and concepts such as:
Data Integration concepts and strategies: ETL, EL-T, Data Warehousing, event-based processing
Data Integration tools: SSIS
Database: SQL Server
Data Query tools: SQL, T-SQL
Data Management and Quality: data mapping, data profiling, relational data modeling, dimensional data modeling
Building and loading relational (3NF) and dimensional data sets matching business needs
Familiarity with processing flat files, fixed-width, csv, json, xml, api's, message queues
Snowflake, dbt and/or other cloud data pipeline technologies
Knowledge of Business Intelligence tools such as: Alteryx, Microsoft Power BI, SSRS, and SSAS
Working knowledge of APIs and C# coding. (would be a plus)

Qualities needed for Data role:

Good communicator who wants to work in a team environment, comfortable working collaboratively with peers
Analytical not afraid to dive into complex code and data to troubleshoot issues
Creative problem solver who is automation focused we're looking to not have recurring work come back to us, but to better automate or teach/train users for self service
Motivated by small quick wins and process improvement
Comfortable working in an agile environment.
Data Query tools: SQL, T-SQL
Data Management and Quality: data mapping, data profiling, relational data modeling, dimensional data modeling
Building and loading relational (3NF) and dimensional data sets matching business needs
Familiarity with processing flat files, fixed-width, csv, json, xml, api's, message queues