Sorry, this job is no longer accepting applications. See below for more jobs that match what you’re looking for!

Data Warehouse Analyst II

Expired Job

Encore Consulting Services Madison , WI 53701

Posted 4 months ago

Data Warehouse Analyst II
Madison, WI
2+ years Contract


DOT is looking for a candidate that can help provide BI ETL & Reporting needs for our DTIM Division.

The candidate will be a strong technical leader working on Data Integration, Data Warehouse, and BI Report Development projects, gathering & documenting requirements, performing analysis, designing solutions to meet business objectives, developing specifications, developing ETL mappings using Informatica PowerCenter, developing universes and reports using SAP Business Objects, testing, and implementing solutions. Understand user requirements, and implement solutions that ensure requirements can be achieved through high quality deliverables. Seek continuous improvement in performance & tuning and ensure security of data. Proven methodology experience for complex systems integration projects and demonstrated ability to achieve deliverables on time and on budget. Work with other IT technical teams and Business users to understand requirements, and recommend & implement solutions. Work with moderate supervision with some latitude for independent judgment performing a variety of complex tasks. Requires advanced skill sets and developing proficiency within discipline. Typically requires 7 - 9 years experience or equivalent education.

Ideal candidate will have experience designing BI solutions, with development experience using Informatica PowerCenter and SAP Business Objects.

DW & BI Knowledge and Skills Required for the position:
1.Data warehouse/data marts using Kimball & Inmon methodologies
2.Informatica PowerCenter V10.1
3.SAP Business Objects universe and report design/development

  • V 4.1
    4.Xcelcius Dashboard design and development
    5.Crystal Reports
    7.Oracle, DB2 and SQL Server
    8.Complex SQL development
    9.Dimensional Data Modeling

  • Star Schemas

  1. Slowly Changing Dimensions
  2. Requirements gathering and documentation
  3. Test plan development and testing execution
  4. Project development life cycle process (i.e., planning, analysis, design, coding, testing, implementation, support
  5. Excellent written and oral communications
  6. Independent worker
    Knowledge and experience using Informatica Data Validation Option (DVO) and Informatica Test Data Management (Data Masking) is a plus

Required DW & BI Knowledge areas:
Informatica PowerCenter

  • ETL (8+ years experience):

Data warehouse design

Data warehouse development

SAP Business Objects (8+ years experience):

SAP Business Objects Universe design and development

SAP Business Objects report design and development

Xcelsius dashboards

Database Knowledge (8+ years experience):



SQL Server

Complex SQL statements

Syed Ahmed Encore Consulting Services, Inc.
1701 East Woodfield Road, Suite #1030, Schaumburg, IL - 60173
Phone#: Ext: 404 Direct#: Fax:
Email: Website:
Consulting- Development-Staffing

Note: If you have received this mail in error or prefer not to receive such emails in the future, please send an email to with "REMOVE" in the subject line.

1. Data warehouse/data marts using Kimball & Inmon methodologies 2. Informatica PowerCenter V10.1 3. SAP Business Objects universe and report design/development

  • V 4.1 4. Xcelcius Dashboard desig
    2+ Years
See if you are a match!

See how well your resume matches up to this job - upload your resume now.

Find your dream job anywhere
with the LiveCareer app.
Download the
LiveCareer app and find
your dream job anywhere

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Data Warehouse Analyst II

Mars Solutions Group

Posted Today

VIEW JOBS 12/14/2018 12:00:00 AM 2019-03-14T00:00 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. <br /> <br /> • 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. <br /> • 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. <br /> • Uses extensive experience as a liaison between users and technologists to drive requirements into design. <br /> • 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. <br /> • 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. <br /> • Responsibilities with include project work enhancing existing/new processes through data sharing, configuration, report writing and metrics. <br /> • 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. <br /> • 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. <br />  <br /> <strong>Skill Matrix:</strong><br /> Change management: 3 years<br /> Demonstrated experience in the design and utilization of performance measures and reports: 3 years<br /> Ability to develop and implement quality assurance processes and procedures including test/use cases: 3 years<br /> Data analysis: 5 years<br /> Data flow diagramming: 3 years<br /> Data Warehouse - Experience in data warehouse design and development: 3 years<br /> Data Warehouse - Experience in requirements gathering for data warehouse: 3 years<br /> Knowledge of Kimball data warehouse design principals: 2 years<br /> Participate in design reviews: 2 years<br /> Documenting business processes: 5 years<br /> Requirements analysis: 5 years<br /> Requirements gathering: 5 years<br />  <br />   Mars Solutions Group Madison WI

Data Warehouse Analyst II

Expired Job

Encore Consulting Services