Search Jobs

Return To Job Search

: Data Warehouse Analyst
: Consulting
: Massachusetts
: Boston Metro Area
: JN -072020-2288


  • Create specifications for developers by performing detailed requirements analysis
  • Review existing reports to understand their purpose
  • Analyze enhancement requests to determine scope of effort and impact
  • Extract existing report SQL from Cognos BI tool and assess performance
  • Determine best course of action for providing data for Power BI and fine tune the SQL to meet the requirement
  • Participate in technical design sessions
  • Maintain documentation on report conversion process
  • Review and test changes to verify results are correct
  • Assist with reviewing the accuracy and comprehensiveness of all converted reports

Required qualifications:

  • Ability to analyze problems and recommend practical solutions to attain desired results
  • Understanding of data warehouse concepts and needs
  • Expert/Knowledge of databases, particularly Oracle Exadata and exposure to other database technologies
  • Experience using database reporting and/or query tools, specifically IBM Cognos
  • Experience with dimensional modeling and experience implementing proper data structures for analytical reporting from an enterprise data warehouse
  • Ability to communicate ideas clearly in both technical and user-friendly language, both in writing and orally
  • Ability to prioritize and execute tasks in a high-pressure environment
  • Good knowledge of applicable data privacy practices and laws (FERPA)
  • Strong organizational skills
  • Team player who enjoys being part of a supportive team, with a willingness to learn and share knowledge among team members.
  • Demonstrated discipline, self-reliance, dependability, and good judgment.

Desired qualifications:

  • Strong capabilities in analyzing data
  • Experience gathering accurate requirements from multiple user groups
  • Knowledge of education industry technology standards, and trends particularly, Common Education Data Standards (CEDS)
  • Understanding of dimensional data modeling
  • Familiarity with Microsoft’s Power BI
  • Experiencing using Oracle Data Integrator (ODI) to analyze a loading process
  • Experience with IBM Rational Team Concert, ServiceNow and Microsoft Teams