MARS Solution Group (formerly MARS IT) is an award-winning organization that is committed to finding the best professional talent to meet your IT & Engineering needs.

MARS Solutions Group was incorporated by a team of highly-skilled software architects with strong business acumens. The company began and grew successfully during the recessionary years of 2008-2010, a time period when many competitors were either shunning the industry or downsizing. Continue reading...

Our Difference

Home  >>  Job Seekers  >>  Our Difference


Data Warehouse Analyst II

Location: Madison, WI
Date Posted: 10-16-2018
Looking for a strong practitioner with 5 or more years of business requirements elicitation, documentation, stakeholder communication, requirements verification and testing as a primary job responsibilities. Preference will be given for candidates will experience in gathering requirements for data warehouse/business intelligence projects. 

• Responsible for leading and facilitating the communication with IT staff, business customers and other stakeholders, implementation services, and support services to assist in the development, implementation and support of business intelligence. 
• 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. 
• 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: Confers with personnel of organization unites involved to analyze current business procedures, identify issues, and learn specific business requirements, such as how data is to be summarized, and formats for reports. 
• 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 with 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. 
• Business Analyst with 5 or more years of experience, relies on experience and judgment to plan and accomplish goals, independently performs a variety of complicated tasks. 
Skill Matrix:
Change management: 3 years
Demonstrated experience in the design and utilization of performance measures and reports: 3 years
Ability to develop and implement quality assurance processes and procedures including test/use cases: 3 years
Data analysis: 5 years
Data flow diagramming: 3 years
Data Warehouse - Experience in data warehouse design and development: 3 years
Data Warehouse - Experience in requirements gathering for data warehouse: 3 years
Knowledge of Kimball data warehouse design principals: 2 years
Participate in design reviews: 2 years
Documenting business processes: 5 years
Requirements analysis: 5 years
Requirements gathering: 5 years
this job portal is powered by CATS