Remote DBT Data Engineer - Very Strong SQL

10 hours ago

Apply Now

Receive Emails with Similar Jobs

Jupiter Pharma Consulting Inc.

WebsiteLinkedInAll Job Openings

1 - 10

Description

• Architect, Design, document & implement the data pipelines to feed data models for subsequent consumption in Snowflake using dbt, airflow. • Ensure correctness and completeness of the data being transformed via engineering pipelines for end consumption in Analytical Dashboards. • Actively monitor and triage technical challenges in critical situations that require immediate resolution. • Evaluate viable technical solutions and share MVPs or PoCs in support of the research. • Develop relationships with external stakeholders to maintain awareness of data and security issues and trends. • Review work from other tech team members and provide feedback for growth. • Implement Data Performance, Data security policies that align with governance objectives and regulatory requirements.

Requirements

• Experience in data warehousing, data modelling, and the building of data engineering pipelines. • Well versed in data engineering methods, such as ETL and ELT techniques through scripting and/or tooling. • Strong analytical skills related to working with unstructured datasets. • Collaborating with product owners to identify requirements, define desired outcomes and deliver trusted results. • Building processes supporting data transformation, data structures, metadata, dependency and workload management. • SQL is heavily focused; must have hands-on experience with SQL database design and Python. • Demonstrably deep understanding of SQL (level: advanced) and analytical data warehouses (Snowflake preferred). • Demonstrated ability to write new code well-documented and stored in a version control system (we use GitHub & Bitbucket). • Extremely talented in applying SCD, CDC and DQ/DV framework. • Familiar with JIRA & Confluence. • Must have exposure to technologies such as dbt, Apache airflow and Snowflake. • Desire to continually keep up with advancements in data engineering practices. • Knowledge on AWS cloud, Python is a plus.