Data Engineer

Verifi a Visa entity operates a network enabling data sharing among Acquirers, Merchants & Issuers for fraud prevention, dispute prevention and revenue recovery. Below are the key product solutions which are managed by this technology team

Intelligence Suite - Risk management platform that allows merchant to customize services to protect their business, gain greater customer insights and seamlessly keep pace with emerging fraud threats

The Verifi reporting and analytics team is responsible for all facets of architecture, software development and production support of data pipelines, ETL process, reporting and analytics system.

The reporting and analytics team support Visa's Business users in Billing, Client Services, Issuer Processing and Global Contact Center Teams in providing access to data and insights from multiple applications.

As a Data Engineer supporting reporting and analytics group, you will be responsible for designing, developing and implementing Data integration and Analytics solutions on relational databases (MS SQL Server) using Wherescape Red ETL tool to enable self-service reporting. Based on deep understanding and knowledge of ETL and data engineering techniques, you will develop and maintain data and tools to provide self-service to Business users. Your ability to work across functions and teams will allow you to drive results and foster the right culture and environment to achieve Engineering Excellence and Innovation.

Some of Your Key Responsibilities

Essential Functions:

• Support Data warehouse Engineering in the architecture, development, and employment of MS SQL Database on LUW in high SLA environments.
• Solid understanding on data model for facts and dimensions. Ability to provide logical and physical design for the given business requirements.
• Design scalable data warehouse solution using SQL Server and Hadoop.
• Engage in proof of concepts on new SQL Server features and advocate the business benefits to the leadership team.
• Provide data warehouse engineering for off the shelf and external merchant facing applications.
• Implementation of databases, storage structures, high-availability solutions, replication, encryption, and disaster recovery solutions.
• Follow the industry best practice in writing TSQL code and unit test cases.
• Proactive performance analysis, troubleshooting and resolution of database issues.
• Work very closely with the application team and DBA team to ensure delivery of database services within the SLA's and performance target set.
• Integrate the DWH code with the Redgate for the automated deployment.
• Support P1/P2 database issues which impacts the customer applications.
• Manage, support, and maintain database technology and infrastructure, adhering to the architectural guidelines and policies.
• Address vulnerabilities and TSR findings reported by the DBA team.
• Ability to work well as a team and as an individual with minimal supervision.

This is a hybrid position. Hybrid employees can alternate time between both remote and office. Employees in hybrid roles are expected to work from the office 2-3 set days a week (determined by leadership/site), with a general guidepost of being in the office 50% or more of the time based on business needs.