Sign upLog in
See more jobs
Sunrise Systems Inc logo

Data Integration and Business Intelligence Consultant

Sunrise Systems Inc
  • Milwaukee, WI
  • Quick Apply
29 days ago

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
Contact:
Jaya Balaji: jayabalaji.s@sunrisesys.com | (732) 515-5373 | URL: www.sunrisesys.co

Numbers & Facts

LocationMilwaukee, WI
IndustryStaffing/Employment Agencies
Company Size100 to 499 employees
Year Founded1990
Websitehttp://www.sunrisesys.com/

About Company

Sunrise Systems was founded in 1990 with a clear vision to deliver world-class staffing service solutions in all labor categories, including IT consulting and solutions; all with the commitment to provide service that exceeds expectations and become the most trusted name in the industry. More than two and a half decades later, we pride ourselves on being at the forefront of the staffing industry. Combining our deep industry expertise, insights, and global resources, we have partnered with our clients to connect them with top professionals across several different industries.

We provide cost-effective Managed Staffing Solutions, Information Technology and Information Technology Consulting Services to several Fortune 500 companies and U.S. Government agencies. We provide our clients with flexible engagement models and customized products that are budget and time specific. Understanding the challenges that every business faces, we offer our services either on-site at the clients' site or from one of our globally distributed technology centers. Our onshore and offshore development capabilities ensure that we excel at meeting customer requirements every single time.

Our collective business experience spans over two and a half decades and ranges from:

  • Business, management, and technical fields
  • Information technology consulting and software solutions.
  • Providing strategic support for the development and long-term growth of new business ventures across several industries including but not limited to; accounting, banking, finance, and recruitment.
  • Motivating technology staff and establishing partnerships with Fortune 500 companies

Sunrise Systems has a vast range of competence in:

  • Design, development, and support of cloud-based solutions from simple to highly complexed
  • Database administration of multi-platform applications, complex databases, and web-based environments that include all aspects of installation, planning, maintenance, and monitoring.
  • Data processing and data migration
  • Application re-engineering and platform migration
  • Working with the Information Systems and end-user communities at all levels to resolve issues and establish consensus.

Skills

  • Analysis Skillsunmatched
  • Application Programming Interface (API)unmatched
  • Best Practicesunmatched
  • Business Intelligenceunmatched
  • Business Intelligence Softwareunmatched
  • Cloud Computingunmatched
  • Communication Skillsunmatched
  • Consultingunmatched
  • Data Managementunmatched
  • Data Mappingunmatched
  • Data Modelingunmatched
  • Data Profilingunmatched
  • Data Setsunmatched
  • Data Warehousingunmatched
  • Database Extract Transform and Load (ETL)unmatched
  • Dimensional Modelingunmatched
  • Documentationunmatched
  • Identify Issuesunmatched
  • JSONunmatched
  • Messaging Middlewareunmatched
  • Microsoft C# (C Sharp)unmatched
  • Microsoft Product Familyunmatched
  • Microsoft SQL Serverunmatched
  • Microsoft Transact-SQL (T-SQL)unmatched
  • Performance Tuning/Optimizationunmatched
  • Power BIunmatched
  • Process Improvementunmatched
  • SQL (Structured Query Language)unmatched
  • SQL Server Analysis Services (SSAS)unmatched
  • SQL Server Integration Services (SSIS)unmatched
  • SQL Server Reporting Services (SSRS)unmatched
  • Snowflake Schemaunmatched
  • Stored Proceduresunmatched
  • Team Playerunmatched
  • Technical Leadershipunmatched
  • Training/Teachingunmatched
  • XML (EXtensible Markup Language)unmatched

Be found by employers

5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.

Level up your application

Professional resume templates

Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.

Free resume templates

Free resume builder

Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.

Free resume builder