We are seeking an experienced Sr. Data Architect to oversee the development and utilization of data systems. You will be reporting to the Manager – Data Architect, to join our dynamic team in the Foreign Exchange payments processing industry. The ideal candidate is responsible for defining and implementing the enterprise data architecture strategy and ensuring robust data governance across the organization. This role requires a deep understanding of business processes, technology, data management, and regulatory compliance. The successful candidate will work closely with business and IT leaders to ensure that the enterprise data architecture supports business goals, and that data governance policies and standards are adhered to across the organization. Your responsibilities will include working closely with data modelers, data engineers, analysts, cross-functional teams, and other stakeholders to ensure that our data platform meets the needs of our organization and supports our data-driven initiatives. It also includes building a new data platform, integrating data from various sources, and ensuring data availability for various application and reporting needs. Additionally, the candidate should have experience working with AI/ML technologies and collaborating with data scientists to meet their data requirements.
In your role as a Sr. Data Architect, you will:
- Architect and Develop Data Architecture Solutions: Design and implement scalable and efficient data architecture solutions on enterprise data platform. Lead the end-to-end architecture, design and modeling using Snowflake, Tableau and AWS.
- Collaborate and Design Data Models: Partner with stakeholders and business units to understand data requirements and business goals. Lead the architecture and designing the data models, schemas, data mappings, data transformations and metadata that align with business needs, analytical requirements, and industry standards. Ability to analyze the legacy data models within legacy platforms involving SQL Server, Oracle and Stored Procedures. Possess strong hands-on SQL and Python skills.
- Data Integration, Governance and Security: Collaborate with internal and external teams to design, implement, and maintain data integration solutions, ensuring high data integrity, consistency, and accuracy. Ensure data security, integrity, and compliance with regulations. Oversee the integration of data from multiple sources into a unified system.
- Business Intelligence and Reporting: Develop and implement semantic models to support business intelligence and reporting needs. Design and manage data models involving dimensions, facts, metrics, and measures to ensure accurate and efficient reporting. Work closely with business analysts and BI developers to create and maintain semantic layers that facilitate self-service reporting and analytics. Ensure the semantic models align with business requirements and support key performance indicators (KPIs) and metrics.
- Implementation and Troubleshooting: Oversee the implementation of data solutions from initial concept through to production. Troubleshoot and resolve complex issues to ensure data pipeline stability and high performance. Monitor and optimize the performance of data systems and processes.
- AI and ML Capabilities: Stay updated with industry trends and advancements in AI and ML and integrate these technologies into the data architecture to enhance data processing and analytics capabilities.
- Documentation and Best Practices: Develop and maintain comprehensive documentation for data architecture, pipelines, and processes. Establish and enforce best practices for data engineering and quality assurance.
A successful candidate for this position should have:
- Bachelor's degree or equivalent in Computer Science, Engineering, or a related field with proven experience as a Data Architect or in a similar role. in architecting, designing, deploying, and managing data models on cloud-based infrastructure, preferably for data platforms.
- Minimum of 10 years of experience in enterprise data architecture, data management and data governance, or a related field.
- Strong knowledge of database design, data modeling, and ETL processes. Experience in designing and implementing data models involving dimensions, facts, metrics, and measures.
- Hands-on experience with Snowflake and SQL. Proficiency with data modeling tools such as ER/Studio, Erwin Data Modeler, Lucidchart, MySQL Workbench, and Oracle SQL Developer Data Modeler. Possess strong hands-on SQL and Python skills.
- Strong experience with data architecture principles, including data modelling, ETL/ELT processes, and data management and hands on experience with Big Data technologies.
- Familiarity with database systems such as Snowflake, SQL Server, PostgreSQL, or NoSQL databases
- Ability to translate business requirements into effective semantic models that support reporting and analytics using Tableau.
- Excellent problem-solving and analytical skills.
- Strong communication and collaboration abilities.
Nice to have Qualifications:
- Experience with regulatory compliance related to data management (e.g., GDPR, HIPAA).
- Knowledge of emerging technologies such as AI, machine learning, and data analytics.
- Certifications in cloud platforms (e.g., AWS).