Sr. Snowflake Architect

About the job

You will work with our clients to understand their business needs and develop innovative analytics and AI solutions. You will be responsible for designing and implementing data architectures, data models, and data integration processes using the latest technologies that Snowflake touches, as your clients will need a flexible data architecture that quickly turns data of various types into informative, meaningful intelligence.

Artificial intelligence (AI) is at the precipice of being the core of all intelligent, human-centric business decisions. By decoding the signals through the noise of customer needs and preferences, people can understand exactly what services, products, and experiences their consumers need. Within our Cloud Data Platform practice, we work to design the future of work – a future in which ad hoc, hit or miss business decisions are replaced by informed choices, supported by ever more effective business models.  RMDA takes insights that are buried in data and provides businesses a clear way to transform how organizations consume not only their information, but also secure data clean room information that other entities have agreed to share.  Our mission is to assist leading companies in scaling their AI and analytics initiatives in a manner to which they may not be accustomed.

The position:

This role will serve on project teams with RM Dayton Analytics clients to design and deliver cloud-based data and analytics platforms with Snowflake at the core. This role will also provide technical subject matter expertise for RM Dayton Analytics sales and account teams during the scoping of new cloud data platform opportunities.

This is a remote position with ability to travel to client sites as needed open to any qualified applicant in the United States.  US work authorization that requires transfer of sponsorship or support for employment is not available for this position.

Practice – Cloud Data Platform

What will I be doing?

You will be responsible for designing and delivering enterprise-wide solutions. You will be supporting cloud platforms. This position works with enterprise architects, data architects, and solution architects to design and implement data solutions to meet business priorities in keeping with technology strategy, standards, and the best course of action.

Key responsibilities to include:

  • Take creative decisions and create business plans and policies.
  • Streamline operations and implement new ideas in Snowflake.
  • Lead the design and delivery of data platform modernization with clients in various stages of cloud-data maturity.
  • Develop solution architectures, data migration and integration plans within a Snowflake-based environment.
  • Understand client business needs and develop innovative solutions to address those needs.
  • Design and implement data architectures, data models, and integration processes using the latest technologies.
  • Develop and maintain data governance policies and procedures to ensure data quality and integrity.
  • Advise clients on Snowflake architecture best practices and leverage the strengths of the platform to meet the specific requirements and use cases around architecture, standards, and governance.
  • Build and maintain data pipelines and ETL/ELT processes.
  • Implement data security measures to protect the confidentiality, integrity, and availability of client data.
  • Stay up to date with the latest data technologies and trends and provide recommendations for their adoption.
  • Make creative decisions for the company and its customers.
  • Participate in pre-sales activities, including scoping and estimation of projects, and presenting solutions to clients.
  • Produce high quality deliverables, meet project deadlines, and take responsibility for engagement success.
  • Continually innovate, seek creative solutions, and find new ways of adding value.
  • Listen and seek to understand the client and meet their needs, providing consultative guidance.
  • Proactively provide solutions and approach adversity with a solution-focused mindset and future opportunities.
  • Develop Proof-of-Concept projects to validate new architectures and solutions.
  • Mentor and provide architectural guidance to multiple teams building innovative applications.


What are we looking for?

  • Team management experience and ability to work in a fast-paced environment.
  • Adept at leveraging Azure and/or AWS-native services which complement Snowflake in a Modern Data Platform setting (i.e., services related to data ingress, storage, engineering, and analytics).
  • Strong experience working with semi-structured data, such as JSON, PARQUET and XML.
  • Strong experience working with Snowpipe.
  • Strong experience leading end-to-end migrations of data warehouse and big data environments to Snowflake.
  • Implementation experience with Snowflake functionality specific to role-based access control (RBAC), data masking, Snowpipe, Snowpark, data sharing, and governance.
  • Knowledge of relational and multidimensional data design including star schema, snowflake schema, cube design, ETL, and ELT.
  • Demonstrated expertise in Snowflake data modelling and ELT using Snowflake SQL, implementing complex stored procedures.
  • Deployed fully operational data cloud platform solutions into production on Snowflake.
  • A solid understanding of delivery methodology and lead teams in the implementation of the solution according to the design/architecture
  • Strong ability to perform project management activities including project documentation, business requirements and project tracking.
  • Experienced in SQL, as well Python, JavaScript, or Scala.
  • Experienced with working with teams in an Agile delivery framework.
  • Strong analytical skills and the aptitude to quickly identify gaps and risks.
  • Excellent written and spoken communication skills.
  • Ability to help stakeholders navigate the trade-offs and alternatives to various solution architectures.
  • Expert-level understanding of enterprise data and analytics concepts like relational-data modelling, data integration, business intelligence and data-platform modernization (i.e., migrating from legacy technology environments to cloud-based platforms)
  • Familiar with DataOps concepts and tooling for source control and CI/CD pipelines.

To fulfill this role successfully, you should demonstrate the following minimum qualifications:

  • Seven (7) years of professional Technology related field experience.
  • Five (5) years of experience with Big Data technologies and platforms such as Hadoop, Redshift, Scala, Spark, or Hive.
  • Five (5) years of experience implementing effective analytics solutions and models with Snowflake.
  • SnowPro Core Certification or SnoPro Advanced Architect Certification.
  • Snowflake Sales Pro Accreditation and Snowflake Tech Sales Pro Accreditation or the ability to obtain when requested upon hire is required.

It would be useful in this position for you to demonstrate the following capabilities and distinctions:

  • Bachelor’s degree required, preferably in Computer Information Systems, Computer Science, or related fields.
  • Nine (9) + years of professional Technology related field experience.
  • Seven (7) + years of experience with Big Data technologies and platforms such as Hadoop, Redshift, Scala, Spark, or Hive.
  • Seven (7) + years of experience implementing effective analytics solutions and models with Snowflake.
  • Google Cloud Professional Cloud Architect, AWS Certified Solutions Architect Associate, AWS Certified Solutions Architect – Professional or Azure Solutions Architect Expert certification is preferred.
  • Master’s degree in a quantitative discipline is preferred.



About RM Dayton Analytics

A little bit about us…

Founded in 2014, RM Dayton Analytics is a professional services company. We transform clients’ business, operating and technology models for the digital era.  As a Snowflake and Google Cloud Partners, our mission is to help enterprises accelerate innovation by harnessing the power of the Cloud Data Platform. Our associates provide superior domain and technology expertise to drive business outcomes in a converging world.  Our consultative approach helps our customers build more innovative and efficient businesses.

RM Dayton Analytics is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to sex, gender identity, sexual orientation, race, color, religion, national origin, disability, protected Veteran status, age, or any other characteristic protected by law.


Job Category: Cloud Data Platform
Job Location: United States

Apply for this position

Allowed Type(s): .pdf, .doc, .docx