Client Services BI & Analytics – Analyst

Company Description

Visa is a world leader in digital payments, facilitating more than 215 billion payments transactions between consumers, merchants, financial institutions and government entities across more than 200 countries and territories each year. Our mission is to connect the world through the most innovative, convenient, reliable and secure payments network, enabling individuals, businesses and economies to thrive.

When you join Visa, you join a culture of purpose and belonging – where your growth is priority, your identity is embraced, and the work you do matters. We believe that economies that include everyone everywhere, uplift everyone everywhere. Your work will have a direct impact on billions of people around the world – helping unlock financial access to enable the future of money movement.

Join Visa: A Network Working for Everyone.

Job Description

Job Summary

The Client Services BI & Analytics team strives to create an open, trusting data culture where the cost of curiosity – the number of steps, amount of time, and complexity of effort needed to use operational data to derive insights – is as low as possible.  We govern Client Services’ operational data and metrics, create easily usable dashboards and data sources, and analyze data to share insights.

We are a part of the Client Services Global Business Operations function and work with all levels of stakeholders, from executive leaders sharing insights with the C-Suite to customer-facing colleagues who rely on our assets to incorporate data to their daily responsibilities.

The Data Engineer is a specialist who makes data available from new sources, builds robust data models, creates and optimizes data enrichment pipelines, and provides engineering support to specific projects.  You will partner with our Data Visualizers and Solution Designers to ensure data needed by the business is available and accurate and to develop certified data sets.  This is a technical role that acts as a force multiplier to our Visualizers, Analysts, and other data users across Client Services.

Responsibilities

• Establish data processes and automations, based upon business and technology requirements, leveraging Visa’s supported data platforms and tools.
• Deliver small to large data engineering projects either individually or as part of a project team.
• Develop and maintain data models and schema designs for efficient data storage and retrieval.
• Design and implement data pipelines to extract, transform, and load data from various sources into the data warehouse, with a strong focus on reusability, performance, scalability and cost efficiency.
• Collaborate with cross-functional teams to understand data requirements and ensure data quality, with a focus on implementing data validation and data quality checks at various stages of the pipeline.
• Extract and manipulate large datasets using standard tools such as Hadoop (Hive), Spark, Python (pandas, NumPy), Presto, and SQL
• Monitor and optimize the performance of data pipelines and the data warehouse.
• Develop data solutions using Agile principles.
• Provide ongoing production support.
• Communicate complex concepts in a clear and effective manner.

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.

Qualifications

Basic Qualifications
• 2+ years of work experience with a Bachelor’s Degree in STEM field.

Preferred Qualifications
• 5+ years of analytics experience with a focus on data engineering
• Strong experience with SQL, python, and relational databases
• Advanced knowledge of SQL (e.g., understands subqueries, self-joining tables, stored procedures, can read an execution plan, SQL tuning, etc.)
• Knowledge of Data modelling is preferred.
• Experience in ETL / ELT Tools such as SSIS, ODI, Informatica is a plus.
• Exposure in cloud-based data warehousing and data pipeline management (AWS, GCP, Azure) is a plus.
• Strong problem-solving and analytical skills
• Effective communicator of statuses, issues, and risks
• Extremely high sense of quality standards and attention to detail
• A team player and collaborator, able to work well with a diverse group of individuals in a matrixed environment.

Additional Information

Work Hours: Varies upon the needs of the department.

Travel Requirements: This position requires travel 5-10% of the time.

Mental/Physical Requirements: This position will be performed in an office setting.  The position will require th