Data Architect
Data Architect
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
ThisisWorldline
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 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 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
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 technologywhere 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
#LI-NY1
Employment Type
Full-Time
