Sign up to access all features of our service.
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

Data Integration and Business Intelligence Consultant_26-03825

Sunrise Systems Inc

Job Description

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
\nCompany Description

Founded in 1990, Sunrise Systems is an award winning IT/Professional Staffing firm to Fortune 500 and State/Local Government Agencies.

Company Description

Founded in 1990, Sunrise Systems is an award winning IT/Professional Staffing firm to Fortune 500 and State/Local Government Agencies.

Vacancy posted 2 days ago
Similar jobs that could be interesting for youBased on the Data Integration and Business Intelligence Consultant_26-03825 in Milwaukee, WI vacancy
  • $100k - $145k

     ...in rapidly expanding industries such as data centers, healthcare, pharmaceuticals, advanced...  ...through our Zero Harm policySenior Data Integration Engineer - Workforce AnalyticsRole...  ...technology assisted tools, including artificial intelligence (AI), to help identify and evaluate... 
    Data
    Full time

    Johnson Controls

    Milwaukee, WI
    2 days ago
  •  ...trusted source for property intelligence, with unmatched precision, depth...  ...Product Manager for AI Integration owns the strategy and delivery...  ...Cotality's insurance data products autonomously.This is...  ...the connector roadmap with business priorities across Claims, Underwriting... 
    Data
    Full time
    Contract work
    For contractors
    Local area
    Flexible hours

    CoreLogic

    Milwaukee, WI
    3 days ago
  • $95k - $120k

     ...Companies has a career opportunity for a Business Intelligence Analyst to support our growing Mission...  ...and efficiency opportunities Integrate process improvements into demonstrable...  ...Identify emerging and persistent data center industry challenges and collaborate... 
    Data
    Temporary work
    Work at office
    Work from home
    Flexible hours

    Ryan Companies US

    Milwaukee, WI
    1 day ago
  •  ...genius answers to seriously hard business challenges and work with some...  ...many of the same technology, data, AI, cybersecurity, and...  ...their scale. Accenture Edge integrates seamlessly with Avanade, our...  ...actually use. At the Senior Consultant level, you contribute meaningfully... 
    Data
    Full time
    Work experience placement
    Live in
    Work at office
    Local area

    Accenture

    Milwaukee, WI
    1 day ago
  •  ...About the Role: As a CBRE Business Intelligence Sr. Analyst, you will be responsible for conducting advanced research, data mining, reporting and interpretation of company performance metrics. This job is part of the Data Science & Analytics job function. They are... 
    Data
    Work at office

    CBRE

    Milwaukee, WI
    19 hours ago
  •  ...Software Development, Software Consultancy and Information Technology...  ...Deployment, Apex, VF, Salesforce Integration, Security...  ...JQueries to implement complex business requirementsFluent with SOSL...  ...on experience with Tools like Data Loader, Eclipse, SoapUI, APEX... 
    Data
    Permanent employment
    H1b

    Sonsoft

    Milwaukee, WI
    3 days ago
  • $125k

     ...wealth management infrastructure, real-time data solutions, and an enhanced advisor...  ...build and lead a team of data stewards and integration specialists responsible for both...  ...ensuring the information, definitions, and business context that power our AI and LLM-driven... 
    Data
    Work at office

    BetaNXT

    Brookfield, WI
    1 day ago
  •  ...Software Development, Software Consultancy and Information Technology...  ...Deployment, Apex, VF, Salesforce Integration, Security...  ...JQueries to implement complex business requirementsFluent with SOSL...  ...on experience with Tools like Data Loader, Eclipse, SoapUI, APEX... 
    Data
    Permanent employment
    Full time
    Work experience placement
    H1b
    Flexible hours

    Sonsoft

    Milwaukee, WI
    3 days ago
  •  ...capabilities in AI and Data, Industry and Process,...  ...to join our Strategy Consulting practice in the Automotive...  ...landscape of today's business world, leaders are...  ...enterprise function, business intelligence professionals, change...  ....Global Network: Integrated with Accenture's... 
    Data
    Full time
    Live in
    Work at office
    Local area
    Worldwide

    Accenture

    Milwaukee, WI
    3 days ago
  • $110.7k - $218.3k

     .... Work You'll Do As a Senior Consultant on the team, you will be responsible...  ...Oracle HCM Cloud technical integrations across enterprise...  ...interfaces, middleware coordination, data mapping, and end-to-end...  ...and certifications; and other business and organizational needs. The... 
    Data
    Local area

    Deloitte

    Milwaukee, WI
    13 hours ago
  • Data & ML Architect - New Resources ConsultingSummary...  ...closely with both business and technical teams to...  ...environments, support data integration and transformation,...  ...at New Resources Consulting Be part of the largest...  ...ContractCategory: Artificial Intelligence (AI)Date Posted: 2026-... 
    Data
    Remote work
    Flexible hours

    New Resources Consulting

    Milwaukee, WI
    1 day ago
  •  ...Software Development, Software Consultancy and Information Technology...  ...frameworks.Strong SFDC knowledge and Integration components for SFDC ( Cloud...  ...to implement complex business requirementsFluent with SOSL...  ...on experience with Tools like Data Loader, Eclipse, SoapUI, APEX... 
    Data
    Permanent employment
    H1b
    Flexible hours

    Sonsoft

    Milwaukee, WI
    13 hours ago
  • $155.6k - $306.8k

     ...execution, this team delivers integrated, end-to-end support and...  ...optimization, restructuring, business design and transformation, infrastructure...  ...'s Technology, AI, and Data Strategy professionals assist...  ...in strategy, management consulting, business transformation, or... 
    Data
    Local area
    Visa sponsorship

    Deloitte

    Milwaukee, WI
    3 days ago
  •  ...IBM Sterling Integrator Around 5 years of experience in IT industry. Strong development...  ...Organizations in initiatives requiring data, application and/or system integration while...  ..., design and delivery Outperform business demands by building creative, quality integration... 
    Data

    ClifyX

    Milwaukee, WI
    13 hours ago
  • $5,000 per month

     ...Delivery Manager can change yours.As an Design Integration Manager, you will lead and coordinate...  ..., and supported by accurate field data. Permitting Management: Facilitate permitting...  ...reviews and resolving design issues. Business Development and Pursuit Coordination and... 
    Data
    Temporary work
    Local area
    Flexible hours

    Michels Corporation

    Milwaukee, WI
    1 day ago
  • $122.5k - $423.78k

     ...SummaryAt PwC, our people in business services and support focus on...  ...meetings, oversee research and data analysis, promote consistent...  ...understanding that quality, integrity, inclusion and a commercial mindset...  ..., or Commercial Strategy (consulting or professional services) •... 
    Data
    Full time
    Temporary work
    H1b

    PwC

    Milwaukee, WI
    2 days ago
  • Company DescriptionUSM Business Systems Inc. is a quickly developing worldwide System Integrator, Software and Product Development...  ...Product Engineering, Business Intelligence, Data Management, SOA, BPM, Data Warehousing, SharePoint Consulting and IT Infrastructure. Our... 
    Data
    Work experience placement
    Immediate start
    Worldwide

    USM Systems

    Milwaukee, WI
    3 days ago
  •  ...across R&D functions, support business development, and contribute...  ...advanced capabilities in AI and Data, Industry and Process, and...  ...scientific strategy, data and AI integration, and operational reinvention....  ...solver with extensive consulting and industry experience. You... 
    Data
    Full time
    Work experience placement
    Live in
    Work at office
    Local area

    Accenture

    Milwaukee, WI
    13 hours ago
  • $117.5k - $222.99k

     ...core values of Quality, Integrity, and Opportunity,...  ...solutions for healthcare intelligence.Our company purpose is to empower easy, data-driven decision-making...  ...global, employee-owned consultancy providing actuarial...  ...compliance, data analytics and business transformation as well... 
    Data
    Full time
    Work experience placement
    Remote work
    Flexible hours

    Milliman

    Brookfield, WI
    4 days ago
  •  ...industry analysts.We're looking for a Senior Product Manager for Data & Integration to own and evolve the core platform capabilities that...  ...translate complex platform investments into clear customer and business value.Your Responsibilities:Lead product vision, roadmap,... 
    Data
    Full time
    Work at office
    Visa sponsorship
    Work visa
    Flexible hours

    Rockwell Automation

    Milwaukee, WI
    13 hours ago
  • $110.7k - $218.3k

     ...regulatory change, finance and global business services leaders recognize...  ...deep industry insights and integrated solutions to achieve business...  .... Work you'll do As a Senior Consultant on the Oracle EPM team, you...  ...applicationsSupporting data validation, user acceptance testing... 
    Data
    Local area
    Visa sponsorship

    Deloitte

    Milwaukee, WI
    2 days ago
  • $144.6k - $265.1k

     ...closely with CFOs, CIOs, and Business Unit leaders, we provide valuable...  ...for this role ends on 10/2/26.Work you’ll doAs a Workday...  ...which emphasizes flexibility, integrated client involvement, and rapid...  ...:8+ years of consulting or industry experience8+ years... 
    Local area

    Deloitte

    Milwaukee, WI
    1 day ago
  • $121.2k - $151.5k

     ...Senior AI Data Engineer We are seeking a highly experienced Senior...  ...Platform into an AI-native, intelligent platform where AI agents can discover...  ...scalable AI capabilities that integrate seamlessly with enterprise data platforms and business workflows. We offer:... 
    Data
    Local area

    KION GROUP

    Wauwatosa, WI
    2 days ago
  • $189.2k - $372.9k

     ...optimization, restructuring, business design and transformation, infrastructure...  ...close and translating messy data into crisp, IC-ready insights...  ..., synergy planning, and integration/carve-out readiness—while...  ...a global leader in providing consulting services to the asset... 
    Data
    Odd job
    Work experience placement
    Local area

    Deloitte

    Milwaukee, WI
    4 days ago
  • $89.04k - $133.56k

     ...manufacturing capability. Leading projects with Integrated Supply Chain (ISC), Department Leaders,...  ...to build plans and schedules following business cases. Scope of projects include...  ...practical solutions.Proficient in using data science and analytics tools to support project... 
    Data
    Full time
    Work at office
    Visa sponsorship
    Work visa
    Flexible hours

    Rockwell Automation

    Milwaukee, WI
    4 days ago
  • $87.4k - $253k

     ...We sit at the intersection of business strategy and technological...  ...areas such as go‑to‑market, AI integration/enablement/adoption, total enterprise...  ...for technology, semi, data center companies. Identify...  ...years of professional experience consulting for or working at a High‑Tech... 
    Data
    Live in
    Work at office
    Local area

    Accenture

    Milwaukee, WI
    2 days ago
  •  ...you energized by transforming complex business data into reliable, scalable solutions that...  ...enjoy designing and building robust data integration pipelines while collaborating closely...  ...processes that enable business intelligence, analytics, and operational reporting.... 
    Data
    Full time
    Remote work
    2 days per week
    3 days per week

    Baird

    Milwaukee, WI
    3 days ago
  •  ...us!Job DescriptionThe Device Integration Software System Architect defines...  ...Rockwell Automation intelligent devices within the Connected...  ...Responsibilities:Define device data management standards and integration...  ...for important product and business programs.Influence partners through... 
    Data
    Full time
    Work at office
    Visa sponsorship
    Work visa
    Flexible hours

    Rockwell Automation

    Milwaukee, WI
    13 hours ago
  • $141.2k - $278.3k

    Position Summary Integrated Manufacturing Ops Architect Manager...  ..., and implementers who drive business transformations. Our diverse...  ...MES), Supervisory Control and Data Acquisition (SCADA),...  ...Analytics, or Computer SciencePrior consulting experienceSoftware vendor certificationExperience... 
    Data
    Local area
    Visa sponsorship

    Deloitte

    Milwaukee, WI
    2 days ago
  •  ...advisory, digital, audit, tax, consulting, and outsourcing services....  ...demonstrate a high level of integrity and dependability with a strong...  ...sharing, employee engagement, business process automation, and...  ...appropriate permissions models, data protection controls, sensitivity... 
    Data
    Full time

    CliftonLarsonAllen

    Milwaukee, WI
    13 hours ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Data Integration and Business Intelligence Consultant_26-03825. Be the first to apply!