Previous Job
Previous
MSTR Architect
Ref No.: 18-27292
Location: Richmond, Virginia
Start Date: 04/19/2018
 JD:
  • Evaluates functional and technical business requirements; transforms those requirements into MicroStrategy solutions that efficiently enable expected application, reporting and analytic capabilities to support strategic initiatives.
  • Analyzes documents and promotes standards and patterns that represent the established reporting, analysis and deep analytics architectural goals.
  • Provides thought leadership and hands-on involvement in the design, development, implementation and maintenance of MicroStrategy design artifacts.
  • Develops extensible/sustainable reporting solutions based on defined business needs.
  • Designs and constructs dimensional, logical, and physical models in collaboration with Data Architect and Data Engineers; provides MicroStrategy expertise for the development of drilling, aggregation and partitioning strategies.
  • Designs ETL/ELT solutions in collaboration with Data Engineers.
  • Creates, modifies and optimizes advanced SQL code including, but not limited to, subqueries, CTEs and temporary tables.
  • Mentors MicroStrategy developers, including but not limited to, the functionality and best practices for dashboard and report development.
  • Optimizes existing MicroStrategy infrastructure with a focus on usability, performance, long-term, flexibility and standardization.
  • Conducts validation of existing reporting and new solutions to ensure continuous accuracy and front end ease-of-use.
Analyzes short term reporting requirements