Data Warehouse Analyst III | Beacon Technologies

Data Warehouse Analyst III

Posted on September 20, 2021


Madison, WI

Position Details


Job Summary

Beacon Technologies is looking to hire a Data Warehouse Analyst III. This role is based in Madison, Wisconsin.

Job Description

This role is for a strong practitioner with five or more years of business requirements elicitation, documentation, stakeholder communication, requirements verification, testing, quality assurance and data analysis activities as primary job responsibilities. As the analyst, you must be willing to participate in and actively document different aspects of the project lifecycle. 

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

Experience working in a BA/QA capacity on data warehouse/business intelligence projects is helpful!

Requirements we are seeking:

  • Business process improvement (4 years)
  • Standardized processes and procedures implementation (5 years)
  • Develop and implement test plan and test cases (3 years)
  • Understands QA methodologies and testing techniques (3 years)
  • State of WI privacy regulations (2 years)
  • Experience independently facilitating meetings (4 years)
  • Experience communicating effectively across a wide variety of stakeholders (4 years)
  • Experience producing a wide array of project documentation (4 years)
  • Problem troubleshooting, diagnostic, planning and time management (4 years)
  • Experience in Business Intelligence (4 years)
  • Experience in the Human Services field (4 years)
  • Data analysis (3 years)
  • Data flow diagramming (4 years)
  • Experience in data warehouse design and development (3 years)
  • Experience in requirements gathering for data warehouse (4 years)
  • Develop design specifications (3 years)
  • Knowledge of Kimball data warehouse and BI lifecycle methodology (3 years)
  • Participate in design reviews (4 years)
  • Documenting business process (5 years)
  • Process mapping current state and future state processes in Visio (5 years)
  • Requirements traceability matrix development (2 years)
  • Requirements analysis (5 years)
  • Requirements gathering (5 years)

About Beacon Technologies

Are you looking to advance your career in information technology? Beacon Technologies offers career advancement opportunities, extensive training, and excellent benefits including paying for health and dental premiums for salaried employees. In addition to providing interesting opportunities, Beacon Technologies provides that old fashioned, personal touch, so you feel like a part of the Beacon team.