Data Warehouse Analyst

6 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, Wisconsin, United States CapB InfoteK Full time

    Job Title: Data Warehouse Business AnalystJob Summary:We are seeking a highly skilled Data Warehouse Business Analyst to join our team at CapB InfoteK. As a Data Warehouse Business Analyst, you will be responsible for analyzing business needs and developing data warehouse solutions to meet those needs.Responsibilities:* Analyze business requirements and...

  • Data Warehouse Analyst

    3 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. 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, United States Computer Consultants International Full time

    JOB REQUIREMENTS: The Office of Data, Academic Planning & Institutional Research (DAPIR) is seeking a Data and Systems Analyst consultant to assist with analysis, documentation, and recommendations for retrofits of enterprise data systems relating to the implementation of Workday. This role will work with DAPIR staff to evaluate the impacts of upstream data...

  • Data Analyst

    4 weeks ago


    Madison, Wisconsin, United States SynergisticIT Full time

    We are seeking a highly motivated and skilled Data Analyst to join our team at SynergisticIT. As a Data Analyst, you will play a critical role in helping our clients make informed business decisions by analyzing and interpreting complex data sets.Key Responsibilities:Analyze and interpret large data sets to identify trends and patternsDevelop and maintain...


  • Madison Heights, United States Manpower Group Inc. Full time

    Technical Data Analyst We are looking for a Technical Data Analyst for our clients in Lake Orion, MI. Don’t wait… apply today! What's in it for you? $29.25 per hour 7 am to 4 pm with some flexibility Clean and safe work environment What will you be doing? Responsible for documenting non-compliance concerns with inbound shipments from...


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

    Job DescriptionInformation Resource Group, Inc. is seeking a highly skilled Data Warehouse Developer I to join our team. The ideal candidate will have experience in data warehousing process design, development, and performance tuning using the Informatica data warehousing tool suite.Key Responsibilities:Assist in ETL design, development, testing,...


  • Madison, Wisconsin, United States Goli Tech Full time

    Job Title: Data Warehouse Developer IJob Summary:Goli Tech is seeking a highly skilled Data Warehouse Developer I to join our team. The successful candidate will be responsible for providing technical expertise and services regarding Power BI report maintenance, creation, and SQL query development for the Department.Key Responsibilities:Provide technical...

  • Data Analyst

    4 weeks ago


    Madison, Wisconsin, United States Rural Mutual Insurance Full time

    We are seeking a highly skilled Data Analyst to join our team at Rural Mutual Insurance. The ideal candidate will have a strong background in data analysis and be able to work effectively with stakeholders across the organization.Key Responsibilities:Develop and maintain complex data models to support business decision-making.Analyze large datasets to...


  • Madison, Wisconsin, United States CapB InfoteK Full time

    Job DescriptionCapB InfoteK is seeking a highly skilled Business Intelligence Analyst to join our team. As a Business Intelligence Analyst, you will be responsible for analyzing business needs and developing solutions to meet those needs. This includes gathering and documenting business requirements, working with stakeholders to understand their needs, and...


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

    Data Warehouse Developer OpportunityWe are seeking a highly skilled Data Warehouse Developer to join our team at Focused HR Solutions. This is a unique opportunity to work on a challenging project with a direct client.Key Responsibilities:Design and develop data warehouses using Informatica tool suiteDevelop and implement data warehouse solutionsPerform data...

  • Data Analyst

    1 month ago


    Madison, Wisconsin, United States Scientific Research Full time

    Job SummaryAs a Data Analyst at Scientific Research Corporation, you will use analytical tools and techniques to extract meaningful insights from data extrapolated from key templates and operational support documents. You will apply data analysis techniques to support business process engineering and methodology development across OPSEC cycle and technology...


  • 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...


  • Madison, Wisconsin, United States Creative Financial Staffing Full time

    ETL DeveloperAt Creative Financial Staffing, we are seeking a skilled ETL Developer to join our team. As an ETL Developer, you will be responsible for designing, developing, and implementing efficient Extract, Transform, Load (ETL) processes to extract data from various sources, transform it into usable formats, and load it into data warehouses or target...


  • Madison, Wisconsin, United States UW Credit Union Full time

    Job Summary:UW Credit Union is seeking a skilled Data Analyst to support their Marketing department. The ideal candidate will have a passion for using data to drive business decisions and a strong understanding of data visualization tools.Key Responsibilities:Support strategic planning and initiatives by analyzing large datasets and providing actionable...


  • Madison, United States Randstad Full time

    information technology - systems analyst iii. madison , wisconsin posted 9 days ago job details summary $38.68 - $43.68 per hour contract bachelor degree category computer and mathematical occupations reference1071355 job details job summary: The Office of Data, Academic Planning & Institutional Research (DAPIR) is seeking a Data and Systems...


  • Madison, Wisconsin, United States Acxiom Full time

    Job Title: Business Intelligence Data AnalystJob Summary: We are seeking a highly skilled Business Intelligence Data Analyst to join our team. In this role, you will be responsible for designing, developing, and implementing advanced analytical solutions using Python/R, SQL, Power BI, Power Apps, and Databricks.Key Responsibilities:Develop and maintain...


  • Madison, United States Laurits R. Christensen Associates, Inc. Full time

    Christensen Associates has an exciting opportunity for a full-time Lead/Senior Data Analyst in our Madison, Wisconsin office. Do you enjoy leading people/projects, programming, solving problems, and optimizing processes? If you answered yes, this position is perfect for you! You will assist our Vice Presidents in leading our team of data analysts to solve...

  • Data Analyst

    4 weeks ago


    Madison, Wisconsin, United States UW Credit Union Full time

    Overview:UW Credit Unions Marketing department is seeking a skilled Data Analyst to support their growth and development. The ideal candidate will have a passion for using data to help solve problems and develop answers for business needs.The Data Analyst will be responsible for the design, development, maintenance, and delivery of analytic solutions for the...