MasterCard Consultant, Software Engineering - BI Engineer in O'Fallon, Missouri
Who is MasterCard?
We are the global technology company behind the worlds fastest payments processing network. We are a vehicle for commerce, a connection to financial systems for the previously excluded, a technology innovation lab, and the home of Priceless ®. We ensure every employee has the opportunity to be a part of something bigger and to change lives. We believe as our company grows, so should you. We believe in connecting everyone to endless, priceless possibilities.
Consultant, Software Engineering - BI Engineer
The Data Warehouse has Microsoft Business Intelligence Toolset in support of our business intelligence strategy. This represents the complete stack of capabilities including: SQL Server 2012, Analysis Services, Integration Services, Reporting Services, Sharepoint 2013, Excel Services and PowerPivot services.
The responsibilities of this position will include, but are not limited to the identification and creation of tabular and/or multi-dimensional models in support of business initiatives. Creating ETL processes to populate and sustain the data models. Define and collaborate standards of governance surrounding the business intelligence solutions. Assist with roadmap of analysis and integration services to sustain a scalable environment and provide liaison and support to the technology and business organizations supporting and/or utilizing the business intelligence infrastructure. The Data warehouse currently maintains data stores in Oracle, Netezza, SQL-Server and Hadoop repositories.
All About You
Experience supporting Business Intelligence solutions. Microsoft BI engineer with demonstrating experience working with business and technical teams to determine data approaches required to support business solutions.
ïMicrosoft SQL Server Analysis services Tabular modeling
ïSQL Server Integration Services package creation and data integration with SQL Server
ïAbility to manage multiple projects
ïDemonstrated experience working with data security and fine grained user access of data repositories
ïAbility to effectively communicate with both technical and business teams
ïExperience working with large data repositories
ïCreation/maintenance of source data stores
ïMicrosoft SQL Server Analysis Services Multi-dimensional cubes
ïDemonstrated ability to trouble-shoot and support business intelligence applications
ïThe following experience would be a plus: Data Modeling , Microsoft DAX and MDX, Oracle and Netezza data repositories, Cloudera Hadoop, SQL Server Reporting Services, and/or Financial Services industry experience
Exposure to Tableau and Data Visualization
Equal Opportunity Employer
Requisition ID: R-42283