Senior Data Engineer (ETL/Power BI/SQL)

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

The Marketing, Sales, Services Technology Systems (MSST) Team manage the Customer Relationship Manager (CRM) systems, Business process management (BPM) applications and custom applications for Sales, Services, Marketing and Product teams. The Analytics team within this team integrate data from multiple applications like CRM, Contact Center applications, Appian and build executive and operational reports as well as enable self-service reporting and insights from to empower Business to monitor and track KPIs and make data driven decisions.

 The Sr. Data Engineer (ETL/Power BI/SQL) within the Analytics Delivery team will be responsible for solution design, development and implementation of Data integration and Analytics solutions on data platforms (SQL server) and Hadoop. This position requires designing database schemas for reporting, perform data engineering activities using ETL tools like Pentaho and/or scripts to ingest data from multiple applications on the cloud and on premise, build Power BI data sets and enable self- service reporting on Power BI and Hadoop. This position requires close collaboration with Global Sales Business partners and Product owners to understand Business goals and requirements and implement Data Analytics solutions following agile methodologies. This position requires collaboration with multiple global IT teams including application teams, database teams, Infrastructure and Platform teams and respond to changing Business priorities with agility. This position provides Production support for applications, data analysis and requires investigation and resolution of issues.

Responsibilities:

• Participate in Technology project delivery activities such as gathering Business requirements, conceptual technology approach, design, development, enhance and build scalable solutions and support systems in production in a DevOps model.

• Work as a member of Sales domain scrum teams and provide solutions for complex reporting requirements.

• Work as a Subject matter expert on data from Sales and Marketing domain.

• Architect solutions and build data management systems – on premise or on cloud.

• Understand application systems, architect solution, develop the source to target mapping documents and ETL code to load data from Cloud applications (MS Dynamics) other CRM applications to databases on premise.

• Develop workflows using ETL tools like Pentaho.

• Develop database components on premise databases (SQL Server) and/or Hadoop for reporting.

• Develop Power BI data models and dashboards.

• Support QA, UAT and performance testing phases of development cycle and implement DevOps principles from development to deployment to production

• Partner with IT groups such as Engineering, Product, Cybersecurity, and Infrastructure on project delivery activities and security findings remediation.

• Own Operational support for multiple applications

• Perform POC and build prototypes based on business and technology requirements.

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 or more years of work experience with a Bachelor’s Degree or an Advanced Degree in Computer Science/ Engineering, Information Science or a related discipline with strong technical experiences (e.g. Masters, MBA, JD, MD, or PhD).
Preferred Qualifications:
• Minimum of 2-3 years’ experience with Master’s degree or 4-5 years' experience with Bachelor’s degree in Computer Science/ Engineering, Information Science or a related discipline
• Experience of at least four years in building data pipelines and utilizing data engineering techniques like ELT or ETL for building and scaling reporting and Analytical solutions
• Strong expertise in Data analysis, writing SQL scripts and hands on experience working on Relational data bases like SQl Server required
• Experience building Power BI data models and dashboards required
• Extensive experience with ingesting and transforming data using ETL tools like Pentaho, Informatica is required
• Experience using FetchXML, DAX functions, implementing Power BI security features required
• Experience using MS Dynamics Sales and Services modules nice to have
• Experience in provisioning databases and managing application servers (on premise or on cloud) nice to have
• Experience with ensuring data quality for reporting and implementing data observability metrics highly desirable
• Experience using Hadoop (Hive, Presto, Spark) highly desirable
• Experience in Python, PowerShell, job scheduling (Control M) and version control (bitbuket, GitHub), implementing CI/CD for Reporting components nice to have
• Experience with embedding dashboards in MS Dynamics, Power apps, Power Automate nice to have
• Experience working in Agile methodology owning end to end product solutions
• Experience with cloud infrastructure like Azure data lake, Synapse, Snowflake on Azure nice to have
• Good Presentation skills and communication skills presenting ideas and insights to Business is highly desired
• Experience on Sales and Marketing domain nice to have
• Demonstrated analytical rigor, strong attention to detail, team oriented, collaborative, agile and flexible style

Additional Information

Visa is an EEO Employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, disability or protected veteran status. Visa will also consider for employment qualified applicants with criminal histories in a manner consistent with EEOC guidelines and applicable local law.