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