Data Architect

Job Description

Data Architect

This is Worldline

We are the innovators at the heart of the payments technology industry, shaping how the world pays and gets paid. The solutions our people build today power the growth of millions of businesses tomorrow. From your local coffee shop to unicorns and international banks. From San Francisco to Auckland. We are in every corner of the world, in every part of commerce. And just as we help our customers accelerate their business, we are committed to helping our people accelerate their careers. Together, we shape the evolution.

Technical Skills For a Data Architect/DBA

• Database Management Systems:
  
  

Oracle: Expertise in Oracle Database management, including installation, configuration, and performance tuning. Knowledge of PL/SQL for stored procedures, triggers, and complex query optimization.Amazon Redshift: Proficient in managing Redshift clusters, data warehousing concepts, query optimization, and using Redshift Spectrum for querying data in S3.

Google BigQuery: Experience with BigQuery features, including table partitioning, clustering, and using SQL for large-scale data analytics.

• Data Modeling and Design:
  
  

Proficient in data modeling techniques (ER modeling, dimensional modeling) to create efficient and scalable database architectures.Understanding of normalization and denormalization strategies for different use cases.

• ETL and Data Integration:
  
  

Experience with ETL tools (e.g., Apache NiFi, Talend, Informatica) to design and implement data pipelines for data ingestion and transformation across multiple sources and targets.Knowledge of data integration techniques and best practices for real-time and batch processing.

• SQL and Query Optimization:
  
  

Strong SQL skills for querying and manipulating data in Oracle, Redshift, and BigQuery.

Ability to perform query optimization and tuning for improved performance and resource utilization.

• Cloud Platforms:
  
  

Familiarity with cloud services and architectures, especially those related to Oracle Cloud, AWS (Amazon Web Services) for Redshift,

and Google Cloud Platform for BigQuery.

Experience with data migration strategies to move data between on-premises and cloud databases.

• Data Governance and Security:
  
  

Understanding of data governance frameworks and compliance regulations (e.g., GDPR, HIPAA).Knowledge of security best practices, including user access management, encryption, and auditing in Oracle, Redshift, and BigQuery.

• Performance Monitoring and Tuning:
  
  

Experience using monitoring tools and log analysis to track database performance and troubleshoot issues (e.g., Oracle Enterprise Manager, AWS CloudWatch for Redshift, BigQuery query execution plans). Skills in database backups, recovery strategies, and disaster recovery planning.

• Programming and Scripting:
  
  

Familiarity with programming languages such as Python or Java for automation and integration tasks. Ability to write scripts for database migrations, backups, and routine maintenance tasks.

• Data Warehousing Concepts:
  
  

Understanding of data warehousing principles, including star and snowflake schemas, data marts, and OLAP vs. OLTP designs.Knowledge of analytical tools and BI integrations related to Oracle, Redshift, and BigQuery.

• Version Control and Collaboration Tools:
  
  

Familiarity with version control systems (e.g., Git) for managing database schema changes and team collaboration. Use of documentation tools to create and maintain architecture diagrams and technical documentation.

Soft Skills

Strong analytical, problem-solving, and communication skills are essential for collaborating with stakeholders and effectively presenting technical information

Why Join Us?

At Worldline, we believe that embracing diversity and promoting inclusion drive innovation and success. We foster a workplace where everyone feels valued and empowered to bring their authentic selves. Through extensive training, mentorship, and development programs, we support your growth and help you make a meaningful impact.

Join a global team of passionate professionals shaping the future of payments technology—where your ideas, experiences, and perspectives are appreciated and celebrated.

We are an Equal Opportunity Employer.

We do not discriminate based on race, ethnicity, religion, color, national origin, sex (including pregnancy and childbirth), sexual orientation, gender identity or expression, age, disability, or any other legally protected characteristics. We are committed to creating a diverse and inclusive environment for all employees.

Learn more about life at Worldline at Jobs.worldline.com