Data Integration and Business Intelligence Consultant
•Today
| Hours | Full-time, Part-time |
|---|---|
| Location | Milwaukee, WI Milwaukee, Wisconsin open_in_new |
About this job
Job Description
Job Description
Technical Profile:
Qualities needed for Data role:
Job Title: Data Integration and Business Intelligence Consultant
Location:3 days on site, Milwaukee, WI
Duration: 6 months contract
Description:
Responsibilities:
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
Contact:
Jaya Balaji: jayabalaji.s@sunrisesys.com | (732) 515-5373 | URL: www.sunrisesys.co
Jaya Balaji: jayabalaji.s@sunrisesys.com | (732) 515-5373 | URL: www.sunrisesys.co
Nearby locations
Nearby Job Titles
Truck Driver Jobs Fast Food Preparation Worker Jobs Driver Jobs Machinery Maintenance Worker Jobs Delivery Driver JobsNearby Locations
Milwaukee, WI Jobs Waukesha, WI Jobs Brookfield, WI Jobs Menomonee Falls, WI Jobs Wisconsin JobsNearby Companies
DoorDash Jobs ApexFocusGroup Jobs U.S. Navy Jobs Hiring Drivers Now Jobs Payne & Dolan Incorporated JobsNearby Categories
Full-time Jobs Part-time Jobs Gig Jobs Posting ID: 1310099642 Posted: 2026-10-29 Job Title: Data Integration Business
Your Privacy Choices