What are the responsibilities and job description for the Snowflake Developer with Fivetran position at Lorven Technologies Inc.?
Job Title : Snowflake Developer with Fivetran
Location : Minneapolis, MN | Onsite | Hybrid
Duration : Long Term contract
Primary Skills: Data Build Tool , Snowflake, Advanced Data Modelling experts, Fivetran
Job Description:
- Conceptual and Analytical Modeling: Design, test, and maintain both conceptual and analytical data models, including logical, physical, and dimensional (star/snowflake) schemas, to support business analytics and reporting, optimize performance through partitioning and indexing, and ensure quality and consistency via SQL best practices and peer code reviews.
- Data Pipeline Orchestration and Development: Design, build, and optimize scalable, maintainable, and resilient end-to-end ETL/ELT data pipelines. Leverage orchestration tools for scheduling, dependency management, and error handling, while extracting and transforming data from source systems. Utilize platforms like dbt to ensure robust data flow, conduct UAT, and manage code releases for reliable system performance. Mastery of SQL skills
- DevOps & Code Management: Skilled in version control systems for collaborative development and code management (i.e Azure DevOps, GitHub) • Monitoring & Observability: Implementing logging, metrics, and alerting for data pipelines
- Strong Communication and Collaboration Skills: Collaborate with analysts, analytics and data engineers, and solution architects to align data solutions with strategic goals. Communicate effectively across technical and non-technical teams.
- Agile Mindset: Actively participate in agile ceremonies and contribute to sprint goals. Apply agile principles to respond to change, iterate quickly, and continuously improve team processes and product outcomes