Data Warehouse Analyst

4 months ago


Madison, United States CapB InfoteK Full time

For one of our ongoing multiyear projects we are looking for a Data Warehouse Analyst out of Madison, WI.

Responsibilities:

• Ability to organize and lead meetings with technical, business and operational data owners from a wide array of backgrounds.
• Coordinates and communicates between business users and the business intelligence team. Manages the balance between business requirements and user expectations throughout the entire project lifecycle. Strives for a deeper understanding of our customers’ business drivers.
• Ability to document and speak competently to business objectives, gaps, needs and problems. Once documented, can leverage the knowledge and materials to help the IT team devise product and process solutioning that can be delivered to meet the defined needs of the business users. Works closely with the business users to document business processes. Focuses on specific business user needs such as how data is to be summarized, used in day to day operations and formatted in reports and dashboards.
• Uses experience as a liaison between business users and technologists to drive requirements into design, development, system testing, UAT and product deployment.
• Assists the IT team in the creation of adhoc documentation, including but not limited to; enhancement business requirements, charter contributions, process mapping, data flow diagrams, issue papers, options documents, report/dashboard requirements, requirement traceability matrixes, security assessments and other documents as assigned.
• Produces and executes business scenario test plans and test cases to meet functional requirements. Identifies and logs issues and manages through to resolution by working with the appropriate project resources. Demonstrates ability to communicate test results and possesses very strong analytical and organizational skills focusing on QA test process and its relationship to producing a quality end product. Desirable to have a good understanding of QA methodologies, testing techniques and BI development lifecycles.
• Demonstrates ability to manage competing priorities across multiple efforts at varying stages within the development lifecycle; keep up with fast-paced schedules; and learn new technologies quickly and effectively. Independently performs a variety of complicated tasks and relies on experience and judgment to plan and accomplish goals.
• Works independently and with team members to understand database structure, business process and the correlation between the two. Comfortable in a complex data environment and understanding of data structures.
• Ability to convey work and results to a wide variety of internal and external stakeholders from both technical and non-technical backgrounds.

Business processes improvement

Develop and implement test plan and test cases

Standardized process and procedures development

General Competencies

Experience communicating effectively across a wide variety of stakeholders

Experience independently facilitating meetings

Experience producing a wide array of project documentation

Problem troubleshooting, diagnostic, planning and time management

State of Wisconsin Privacy Regulations

Information Technology–Databases

Data flow diagramming

Data Warehouse - Experience in requirements gathering for data warehouse

Information Technology–Design

Participate in design reviews

Information Technology–Requirements

Documenting business processes

Process mapping current state and future state processes in Visio

Requirements analysis

Requirements gathering



  • Madison, United States CapB InfoteK Full time

    CapB is a global leader on IT Solutions and Managed Services. Our R&D is focused on providing cutting edge products and solutions across Digital Transformations from Cloud, AI/ML, IOT, Blockchain to MDM/PIM, Supply chain, ERP, CRM, HRMS and Integration solutions. For our growing needs we need consultants who can work with us on salaried or contract basis. We...


  • Madison, United States CapB InfoteK Full time

    For one of our ongoing multiyear projects, we are looking for a Data Warehouse Analyst out of Madison, WI. This position is for a dedicated IT Business Analyst; please do not submit ETL developers for this role. We are looking for a strong practitioner with 5 or more years of business requirements elicitation, documentation, stakeholder communication,...


  • Madison, United States CapB InfoteK Full time

    CapB is a global leader on IT Solutions and Managed Services. Our R&D is focused on providing cutting edge products and solutions across Digital Transformations from Cloud, AI/ML, IOT, Blockchain to MDM/PIM, Supply chain, ERP, CRM, HRMS and Integration solutions. For our growing needs we need consultants who can work with us on salaried or contract basis. We...


  • Madison, Wisconsin, United States CapB InfoteK Full time

    About the RoleCapB InfoteK is a global leader in IT Solutions and Managed Services, with a focus on providing cutting-edge products and solutions across Digital Transformations. We are seeking a highly skilled Data Warehouse Business Analyst to join our team.Key ResponsibilitiesDocument and communicate business objectives, gaps, needs, and problems to the IT...


  • Madison, Wisconsin, United States Focused HR Solutions Full time

    Focused HR Solutions is seeking a skilled and experienced Data Warehouse Developer to join our client's team in Madison, WI.This is an 8-month contract position with the possibility of extension. We are open to both W2 and Corp-to-Corp arrangements.Responsibilities:Design, develop, and maintain data warehouse solutions using Informatica tools.Collaborate...


  • Madison, United States Information Resource group, Inc. Full time

    Job DescriptionJob DescriptionIRG is needing Data Warehouse Developer Location Madison WI Duration: 3 Years To apply send resume to ahague@irginc.net The candidate will be responsible for assisting in ETL design, development, testing, maintenance, metadata, and implementation of data warehouse initiatives. Understand user requirements, and implement...


  • Madison, Wisconsin, United States Focused HR Solutions Full time

    About the Role We are seeking a skilled Data Warehouse Developer to join our client's team in Madison, WI. This is a fully remote position with an initial duration of up to 13 months, offering the possibility of extension. Responsibilities: Collaborate with stakeholders to gather requirements and develop technical specifications for ETL processes. Design...


  • Madison, Wisconsin, United States University of Wisconsin Full time

    About the RoleThe University of Wisconsin is seeking a highly skilled Business Intelligence Engineer to join our team. As a key member of our data analytics team, you will be responsible for designing, implementing, and maintaining databases, data warehouses, and data models to support analysis and reporting.Key ResponsibilitiesDatabase Design and...


  • Madison, United States Novalink Solutions LLC Full time

    Job DescriptionJob DescriptionWe have an immediate opening at the Department of Employee Trust Funds (ETF) for a strong Data Engineer to participate in our Data Management Program. Data is one of our most valuable assets and we strive to become a moredata-literate and data-driven organization. This position will work on a small, collaborative team that uses...

  • Data Analyst

    2 months ago


    Madison, Wisconsin, United States Flexion Inc. Full time

    Job DescriptionFlexion Inc. a Madison, WI based IT Consulting and Services firm is looking for a Data Analyst to work on a long-term consulting project. The client for this position is based in Madison, WI but work for this position can be done remotely in the United States.Duties for this position will include:The person in this role will be mining and...

  • Data Engineer

    2 weeks ago


    Madison, United States Great Lakes Full time

    JOB REQUIREMENTS: Job Description Job Summary Great Wolf Lodge is seeking a talented and motivated Data Engineer to join our Analytics team. As a Data Engineer, you will play a crucial role in shaping our data infrastructure and analytics capabilities, enabling data-driven decision-making across the organization. You will work closely with data scientists,...


  • Madison, United States Focused HR Solutions Remote Work Freelance Full time

    100% remote. Our direct client has an opening for an   Data Warehouse Developer 129720.This position is for up to 13 months with the option of extension, and the client is in Madison, WI.    Alteryx experience related to ETL, as many had experience based more on data prep. The manager is also looking for candidates with strong and recent SQL skills....


  • Madison, United States Focused HR Solutions Remote Work Freelance Full time $65 - $80

    Our direct client has an opening for a Data Warehouse Developer rec 89341    This position is for 8 months with the option of extension and is located in Madison WI  WE CAN WORK CORP TO CORP OR W2. If you are interested, please submit the following:YOUR CURRENT RESUME YOUR HOURLY RATE   Qualifications:7-Year Standard Background Check run internally by...

  • Data Analyst

    1 week ago


    Madison, United States Robert Half Full time

    Robert Half is seeking a data centric Business Systems Analyst in the Madison Mississippi area. This is a full time, fully onsite role offering excellent benefits and professional growth opportunities! The ideal candidate will have prior experience in working with SQL Databases, ETL, document management and data configuration skills as well as software...

  • Data Analyst

    1 week ago


    Madison, United States Robert Half Full time

    Robert Half is seeking a data centric Business Systems Analyst in the Madison Mississippi area. This is a full time, fully onsite role offering excellent benefits and professional growth opportunities! The ideal candidate will have prior experience in working with SQL Databases, ETL, document management and data configuration skills as well as software...

  • Data Analyst

    2 months ago


    Madison, Wisconsin, United States Flexion Inc. Full time

    Job DescriptionFlexion Inc. a Madison, WI based IT Consulting and Services firm is looking for a Data Analyst to work on a long-term consulting project. The client for this position is based in Madison, WI but work for this position can be done remotely in the United States. This position will potentially convert to a full time employee position in the...


  • Madison, Wisconsin, United States Focused HR Solutions Full time

    About the JobFocused HR Solutions is seeking a highly skilled Data Warehouse Developer to join our team on an 8-11 month contract basis. As a Data Warehouse Developer, you will be responsible for designing, developing, and implementing data warehousing solutions using the Informatica data warehousing tool suite.Key ResponsibilitiesDesign and develop data...

  • 8-11 Data Architect

    2 weeks ago


    Madison, United States Focused HR Solutions Full time $65 - $85

    PLEASE SEND RATES AND RESUME TO ZIPFHR@FHR-SOLUTIONS.COMThis position can be remote and coming into the office in Madison, WI as needed, hybrid or fully in office. The contractor does not need to live in Madison area but may need to come into office at times.  Our direct client has an opening for a Data Architect position # 88022. This position is for 12+...


  • Madison, United States Grand Leisure Corporation Limited Full time

    We're looking for an ambitious, energetic Omnichannel Marketing Analyst to join our rapidly growing team at Grand Leisure, an industry-leading supplier of outdoor patio furniture, accessories, and solar lighting in the North American mass retail market. With U.S. headquarters located in Madison, Wisconsin, we are a small(ish) team of sales, design, and...


  • Madison, Wisconsin, United States Quartz Full time

    About the RoleWe are seeking a highly skilled Data Analyst – Enterprise Solutions to join our dynamic Data Warehouse Team at Quartz, a provider-sponsored health plan dedicated to improving the health and well-being of our communities.Key ResponsibilitiesPartner with business stakeholders to evaluate data needs and translate into deliverables for internal...