Haystack
← Back to Jobs
Technology

Data Integration and Business Intelligence Consultant

Sunrise Systems, Inc.Milwaukee, WI🇺🇸United StatesPosted 10 Aug 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

Work Type
On Site
Level
Mid Senior

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

Skills

SQL
SQL Server
T-SQL
ETL
Snowflake
Agile
C#
Data Pipeline
Power BI
dbt

Similar jobs

Browse related jobs

Apply now