MasterCard Consultant, Software Engineering - BI Engineer in O'Fallon, Missouri

Who is MasterCard?

We are the global technology company behind the world€™s 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.

Job Title

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