Data Platform Engineer

Coastal is seeking a Data Platform Engineer to support their growth by facilitating discovery sessions and translating client needs into technical requirements. The role involves developing data architectures, implementing data solutions, and providing leadership in a collaborative environment.

Responsibilities:

• Develop and implement data architectures that align with business needs and leverage Snowflake’s capabilities for data warehousing, data lakes, and data engineering
• Design and implement data solutions that address specific business needs, such as BI, ETL, and AI/ML
• Assist with migration of data from legacy systems to Snowflake
• Ensure data accessibility, security, and compliance with relevant regulations and industry standards
• Design and implement data pipelines for ingesting, transforming, and loading data into Snowflake from various sources
• Design and implement data models within Snowflake, considering data relationships, data types, and storage requirements
• Monitor and optimize query performance, data ingestion, and transformation processes within the Snowflake environment
• Collaborate with stakeholders, including business users, data engineers, data scientists, and other IT teams, to understand requirements and deliver solutions
• Evaluate and select appropriate tools and technologies for data integration, transformation, and analytics within the Snowflake ecosystem
• Provide technical leadership and guidance to data engineering and data analytics teams

Requirements:

• 5+ years experience in data engineering and data modeling for cloud data platforms with multiple workstreams
• Deep understanding of Snowflake Architecture & Capabilities
• Experience with dbt
• Experience with Sigma
• Passionate about Data Modernization Methods and Practices
• Broad range of experience in large-scale database and data warehousing technology, like Snowflake or Databricks, as well as ETL processes, analytics and cloud technologies, Data Engineering, Data Science
• Strong verbal and presentation abilities, capable of effectively communicating ideas to clients and prospective clients at all levels of an organization
• Understanding & ability to articulate the relationship between Data and Customer Relationship Management, aka the Customer360
• Demonstrable ability to shift clients to alternative solutions when initial solutions are not a fit, with examples to support this
• Demonstrable experience leading strategy and digital roadmap Projects in a complex business environment
• Experience with Data Warehouses, Data Lakes, Cloud Technology, Business Intelligence and CRM products
• Experience in programming languages such as Javascript, Python, and SQL or Salesforce App Development with LWCs, Apex, Flow etc
• Deep Understanding of Architecture Patterns and API management, including real-time streaming
• Dimensional Data Modeling Bronze, Silver, Gold, Kimball or Related Methods
• Must have full-time permanent US work authorization
• Bachelor's Degree preferred, or equivalent experience
• Implementation or Sales Experience in Salesforce Data Cloud
• Hands on Experience on Salesforce CRM technology like Sales Cloud, Service Cloud or any Industry Clouds
• Hands on Experience in AI/ML solutions like Einstein, Sagemaker, and Vertex. Solid Understanding of Generative AI
• Hands on Experience designing data solutions on cloud platforms like Amazon Web Services, Microsoft Azure or Google Cloud Platform
• Hands-on expertise with analytics tools like Tableau, PowerBI, Looker, etc
• Experience will be evaluated based on alignment to the core competencies for the role (e.g. extracurricular leadership roles, military experience, volunteer work, etc.)