Location: Cincinnati, OH 45213 Type: Contract Title: Onsite DBT Data Architect, Technical Lead, Senior Data Engineer Description: Onsite DBT Data Architect, Technical Lead, Senior Data Engineer with 10+ years in DBT, Snowflake, Design, Architecture, Data Engineering for a contract, possibly to hire position. This position is hybrid onsite 3-4 days in the greater Cincinnati area. Must have expertise in: • DBT • Snowflake • Architecture and Design • Leadership, Mentoring Job Description: • Working on cloud data warehouses and data pipelines • Working heavily with dbt to transform data, building, managing, testing and maintaining data pipelines • Design and build data pipelines using Snowflake • Doing design and architecture • Data Modeling and Designing Architecture diagrams • Data engineering, building scalable, sustainable • Secure data platforms powering intelligent applications • SQL query and stored procedure development • SQL optimizing performance • Python programming • GitHub and DAG construction • CI/CD principles, DevOps practices, software testing • Work with AWS storage technologies, S3 • Work with Orchestration tools - Apache Airflow, Astronomer • Design and development of data visualizations and report using Looker, Tableau, Power BI, or custom visualization libraries What you will need: • 10+ years in DBT, Data Architecture and Design, Data Engineering, Cloud Data Warehouse • Expert level DBT • Strong Design and Architecture • Advanced / expert level Snowflake • Leadership, mentoring teams onshore and offshore Other skills: • Cloud-based data engineering, AWS • Orchestration using Apache Airflow and Astronomer • Python • Five Tran • PySpark • Looker • Advanced SQL Good to have: • Data Visualization - Tableau, Power BI • Docker