Data Platform Engineer

Coastal is looking for a Data Platform Engineer to support their continued growth. The role involves facilitating discovery sessions to understand client processes and translating findings into technical requirements while providing leadership and communication to project and client teams.

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.)