Job Summary
Researches, analyzes, and defines business requirements and user specifications to effectively design, build, test, document, and implement Business Intelligence solutions.
Typical Duties and Responsibilities
- Support Business Intelligence solution architecture, design, development, implementation, and assist with administration.
- Support operation and maintenance of MicroStrategy production and non-production technical environments.
- Support, design, build, and test MicroStrategy objects, projects, reports, dashboards, and cubes.
- Provide conceptual and technical knowledge of MicroStrategy architecture, software components, design, development, and integration of best practices to develop BI solutions.
- Support applications of advanced MicroStrategy features such as distribution services, transaction services, mobile, etc.
- Responsible for knowledge of database normalization, managing files for data optimization, maintaining accuracy and integrity within the database, and communicating database information to developers and users.
- Work closely with DBAs on data model or database changes required to support BI projects.
- Analyze and evaluate present or proposed business procedures or problems to define data processing needs within existing or proposed systems.
- Responsible for creating ETL processes for the data warehouse.
- Responsible for building and managing data cubes and plan caches.
- Train users in working with MicroStrategy software and reporting.
- Assist with project planning, estimating, approach definition, and implementation planning.
- Develop, document, and revise system design procedures, test procedures, and quality standards.
- Evaluate current and emerging BI industry trends and best practices when designing BI solutions.
- Coordinates communication with end-users, giving presentations, writing documentation, training, troubleshooting, etc.
- Trouble-shoots problems by being on call, analyzing the system, problem solving, etc.
- Perform other duties as assigned or needed.
Requirements
Education/Experience:
- Bachelor’s degree or equivalent in Computer Science, Computer Engineering, Information Systems, or equivalent work experience.
- Must be MicroStrategy Developer certified.
- Minimum of 2 years of Business Intelligence work related experience.
- Experience in MicroStrategy Admin Suite such as Intelligence Server, Administrator, Architect, Desktop, and Web.
- Experience in creating MicroStrategy public objects such as metrics, filters, reports, dashboards, and mobile applications.
- Experience performing data profiling, modeling metadata, and developing complex integrated data sets from disparate data sources with utilization of SQL and knowledge of databases objects.
- Knowledge on data warehousing concepts, tools & techniques, SDLC.
- Knowledge of data encryption methodologies.
- Experience with cube and cache operations.
- Knowledge of Agile development methodologies.
- Knowledge with data integration and data orchestration tools and related best-practices.
- Experience with operating systems (Microsoft Windows)
- Proficiency in the use of Microsoft Office software (Word, Excel, Outlook, etc.)
Ability to:
- Develop and maintain appropriate documentation on reports, dashboards, and scorecards during the development lifecycle.
- Perform database analysis, design, and normalization.
- Apply technical skills using MicroStrategy and SQL in data collection, data analysis, and reporting to procure data from database structures to report and provide solutions to client requests.
- Ability to perform complex ad-hoc SQL queries in creating MicroStrategy reports.
- Design the dimensional model schema working with DBAs by creating schema objects such as attributes, facts, hierarchies, and understanding their relationships.
- Ability to diagnose environment related issues pertaining to SSL, ODBC connections, web, and mobile deployment configuration.
- Effectively scale and size a technical environment—including the configuration of MicroStrategy settings for optimal performance.
- Work with MicroStrategy product suite components including I-Server, Web Server, Mobile Server, Administration Tools, Object Manager, Distribution Services, and Transaction Services.
- Work collaboratively in a team environment with the ability to interact effectively with other groups in the organization.
- Work on one or more assignments simultaneously with minimal supervision.
- Serve on-call to production support rotation. Resolve escalated production support problems and act in a support role for developers needing assistance with urgent issues.
- Perform all tasks with integrity and confidentiality.
Preferred Credentials:
- Knowledge of Agile development methodologies.
- Knowledge of IT Infrastructure Library (ITIL).
The above statements are intended to describe the general nature of work performed by the employees assigned to this job. All employees must comply with Company policies and applicable laws. The responsibilities, duties and qualifications required of personnel may vary.