Job Summary
Mentors the BI development staff and completes technically difficult and complex Business Intelligence initiatives. Researches, analyzes, and defines business requirements and user specifications to effectively design, build, test, document, and implement Business Intelligence solutions. Assists BI Administrator in migration planning, upgrades, and implementations of solution system architecture.
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 BI Developers and 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.
- Set up new users in MicroStrategy and maintain existing user profiles—including the knowledge and ability to set up and maintain security roles.
- 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.
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 four (4) years of Business Intelligence work related experience.
- Experience in BI tools such as Tableau, Microsoft BI, MicroStrategy Admin Suite.
- 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.
- Experience with data integration and data orchestration tools and related best-practices.
- Knowledge of IT Infrastructure Library (ITIL).
- 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.
- 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.
- 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.
- 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.
- Provide technical assistance and cross training to other team members.
- 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.
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.