Senior ETL Engineer

Company Description

MicroStrategy transforms organizations into intelligent enterprises through data-driven innovation. We match smart people to dynamic projects and technologies that truly challenge their talents. Curious and creative in outlook, our success is built on the talent and energy of smart and driven people. MicroStrategy (Nasdaq: MSTR) is a worldwide leader in enterprise analytics and mobility software. A pioneer in the BI and analytics space, MicroStrategy delivers innovative software that empowers people to make better decisions and transform the way they do business. We provide our enterprise customers with world-class software and expert services so they can deploy unique intelligence applications.

Job Description

The Senior ETL 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 ETL experience and data warehousing principles to ensure complete, reliable, and secure data delivery to business stakeholders. The position reports to the Director of Business Intelligence. 

Job Duties (include but not limited to): 

• Design and develop advanced ETL jobs and routines to process data from multiple sources into a centralized warehouse 
• Administer, maintain, and performance-tune Informatica PowerCenter and Informatica Cloud workflows. 
• 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 all key items 
• Prepare ad-hoc queries against different data source systems 
• Provide detailed documentation of enterprise reporting projects 
• Define, implement and administer 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 
• Prepare Dashboards and Reports for business users.  

Job Requirements: 

• Minimum bachelor’s degree, preferably in Computer Science, Information Systems, or a related field 
• 3+ years Experience with Informatica PowerCenter and Informatica Cloud 
• SQL programming knowledge in MS SQL Server 
• Exceptional analytical and problem-solving skills 
• Experience with MicroStrategy or other Business Intelligence applications is a plus 
• Python language skills is a plus 
• Knowledge of data warehousing principles is a plus 
• Strong aspiration to learn new technologies 
• Strong written and verbal communication 
• Proactive and Creative 
• Ability to multitask in a dynamic environment 
• Ability to work in a distributed team environment 
• Willing to work 9am – 6pm ET (US Hours)