Business Intelligence Developer

Overview

Researches, analyzes, and defines business requirements and user specifications to effectively design, build, test, document, and implement Business Intelligence solutions.

• Support Business Intelligence solution architecture, design, development, implementation, and assist with administration.
• Support operation and maintenance of Micro Strategy production and non-production technical environments.
• Support, design, build, and test Micro Strategy objects, projects, reports, dashboards, and cubes.
• Provide conceptual and technical knowledge of Micro Strategy architecture, software components, design, development, and integration of best practices to develop BI solutions.
• Support applications of advanced Micro Strategy 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 Micro Strategy 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.

• Bachelor’s degree or equivalent in Computer Science, Computer Engineering, Information Systems, or equivalent work experience.
• Must be Micro Strategy Developer certified.
• Minimum of 2 years of Business Intelligence work related experience.
• Experience in Micro Strategy Admin Suite such as Intelligence Server, Administrator, Architect, Desktop, and Web.
• Experience in creating Micro Strategy 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.)

• Develop and maintain appropriate documentation on reports, dashboards, and scorecards during the development lifecycle.
• Perform database analysis, design, and normalization.
• Apply technical skills using Micro Strategy 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 Micro Strategy 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 Micro Strategy settings for optimal performance.
• Work with Micro Strategy product suite components including I‑Server, Web Server, Mobile Server, Administration Tools, Object Manager, Distribution Services, and Transaction Services.
• Work…