Senior Data Architect – Snowflake, Market Research

• Design and build scalable core tables that transform raw event data into reliable, well-structured datasets.
• Engineer incremental dbt models for billion-row tables using merge strategies, clustering, deduplication, microbatch processing, and idempotent reprocessing.
• Implement identity-resolution solutions that correctly handle merged identities, late-arriving data, and duplicate events.
• Design fact and dimension marts and define approved datasets for BI developers, analysts, and data scientists.
• Solve complex SQL challenges involving performance, correctness, window functions, and semi-structured data.
• Design reliable ingestion from Amazon S3 into Snowflake using Snowpipe, stages, storage integrations, COPY INTO, and schema evolution.
• Partner with software engineers to define event-driven delivery patterns, schemas, data contracts, and columnar formats such as Parquet.
• Administer Snowflake environments, including role-based access control, security policies, integrations, and warehouse configuration.
• Monitor pipeline stability, load failures, data freshness, late-arriving events, and duplicate files.
• Optimize Snowflake and dbt performance and cost through clustering, materialization strategies, warehouse sizing, query profiling, and scheduling.
• Establish data-modeling and dbt standards and review complex SQL, dbt, and Python code.
• Produce design documentation, evaluate architectural trade-offs, and coach engineers and analysts.

• 6+ years of experience in Data Engineering, Data Architecture, or Analytics Engineering.
• 3+ years of hands-on experience building production solutions with Snowflake.
• Expert-level SQL skills and ability to independently solve complex modeling, performance, and data-correctness problems.
• Advanced data-modeling experience, including dimensional modeling, fact and dimension marts, slowly changing dimensions, conformed dimensions, and semi-structured data.
• Advanced dbt experience with incremental strategies, snapshots, macros, testing, and billion-row datasets.
• Experience working with behavioral or event data, including sessionization, identity resolution, late-arriving events, and duplicates.
• Deep Snowflake expertise covering RBAC, Snowpipe, stages, storage integrations, COPY INTO, schema inference, tasks, streams, clustering, and cost management.
• Working knowledge of AWS services, including S3, IAM, SNS, and SQS.
• Experience designing event-driven data integrations and working with formats such as Parquet.
• Ability to read and review Python code.
• Proven ability to take complex data problems from diagnosis through production with minimal direction.
• Strong written and verbal English communication skills.
• Ability to explain architectural decisions and technical trade-offs to engineers and business leaders.

• 100% Remote Work: Enjoy the freedom to work from the location that helps you thrive. All it takes is a laptop and a reliable internet connection.
• Highly Competitive USD Pay: Earn an excellent, market-leading compensation in USD, that goes beyond typical market offerings.
• Paid Time Off: We value your well-being. Our paid time off policies ensure you have the chance to unwind and recharge when needed.
• Work with Autonomy: Enjoy the freedom to manage your time as long as the work gets done. Focus on results, not the clock.
• Work with Top American Companies: Grow your expertise working on innovative, high-impact projects with Industry-Leading U.S. Companies.
• A Culture That Values You: We prioritize well-being and work-life balance, offering engagement activities and fostering dynamic teams to ensure you thrive both personally and professionally.
• Diverse, Global Network: Connect with over 600 professionals in 25+ countries, expand your network, and collaborate with a multicultural team from Latin America.
• Team Up with Skilled Professionals: Join forces with senior talent. All of our team members are seasoned experts, ensuring you're working with the best in your field.