Data Warehouse Analyst

2 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, requirements verification, testing, quality assurance and data analysis activities as primary job responsibilities. Furthermore, we are looking for an engaged analyst willing to participate in and actively document different aspects of the project lifecycle. Preference will be given for candidates who have previous experience working in a BA/QA capacity on data warehouse/business intelligence projects.

 

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.

 

Must Have:

Business processes improvement

Develop and implement test plan and test cases

Standardized processes and procedures implementation

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

Familiarity with state privacy statutes

Data flow diagramming

Experience in requirements gathering for data warehouse

Participate in design reviews

Documenting business processes

Process mapping current state and future state processes in Visio

Requirements analysis

Requirements gathering

Requirements traceability matrix development

 

Nice to Have:

Understands QA methodologies and testing techniques

General Competencies

Experience in business intelligence

Experience in the Human Services field

Data analysis

Experience in data warehouse design and development

Develop design specifications

Knowledge of Kimball data warehouse design principals



  • Madison, Wisconsin, United States CapB InfoteK Full time

    Job Title: Data Warehouse AnalystWe are seeking a highly skilled Data Warehouse Analyst to join our team at CapB InfoteK. As a Data Warehouse Analyst, you will play a critical role in the development and maintenance of our data warehouse infrastructure.Key Responsibilities:Lead meetings with technical, business, and operational data owners to gather...


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


  • Madison, Wisconsin, United States CapB InfoteK Full time

    Job DescriptionCapB InfoteK is seeking a highly skilled Data Warehouse Business Analyst to join our team. As a key member of our organization, you will be responsible for analyzing business needs and developing data warehouse solutions to meet those needs.Key ResponsibilitiesBusiness Requirements Elicitation: Work with stakeholders to gather and document...


  • Madison, Wisconsin, United States CapB InfoteK Full time

    Job Title: Data Warehouse Business AnalystCapB InfoteK is a global leader in 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.We are seeking a highly skilled Data Warehouse...

  • Data Warehouse Analyst

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


  • Madison, Wisconsin, United States CapB InfoteK Full time

    Job Title: Data Warehouse AnalystCapB InfoteK is seeking a highly skilled Data Warehouse Analyst to join our team. As a Data Warehouse Analyst, you will play a critical role in designing, developing, and maintaining our data warehouse infrastructure.Responsibilities:Meetings and Communication: Lead meetings with technical, business, and operational data...


  • 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 Quartz Health Solutions Full time

    Job Title: Data Analyst Quality AssuranceQuartz Health Solutions is seeking a highly skilled Data Analyst Quality Assurance professional to join our dynamic Data Warehouse Team. As a key member of our team, you will be responsible for ensuring the quality and accuracy of our data warehouse and analytics applications.Responsibilities:Collaborate with business...


  • Madison, Wisconsin, United States Quartz Health Solutions Full time

    Job Title: Data Analyst Quality AssuranceQuartz Health Solutions is seeking a highly skilled Data Analyst Quality Assurance professional to join our dynamic Data Warehouse Team.Job Summary:We are looking for a detail-oriented and analytical individual to partner with our business stakeholders to evaluate data needs and translate them into deliverables for...


  • 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. As a Data Warehouse Developer, you will be responsible for designing, developing, and implementing data warehousing solutions using the Informatica tool suite.Key Responsibilities:Design and develop data warehousing solutions...


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

    Data Warehouse Developer OpportunityFocused HR Solutions is seeking a skilled Data Warehouse Developer to join our team. As a Data Warehouse Developer, you will be responsible for designing, implementing, and maintaining data warehouses using ETL tools such as Alteryx.Key Responsibilities:Design and develop ETL processes to extract, transform, and load data...


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

    Job Title: Data Warehouse DeveloperWe are seeking a skilled Data Warehouse Developer to join our team at Focused HR Solutions. As a Data Warehouse Developer, you will be responsible for designing, implementing, and maintaining data warehouses using ETL tools such as Alteryx.Key Responsibilities:Design and implement ETL processes using Alteryx and other ETL...


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

    Job Title: Data Warehouse DeveloperInformation Resource Group, Inc. is seeking a skilled Data Warehouse Developer to join our team.Job SummaryWe are looking for a highly motivated and detail-oriented individual to assist in the design, development, testing, and maintenance of our data warehouse initiatives. The successful candidate will have a strong...


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

  • Data Analyst

    3 days 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...

  • Data Analyst

    2 weeks ago


    Madison, Wisconsin, United States Rural Mutual Insurance Full time

    Job Title: Data AnalystWe are seeking a highly skilled Data Analyst to join our team at Rural Mutual Insurance. As a Data Analyst, you will play a critical role in supporting our product, sales, leadership, and marketing teams with actionable insights gained from analyzing company data.Key Responsibilities:Work closely with stakeholders to identify...

  • Data Analyst

    2 weeks ago


    Madison, Wisconsin, United States Rural Mutual Insurance Full time

    Job Title: Data AnalystWe are seeking a highly skilled Data Analyst to join our team at Rural Mutual Insurance. As a Data Analyst, you will play a critical role in supporting our product, sales, leadership, and marketing teams with insights gained from analyzing company data.Key Responsibilities:Work closely with stakeholders to identify opportunities for...

  • Data Analyst

    1 week ago


    Madison, Wisconsin, United States BlueCloud Full time

    Data Analyst RoleWe are seeking a highly skilled Data Analyst to join our team at BlueCloud. The ideal candidate will have 5-7 years of experience in commercial insurance (Property & Casualty) domain and a strong understanding of business processes and data flow across the Policy and Claims lifecycle.Key Responsibilities:Extract and manipulate data using SQL...


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

  • Data Analyst

    4 weeks ago


    Madison, Wisconsin, United States Rural Mutual Insurance Full time

    About the RoleRural Mutual Insurance is seeking a highly skilled Data Analyst to join our team. As a Data Analyst, you will play a critical role in supporting our product, sales, leadership, and marketing teams with insights gained from analyzing company data.Key ResponsibilitiesWork with stakeholders to identify opportunities for leveraging company data to...