Responsible for the foundation’s overall Microstrategy Business Intelligence (BI) development effort by translating vision into action and partnering with project delivery teams to develop and drive the overall development and operational maturity of our BI and Analytics environment. Collaborate with a community of data architects, ETL developers, Business Analysts, and BI developers to build a new Data Warehouse and Reporting environment. Be a hands-on developer with an execution mindset and lead core software development activities as they pertain to development of BI reports, dashboards, and visualizations. Champion efforts to ensure adoption of practical and creative development best practices on a Microstrategy platform. Regularly participate on projects to design, develop, troubleshoot and debug. Introduce repeatable patterns and approaches to our development and deployment standards across the BI ecosystem. Provide guidance, mentorship, and technical expertise to the core developers on projects. Work on multiple concurrent projects, meet business expectations, impact outcomes, while adopting Agile Development techniques.
Areas of Responsibility:
- Translate strategic project requirements into usable artifacts guiding to the development of Microstrategy Semantic Layer, Objects, and Reports.
- Review completed code, documentation and other deliverables to ensure that they meet specifications and requirements based on defined expectations.
- Collaborate across multiple teams to research, architect, engineer and configure complex data warehouse solutions to specified requirements in support of global, business critical systems
- Collaborate with Business Community, IT Business Analysts, and Solution Architects to identify BI requirements and architect creative solutions for governed, self-service, and application embedded reporting.
- Responsible for design, construction & unit testing of MicroStrategy projects, reports, and visualizations while adhering to architectural requirements of maintainability and scalability.
- Ensure best practices are being followed repeatedly in developing all layers of a business solution by developing smart auditing and code review practices.
- Maintain and enhance existing MicroStrategy projects, reports, and objects.
- Expand knowledge of the Analytics team on MicroStrategy features and be recognized as a MicroStrategy BI thought leader.
- Support end users with report creation and troubleshooting.
- Participate in user group meetings and training to improve the overall knowledge of the primary users of the tool to ensure adoption across the organization.
- Gain in-depth understanding of our transactional systems and the relationship between those environments and the data warehouse.
- Participate in weekly operations call with MicroStrategy cloud support team to ensure that MicroStrategy PaaS offering is operating efficiently.
- Regularly engage in operational issues including performance management and user provisioning
- Participate in development of end-to-end support operating model
- Lead and mentor Associate Consultants on project teams and develop and own design decisions
- Participate in design review sessions leading up to code migration into production, ensures timely bug fixes, and provides guidance to business and technology management on process and technical issues.
- Work alongside other ETL and EDW developers and architects to develop a cohesive and performant BI solutions
- Partner closely with Senior Business Analyst in understanding and translating business requirements into stories, tasks, and subtasks in support of delivering consumable value to our business partners in an Agile manner.
Educational Background:
Bachelor’s degree in Engineering, Computer Science, Math, or another related field,
Skills/Experience:
- Minimum 7+ Years of hands-on development, architecture, and analyst experience to support design of Enterprise Business Intelligence solutions utilizing Microstrategy platform.
- 7+ Years of passionate experience in developing Dashboards, Governed Reports, Embedded-Analytics, Visualizations etc.
- Excellent experience in full data warehouse implementation and knowledge of developing Microstrategy Semantic layer for highly performant reports and visualization.
- Hands on experience with modeling, development of Metrics, Attributes, Filters, Hierarchies, and other Microstrategy objects.
- Full lifecycle perspective (requirements gathering through production deployment and support) in aspects of Business Intelligence solutions using platforms such as Microstrategy and Tableau.
- Proficient with SQL, Complex SQL Tuning, Stored Procedures, and other techniques to develop highly performant Cubes and other means of assessing data quickly in a Microstrategy PaaS and SQL Server@AWS environment.
- Hands on experience architecting and developing in a Microstrategy 10.x environment. Highly experienced understanding of Business Intelligence Frameworks.
- Deep understanding of Visual Insights and Dossier desired. Experience working on other tools such as Tableau, Business Objects etc. would be nice, but not required.
- Ability to work with Senior Enterprise Architects and Data Architects to develop BI roadmap, repeatable development and deployment frameworks etc.
- Thorough business skills, including stakeholder management, preparing and delivering presentations and workshops, and collecting and challenging requirements.
- Ability to mentor junior developers and consultants on the team.
- Proficient with working in a highly Agile (SCRUM) environment.
- Ability to advice senior IT management on BI & Analytics trends
Education and Experience
- 7+ years of hands-on development of Business Intelligence solutions in a Microstrategy and Tableau environment.
Job Function:
Organization Info
Listing Stats
Post Date:
Jan 30 2018
Active Until:
Mar 3 2018
Hiring Organization:
Bill and Melinda Gates Foundation
industry:
Nonprofit