Data Engineer DBT SQL, Snowflake and Python 100% Remote 12+ Month Contract

We have a 12 month contract with opportunity for extension or conversion for a Senior Database Engineer with experience in DBT and SQL, with Snowflake and Python experience as a highly preferred. Must Haves: • DBT (Data Build Tool) absolute must • directory structure and rule hierarchy • yaml • macros • pre/post run hooks • tests • core generic • singular • custom generic • unit tests • SQL experience (plus if it’s with Snowflake) • Python Experience (enough to decipher code) • Knowledge of Database Architecture Concepts (relational DBs, keys) • Git/Github Proficiency (CI/CD workflow knowledge is a plus) Responsibilities/JD: • Design and implement Snowflake databases and schemas through DBT models • Logically organize models within the DBT directory hierarchy to optimize rule enforcement. • Document all data models and transformations by maintaining metadata in yaml files. • Implement data quality monitoring and alerting aligned with financial reconciliation needs through Core generic, custom generic, package generic, and singular data tests in DBT. • Configure robust logging utilizing macros and pre/post-run hooks. • Collaborate with SMEs to profile source systems and define data models, keys, and relationships. • Decipher Python utilities for data transformations, identifying inefficiencies in current pipelines and designing improved pipelines in DBT. • Design Airflow DAGs for ingestion of new files (optional). • Collaborate with the data platform teams to address any issues which arise during development.