Job Details

ID #45162293
State Wisconsin
City Madison
Job type Contract
Salary USD $0 - $0 0 - 0
Source IO Datasphere
Showed 2022-08-25
Date 2022-08-24
Deadline 2022-10-23
Category Et cetera
Create resume

Data Warehouse Analyst

Wisconsin, Madison, 53701 Madison USA

Vacancy expired!

IO Datasphere, Inc. has been providing project management, software development and IT staff augmentation services to our clients in the Midwest and throughout the U.S. since 1996. We are an approved vendor on contract to provide software development and IT staff augmentation services for the States of Illinois, Michigan, Minnesota, Iowa, and Wisconsin. We also provide these services to businesses, as well as local and county governments, in the Midwest and nationwide.Our client is looking for a Data Warehouse Analyst professional. People skills are extremely important in this position. There’s a lot of interaction with both the team and the customer.

Tasks
  • Responsible for leading and facilitating the communication with IT staff, business customers and other stakeholders from a wide array of backgrounds, implementation services, and support services to assist in the development, implementation and support of business intelligence.
  • 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.
  • 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.
  • Understands business objectives and problems, identifies alternative solutions, performs feasibility studies and cost/benefit analysis of alternatives in support of enterprise-wide business intelligence. Manages the balance between business requirements and user expectations. Strives for a deeper understanding of our customers’ business drivers.
  • Uses extensive experience as a liaison between users and technologists to drive requirements into design.
  • Analyzes user requirements, procedures, and problems to automate processing or to improve existing processes.
  • Works with the team lead and manager to determine a detailed and prioritized list of objectives and activities for current and future projects.
  • Experience with Human Services business intelligence is desirable.
  • Responsibilities include project work enhancing existing/new processes through data sharing, configuration, report writing and metrics.
  • Troubleshoot and resolve issues efficiently. Identify potential technology improvements to be leveraged in support of the business. Assist in the creation and maintenance of test plans.
  • Participate in special projects as required.
  • 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.
  • Provide support for data warehousing initiatives and monitor data warehousing system to ensure reliability and accuracy of information loaded into the databases.
  • Analyze the logical and physical database models and ensure models are in accordance with standards. Generate and prepare reports to support business objectives.
  • Perform analysis and testing of relational databases and investigate any data load failures or data retrieval issues.
  • Participate and document different aspects of the project lifecycle
  • Independently analyze, document, and speak competently to business objectives, gaps, needs and problems.
Note: Local candidates or willing to relocate at the candidate's expense. This position is mostly remote, but candidate must be able to be on-site as needed Location: Madison, WIContract: 1+ years

Skills Required:
  • 5+ years - Experience with business requirements elicitation, documentation, stakeholder communication, requirements verification, testing, quality assurance and data analysis
  • 5 years - Change Management
  • 5 years - Demonstrated experience in the design and utilization of performance measures and report
  • 5 years - Business Process Improvement
  • 7 years - Standardized processes and procedures implementation
  • 5 years - Ability to develop and implement quality assurance processes and procedures including test/use cases
  • 7 years - Data Analysis
  • 5 years - Data Flow Diagramming
  • 5 years - Data Warehouse- Knowledge of data warehouse design and development
  • 5 years - Data Warehouse- Experience in requirements gathering for data warehouse
  • 3 years - Knowledge of Kimball data warehouse design principals
  • 4 years - Participate in design reviews
  • 5 years - SQL
  • 7 years - Documenting business process
  • 7 years - Requirements Analysis
  • 7 years - Requirements Gathering
  • 7 years - Develop test plans and procedures

Skills Desired – A plus to have:
  • 3 years - Ability to navigate and query a relational database (Oracle) to both develop reports
  • 3 years - Develop Design Specifications
  • Experience with Human Services business intelligence
Rate depends on experience Local candidates preferred, not mandatory Candidates authorized to work in the US are encouraged to apply. We are not sponsoring H1B candidates at this time. Companies submitting candidates should only submit direct W2 employees for this position. This includes H1B visa candidates and therefore your company must be the visa sponsor. Please submit your resume by using the "URL" below

Vacancy expired!

Subscribe Report job