
Senior Business Intelligence Developer
- Boise, ID
- Permanent
- Full-time
- 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.
- 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 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.
- 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.)
- 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.