Data Warehouse Analyst

7 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

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

  • Data Warehouse Business Analyst

    4 months ago

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

  • Data Warehouse Specialist

    2 weeks ago

    Madison, Wisconsin, United States Quartz Health Solutions Full time

    About Quartz Health SolutionsWe are seeking a highly skilled Senior ETL Developer to join our Enterprise Data Management (EDW) Team. This role will be responsible for the creation and maintenance of extract, transform, and load (ETL) logic necessary to cleanse and move data from various source systems into the corporate data warehouse.Key...

  • Business System Analyst

    1 month ago

    Madison, United States RIT Solutions, Inc. Full time

    Here you can help with this one. They must live in WI Business System Analyst / Data Analyst Contract: 12 months We are hiring a Business System Analyst / Data Analyst to join our team in Wisconsin! Responsibilities Collaborate with internal resources as well as partner projects across the organization nalyze existing data warehouses (Oracle, Snowflake)...

  • Data Insights Analyst

    3 days ago

    Madison, Wisconsin, United States Newance Full time

    Newance Job Description:We are looking for a talented Data Analyst to join our team. As a key member of our organization, you will play a vital role in driving business decisions through data-driven insights. With a strong background in data analysis and business intelligence, you will be responsible for managing our data warehouse, creating reports and...

  • Data Analyst Quality Assurance Specialist

    4 weeks ago

    Madison, Wisconsin, United States Quartz Health Solutions Full time

    Job Title: Data Analyst Quality AssuranceJob Summary: We are seeking a highly skilled Data Analyst Quality Assurance professional to join our dynamic Data Warehouse Team at Quartz Health Solutions. As a Data Analyst Quality Assurance, you will partner with the business to evaluate data needs and translate them into deliverables for internal users and...

  • Data Analyst Quality Assurance Specialist

    1 week ago

    Madison, Wisconsin, United States Quartz Health Solutions Full time

    OverviewWe are seeking a highly skilled Data Analyst - Quality Assurance to join our dynamic Data Warehouse Team at Quartz Health Solutions. As a key member of the team, you will partner with business stakeholders to evaluate data needs and develop deliverables for internal users and analytics applications.

  • Data Analyst

    4 weeks ago

    Madison, Wisconsin, United States RIT Solutions, Inc. Full time

    Job DescriptionAt RIT Solutions, Inc., we are seeking a skilled Data Analyst - Business Systems Integration to join our team in Wisconsin. The successful candidate will be responsible for collaborating with internal resources and partner projects across the organization to analyze existing data warehouses, Tableau dashboards, and ancillary systems for...

  • Data Warehouse Architect

    1 week ago

    Madison, Wisconsin, United States Novalink Solutions LLC Full time

    We are seeking an experienced Data Warehouse Architect to join our team at Novalink Solutions LLC. As a key member of our data analytics group, you will be responsible for designing and implementing scalable data warehouses that meet the evolving needs of our organization.Estimated salary: $120,000 - $180,000 per year.Job Description:The successful candidate...

  • Data Engineer II Cloud Data Warehouse

    3 weeks ago

    Madison, United States AMERICAN FAMILY MUTUAL INSURANCE CO Full time

    JOB REQUIREMENTS: Work on collecting, storing, processing, and building Business Intelligence and Analytics applications within our Cloud data warehouse. Presently, our team is constructing an enterprise data lake to enable analysts and scientists to self-service data at scale across American Family\'s operating companies. We\'re leveraging open- source...

  • Warehouse Data Developer Lead

    2 weeks ago

    Madison, Wisconsin, United States Syntricate Technologies Full time

    About the JobWe are seeking an experienced Warehouse Data Developer III to join our team at Syntricate Technologies. As a key member of our data warehousing team, you will be responsible for designing, developing, and implementing data warehouse solutions using various tools and technologies.The successful candidate will have a strong background in ETL...

  • Data Analyst

    4 weeks ago

    Madison, Wisconsin, United States Rural Mutual Insurance Full time

    Job DescriptionWe are seeking a highly skilled Data Analyst to support our product, sales, leadership, and marketing teams with actionable insights derived from analyzing company data. The ideal candidate will possess a strong ability to work with large datasets, extract meaningful information, and communicate findings effectively to stakeholders.Main...

  • Data Analyst

    4 weeks ago

    Madison, United States Rural Mutual Insurance Full time

    Description We are looking for a Data Analyst who will support our product, sales, leadership, and marketing teams with insights gained from analyzing company data. The ideal candidate is adept at using large data sets to answer questions and provide insight into the business. They must have experience using a variety of data mining/data analysis methods,...

  • Healthcare Data Analyst

    3 weeks ago

    Madison, Wisconsin, United States Lifelancer Full time

    Job Title: Clinical Registry AnalystJob Location: Madison Metropolitan Area, WI, USAJob Type: Full-time, RemoteSalary:$70,000 - $90,000 per yearCompany OverviewLifelancer is a talent-hiring platform in Life Sciences, Pharma, and IT. We connect professionals with opportunities in pharma, biotech, health sciences, healthtech, and IT domains.Job DescriptionWe...

  • Data Warehouse Developer and Business Intelligence Specialist

    4 weeks ago

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

    Information Resource Group, Inc. is seeking a highly skilled Data Warehouse Developer I to join our team in Madison, WI.Estimated Salary: $85,000 - $115,000 per yearThis exciting opportunity allows you to work on challenging data warehousing projects, utilizing your technical expertise to design, develop, and implement robust data warehouse solutions.The...

  • Cloud Data Warehouse Architect

    2 weeks ago

    Madison, Wisconsin, United States AMERICAN FAMILY MUTUAL INSURANCE CO Full time

    Company OverviewAmerican Family Mutual Insurance Co is a leading insurance provider that is shaping the future of the industry. We are seeking a highly skilled Data Engineer II Cloud Data Warehouse to join our team.

  • LU - Data Warehouse Developer

    7 months ago

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

  • Data Warehouse Developer 8-11

    4 months ago

    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 Engineer II Cloud Data Warehouse Specialist

    1 week ago

    Madison, Wisconsin, United States AMERICAN FAMILY MUTUAL INSURANCE CO Full time

    Job Summary: We are seeking a highly skilled Data Engineer II Cloud Data Warehouse to join our team at American Family Mutual Insurance Co. In this role, you will be responsible for designing, building, and maintaining large-scale cloud data warehouses to support business intelligence and analytics applications.Key Responsibilities:Design and implement data...

  • Data Analyst Specialist

    2 weeks ago

    Madison, Wisconsin, United States Rural Mutual Insurance Full time

    About the RoleWe are seeking a highly skilled Data Analyst Specialist to join our team at Rural Mutual Insurance. This role is ideal for an individual who is passionate about working with data to drive business insights and improvements.Job SummaryThe successful candidate will be responsible for analyzing large data sets to identify trends, opportunities,...