Senior Data Architect
- Palo Alto, CA, USA
Common Purpose, Uncommon Opportunity. Everyone at Visa works with one goal in mind – making sure that Visa is the best way to pay and be paid, for everyone everywhere. This is our global vision and the common purpose that unites the entire Visa team. As a global payments technology company, tech is at the heart of what we do. CyberSource, a Visa company, has been and continues to be a pioneer within the e-Commerce Payment Management world. Our VisaNet network is capable of handling over 65,000 transaction messages per second for people and businesses around the world, enabling them to use digital currency instead of cash and checks.
We are also global advocates for financial inclusion, working with partners around the world to help those who lack access to financial services join the global economy. Visa’s sponsorships, including the Olympics and FIFA™ World Cup, celebrate teamwork, diversity, and excellence throughout the world. If you have a passion to make a difference in the lives of people around the world, Visa offers an uncommon opportunity to build a strong, thriving career. Visa is fueled by our team of talented employees who continuously raise the bar on delivering the convenience and security of digital currency to people all over the world. Join our team and find out how Visa is everywhere you want to be.
The ideal candidate will excel as a Data Architect: guiding the design, implementation and evolution of a virtual data access layer between various federated data sources and BI tools. The candidate must have the ability to think both strategically and tactically, to enforce global architectural principals while tuning SQL performance at the detail level. An understanding of data warehousing, OLAP, OLTP, naming standards, data federation, governance and metadata is key to this position. The ability to work independently and learn quickly is essential. The role offers great opportunities to learn various tools and technologies used in a sophisticated data architecture within the Business Intelligence and Analytics Data Services team in Data Products Development organization.
Hands-on execution as well as leadership of the following:
Develop and implement data virtualization architecture to build a Semantic Layer that simplifies data analysis for users
Create and tune SQL for views across federated sources including Hadoop, DB2 and Oracle
Collaborate with product management / product owners on defining user experience, demos and training
Collaborate with BI report developers on design for optimal performance
Assist on data analytics projects involving data modeling and architecture
Assist on building integration with other data / metadata tools in the architecture
Assist on some database administration tasks for the data virtualization platform
Use business requirements to document clear and concise technical designs
Maintain design and naming standards
Contribute to project planning discussions, provide status updates for development progress and be a critical resource for issue resolution
- Bachelor's degree in Computer Science or related discipline
- Minimum 3 years of experience as a Data Architect in data warehousing
- Minimum 3 years of experience writing and tuning SQL
- Experience with RDBMS technologies (DB2, Oracle)
- Experience with SQL-on-Hadoop preferred (Hive, Impala)
- Familiarity with web services, APIs and related architectures
- Excellent written and oral communication skills
- Experience with BI tools like Tableau / MicroStrategy is a plus
- Experience with basic Windows and Linux administration is a plus
- Experience in Agile development methodology / Scrum is a plus
Visa will consider for employment qualified applicants with criminal histories in a manner consistent with the requirements of Article 49 of the San Francisco Police Code.All your information will be kept confidential according to EEO guidelines.