Sr. Snowflake Data Engineer

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.

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 Snow Flake, 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.

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.

• 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…