The Role: The Business Intelligence Engineer is part of a team responsible for the architecture, development and maintenance of a companywide Business Intelligence System that provides business insight through enterprise reporting to decision-makers at all organization levels and functions by delivering accurate, timely and actionable information. One of the main responsibilities of this position is to apply data warehousing principles and business analysis skills in the translation of business requirements into data transformation workflows. The position reports to the Manager of Business Intelligence. 

Your Focus:  

• Communicate with system users worldwide from key business groups, including Finance, Sales, Tech Support, Human Resources, Consulting, Education and Marketing to gather project requirements and business insight, perform feasibility analysis and manage expectations.  Engineers are responsible for communicating with project sponsors and stakeholders during the entire life cycle of a reporting project. A key measure of success in this position will be to timely and accurately meet project milestones and deliverables as agreed upon 

• Design, develop and maintain advanced ETL jobs and routines to process data from multiple sources into a centralized dimensional data warehouse 

• Manage the deployment and administration of the MicroStrategy Business Intelligence platform in support of Enterprise Reporting functions 

• Prepare data extraction queries against different data source systems (relational, bigdata, REST APIs)  

• Provide detailed documentation of enterprise reporting project 

• Define and implement data security as appropriate 

• Apply Quality Assurance methods to ensure that information provided to business users is accurate and actionable 

• Contribute to periodic projects related to the maintenance of reporting system components outside of regular business hours 

Job Requirements: 

• Minimum bachelor’s degree, preferably in Computer Science, Information Systems, or a related field 

• Experience with data extraction and transformation via scripting languages (e.g. Python) 

• Experience with MicroStrategy or other Business Intelligence applications 

• Experience with Informatica PowerCenter or Cloud 

• Proven knowledge of data warehousing principles 

• Exceptional analytical and problem solving skills 

• Strong aspiration to learn new technologies 

• Proven ability to interpret business requirements 

• Attention to detail (please include keyword “lemon” in your application) 

• Proactive and Creative 

• Ability to multi task in a dynamic environment 

• Knowledge of data/dimension modeling is a plus