Apply Now

Data Integration and Business Intelligence Consultant

Milwaukee, WI, US • Posted 30+ days ago • Updated 6 days ago

Contract W2

6 Months

No Travel Required

On-site

$47 - $51/hr

Fitment

Dice Job Match Score™

To see how well you match this job, please log in or create an account.

Once logged in, be sure to complete your profile to get the most accurate match score.

🔢 Crunching numbers...

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 30+ days 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.

Milwaukee, Wisconsin

•

Today

About the Job: We are looking for a highly motivated Security Automation Engineer with experience in Data Engineering to join NM's Security Automation & Data Analytics team. As a member of our team, you will play a pivotal role in designing, building and maintaining continuous and sustainable automated pipelines with the goal of enhancing the efficiency, effectiveness and accuracy of cybersecurity teams' capabilities reducing manual tasks for the IRC teams and enable data-driven cybersecurity o

Full-time

USD 130,800.00 per year

Sr. Threat Detection & Automation Engineer (with focus on Data Engineering)

Milwaukee, Wisconsin

•

Today

Full-time

USD 130,800.00 per year

Data Integration Engineer

Virginia

•

Today

ApplyLogic is a fast-paced Service-Disabled Veteran-Owned Small-Business, headquartered in Vienna, VA. Our people are our greatest asset, and our company culture is grounded on that belief. We offer challenging and interesting work in a friendly and supportive environment. Through prime and subcontracts, we deliver best-in-class expertise to solve complex technical problems. We're looking for a talented Data Integration Engineer IV to join our team supporting a complex Federal Government custome

Full-time

USD 125,000.00 - 155,000.00 per year

Data Integration Engineer

Remote

•

8d ago

Client is specifically looking for an Integration Developer with experience inIBM Webmethods (also known as IBM API Connect). Data Integration Engineer Client is seeking a talented individual to design, develop, test, and support enterprise data integration solutions that enable reliable data movement, transformation, and delivery across on-premises and cloud-based platforms. This role contributes to the development of scalable ETL processes, APIs, event-driven integrations, and automated data w

Easy Apply

Contract

55 - 60

Search all similar jobs

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

Data Integration and Business Intelligence Consultant

Dice Job Match Score™

Job Details

Skills

Summary

Jayabalaji Subbaroyal

Similar Jobs