Sr. Snowflake Data Engineer

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 storage planning, virtual warehouse sizing, database setup, including data encryption/masking policies, and data integration processes using the latest technologies that Snowflake touches.

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.  As a Snowflake Data Engineer for world class advanced analytics, you will have the unique combination of business acumen needed to interface directly with key stakeholders to understand the problem along with the skills and vision to translate the need into a world-class technical solution using the latest technologies.

You will be responsible for building data engineering solutions for the enterprise using cloud-based data platform. You will provide day-to-day technical deliverables and participate in technical design, development, and support for data engineering workloads. In this role, you need to be equally skilled with the whiteboard and the keyboard using technologies such as SnowFlake, EDW, SQL, AWS, Azure, GCP, and programming languages.


This is a remote position open to any qualified applicant in the United States.  US work authorization that will require transfer of sponsorship or support for employment now or in the future 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.
  • Translate complex business logic into SQL and corresponding data models.
  • Clean & transform data, implement unit tests, and document models.
  • Develop monitoring and data observability strategies to ensure ongoing quality.
  • Build, validate, optimize, and automate key data processes.
  • Leverage SQL, programming language (Python or similar) and/or ETL Tools (such as Azure Data Factory, Data Bricks, Talend and SnowSQL) to develop data pipeline solutions to ingest and exploit new and existing data sources.
  • Understand and analyze data from multiple data sources and develop technology to integrate the enterprise data layer.
  • Create robust and automated pipelines to ingest and process structured and unstructured data from source systems into analytical platforms using batch and streaming mechanisms leveraging cloud native toolsets.
  • Process complex data sets, leveraging technologies used to process these disparate data sets, and understand the correlations between these different data sets.
  • Implement orchestrations of data pipelines.
  • Implement automation to optimize data platform compute and storage resources.
  • Develop and enhance end to end monitoring capability of cloud data platforms.
  • Understand client business needs and develop innovative solutions to address.
  • Design and implement integration processes using the latest technologies.
  • Develop and maintain data governance procedures to ensure data quality and integrity.
  • Implement Snowflake user /query log analysis and alerts.
  • Implementation experience with Snowflake functionality specific to role-based access control (RBAC), data masking, Snowpipe, Snowpark, data sharing, and governance.
  • Build and maintain data pipelines and ETL/ELT processes.
  • Implement/support automation for production deployment in Snowflake.
  • Implement data security measures.
  • 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.
  • Continually innovate, seek creative solutions, and find new ways of adding value.
  • Listen and seek to understand 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.
  • Troubleshoot critical incidents.

What are we looking for?

  • Team management experience and ability to work in a fast-paced environment.
  • Experienced in data streaming using Snowpipe (CSV, JSON, Parquet etc.)
  • Previous experience leading an enterprise-wide Cloud Data Platform migration with strong architectural and design skills.
  • Capable of discussing enterprise level services independent of technology stack.
  • Experience with Cloud based data architectures, messaging, analytics.
  • Collaborate across every part of the organization to collect data points for projects.
  • Demonstrate expertise in enterprise-level cloud data architecture, data visualization, and advanced analytic solutions.
  • Define conceptual, logical, and physical architectures for cloud-based data solutions.
  • Design End-to-end cloud data solutions including Architecture, Infrastructure, Storage, Data Model, ETL/ELT, and Consumption.
  • Lead the technical design and solution of migrating legacy data solutions to cloud-based data platforms.
  • Strong experience leading end-to-end migrations of data warehouse and big data environments to Snowflake.
  • 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
  • Experienced in SQL, as well Python, JavaScript, Java, JSON, 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.
  • 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)
  • Experienced in CI/CD pipelines.

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

  • Five (5) years of professional Technology related field experience with large data sets.
  • Three (3) years of experience with Big Data technologies and platforms such as Hadoop, Redshift, Scala, Spark, or Hive.
  • Three (3) years of experience implementing effective analytics solutions and models with Snowflake.
  • SnowPro Core or SnowPro Advanced Data Engineer 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.
  • 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.
  • The following certifications are preferred:  Google Cloud Associate Cloud Engineer, Google Cloud Professional Cloud Database Engineer, Google Cloud Professional Data Engineer, AWS Certified Data Engineer – Associate, AWS Certified Solutions Architect Associate or Azure Data Engineer Associate.
  • Master’s degree in a quantitative discipline.



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