As a Data Engineer supporting the Reporting and Analytics group, you will be responsible for architecting and implementing data integration and analytics solutions using MS SQL Server and Wherescape Red ETL tools. You will play a vital role in ensuring the accuracy, reliability, and efficiency of our data engineering processes. Your work will empower business users with self-service reporting capabilities and enable strategic decision-making.
This position requires a deep understanding of ETL processes, data modeling, and data engineering best practices. Your ability to collaborate across teams and drive technical innovation will be critical in achieving engineering excellence.
Key Responsibilities
- Data Warehouse Engineering. Design and implement scalable MS SQL Server databases in high-SLA environments.
- Data Modeling. Develop logical and physical data models for fact and dimension tables based on business requirements.
- ETL Development. Design and optimize ETL pipelines using WhereScape Red or equivalent tools to enable efficient data integration.
- Big Data Integration. Implement data warehousing solutions that integrate with Hadoop, Spark, and NoSQL databases.
- Database Performance Optimization. Conduct proactive performance analysis, troubleshooting, and fine-tuning of SQL queries and stored procedures.
- Automation & CI/CD. Integrate DWH code with Redgate for automated deployment and version control.
- Disaster Recovery & Security. Implement database replication, high-availability solutions, encryption, and disaster recovery strategies.
- Collaboration. Work closely with application teams and DBAs to ensure efficient database operations and meet performance targets.
- Incident Management. Provide L1/L2 support for critical database issues that impact customer applications.
- Compliance & Risk Management. Address security vulnerabilities and audit findings reported by the DBA team to ensure compliance with Visa's security policies.
Required Qualifications
- Bachelor’s Degree in Computer Science, Information Technology, or related field (or equivalent work experience).
- 2+ years of hands-on experience in data engineering, data modeling, and ETL development.
- Strong expertise in SQL Server (2017/2019), MySQL 8.0, and NoSQL databases.
- Experience in writing complex SQL queries, stored procedures, and performance tuning.
- Proficiency in Python, Java, or Scala for data processing and scripting.
- Hands-on experience with Hadoop, Hive, Spark, MongoDB, and Big Data technologies.
- Familiarity with CI/CD tools such as Jenkins, Git, and Artifactory.
- Experience in automating database deployments and managing database version control.
- Strong analytical and problem-solving skills with a detail-oriented mindset.
- Ability to work independently and collaboratively in a fast-paced, agile environment.
Preferred Qualifications
- Experience in WhereScape RED or similar ETL tools.
- Knowledge of machine learning (ML) and Gen AI-based analytics solutions.
- Hands-on experience in cloud technologies such as AWS, Azure, or Google Cloud.
- Expertise in data validation, data analysis, and business intelligence tools.
- Strong leadership skills with the ability to influence cross-functional teams and senior stakeholders.
Why Join Visa?
- Innovative Work Culture. Collaborate with some of the brightest minds in the payments and technology industry.
- Career Growth & Development. Get access to continuous learning opportunities and professional development programs.
- Diversity & Inclusion. Work in an environment that values and celebrates diversity.
- Comprehensive Benefits. Competitive compensation, health benefits, wellness programs, and more.
Visa is an equal opportunity employer, committed to providing equal employment opportunities to all applicants. We welcome candidates from diverse backgrounds and ensure that employment decisions are made without discrimination based on race, gender, religion, or other protected statuses.
If you are passionate about data engineering and want to work in a cutting-edge, high-impact role, apply today and become part of Visa’s mission to shape the future of payments!