Apply Now

Data Integration and Business Intelligence Consultant

Milwaukee, WI, US • Posted 13 hours ago • Updated 13 hours ago

Contract W2

6 Months

No Travel Required

On-site

$47 - $51/hr

Fitment

Dice Job Match Score™

🛠️ Calibrating flux capacitors...

Job Details

Skills

SSIS
SQL SERVER INTEGRATION SERVICES
SQL SERVER
T-SQL
TRANSACT-SQ
ETL
ELT
DATA INTEGRATION
DATA PIPELINE
DATA PIPELINES
SNOWFLAKE
DBT
CLOUD DATA
CLOUD PIPELINE
AZURE
AWS
DATA WAREHOUSE
DATA WAREHOUSING
DIMENSIONAL MODELING
DATA MODELING

Summary

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

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

Dice Id: sunrise
Position Id: 26-03825
Posted 13 hours ago

Contact the job poster

Jayabalaji Subbaroyal

Recruiter @ Sunrise Systems, Inc.

View Profile

Create job alert

Never miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Data Integration Developer

Milwaukee, Wisconsin

•

12d ago

About the Role: Are you energized by transforming complex business data into reliable, scalable solutions that power critical decisions? Do you enjoy designing and building robust data integration pipelines while collaborating closely with both technical and business partners? Are you looking to grow your expertise in modern data integration, data architecture, and evolving data platforms within a highly collaborative environment? As Baird continues to invest in data as a strategic asset, we are

Full-time

Senior Data Integration Engineer

Remote

•

Today

We are seeking a highly skilled, solution-oriented Senior Data Integration Engineer with deep expertise in modern data engineering, cloud-native architectures, and robust pipeline development. In this role, you will be a senior technical driver in creating, optimizing, and modernizing advanced data integration systems. You will collaborate closely with product, engineering, and architecture teams to bridge raw source environments and analytical databases. If you excel in cloud ecosystems, thrive

Full-time

Sr. Data Engineer

Remote

•

Today

The Sr Data Engineer is responsible for designing, building, and maintaining scalable data pipelines, infrastructure, and data visualization to support our data-driven decision-making processes. The scope of this job includes collaborating with data scientists, analysts, solutions partners, and other stakeholders to increase data quality, accessibility, and security. Key Responsibilities: Create, develop, maintain, and leverage data pipelines, data models, reporting, and dashboards to solve bus

Full-time

Database Administrators

Remote

•

Today

Job Title: Database Administrators Location: Irving, TX Employer: 4Consulting, Inc Position Type: Full Time Worksite: Remote Position Summary 4Consulting, Inc is seeking a qualified Database Administrators to support technology consulting, application development, systems analysis, testing, data management, cybersecurity, infrastructure, or project delivery services for client projects. The selected candidate will perform duties consistent with the clients project requirements and com

Easy Apply

Full-time, Third Party

Depends on Experience

Search all similar jobs

More jobs at Sunrise Systems, Inc. in Milwaukee, WI