Senior Data Architect – North America

This is a fully remote position, open to applicants in Florida.

📋 Description

• Evaluate and refine the architecture of the Snowflake data platform.

• Establish the target architecture encompassing raw, staging, and mart layers.

• Set standards for naming conventions and data granularity.

• Develop strategies for data corrections and handling late-arriving data.

• Model general ledger activities, charts of accounts, and account hierarchies for financial statements and management reporting.

• Collaborate with finance, investment, and operations stakeholders to convert business requirements into scalable data designs.

• Define ingestion, transformation, and orchestration patterns across more than 40 data sources.

• Address issues related to data lineage, data quality, and testing procedures.

• Guide the sizing of Snowflake warehouses, enhance query performance, and manage costs effectively.

• Conduct design reviews and create design documentation, including diagrams, decisions, and trade-offs.

• Mentor data engineers and establish technical standards.

• Influence data governance, data cataloging, and AI-driven use cases.

• Participate in interviews and complete a take-home work trial as part of the selection process.

⛳️ Requirements

• Over 7 years of experience in data engineering, data architecture, or database engineering, with responsibility for production data platforms.

• Extensive hands-on experience with a cloud data warehouse; Snowflake preferred, but Databricks or similar platforms are also acceptable.

• Proven track record in performance tuning and cost management.

• Strong data modeling capabilities, including grain definition, dimensional modeling, layered architectures, and handling corrections and late-arriving data.

• Proficient in advanced SQL and efficient schema design for high-volume data environments.

• Experience in designing ETL/ELT pipelines and integrations across multiple data sources.

• Familiarity with dbt or comparable transformation frameworks.

• Experience with orchestration tools like Airflow, Dagster, or similar.

• Background in modeling general ledger data, charts of accounts, and account hierarchies for financial or management reporting purposes.

• Ability to analyze and enhance platforms that were not originally developed by the candidate.

• Experience with testing, ensuring data quality, lineage tracking, and producing clear design documentation.

• Strong communication skills in English.

• Comfort with remote, asynchronous work across different time zones.

• Practical experience utilizing AI tools for design, development, and documentation purposes.

• Capacity to navigate ambiguity, adapt to shifting priorities, self-manage effectively, and embrace continuous feedback.

🏝️ Benefits

• Engage with meaningful products that have a measurable impact.

• Opportunities for professional development, exploring new avenues, and taking on greater responsibilities.

• A self-managed, distributed work environment.

• Flexible asynchronous work arrangements across various time zones.

• Commitment to avoiding burnout or crunch periods; focus on sustainable high-quality work.

• A profitable, independent company with over 20 years of stability.

• A diverse range of projects and new challenges to tackle.

• A talented, friendly, and collaborative team culture.

• Remote work options available.