What are the responsibilities and job description for the Onsite Technical Lead, Senior Data Engineer, AWS, Looker, Snowflake, DBT, Airflow, Python, SQL position at Intelliswift - An LTTS Company?
Location: Cincinnati, OH 45213
Type: Contract
JO#: 25-07989:CD
Title: Onsite Technical Lead, Senior Data Engineer, AWS, Looker, Snowflake, DBT, Airflow, Python, SQL
Description:
Technical Lead, Senior Data Engineer with 10 years in Data Engineering, ELT, Cloud Data Warehouse for a contract, possibly to hire position.
This position is hybrid onsite 3-4 days in the greater Cincinnati area.
Looking for expertise in Snowflake, DBT, Airflow, Five Tran, Python, Pyspark, Looker, SQL, AWS, and Astronomer
Job Description:
- Working on cloud data warehouses and data pipelines
- Data engineering, building scalable, sustainable
- Secure data platforms powering intelligent applications
- SQL query and stored procedure development
- Data Modeling and Designing Architecture diagrams
- Writing complex queries
- SQL optimizing performance
- Working with large datasets
- Working with snowflake and DBT
- Python programming
- GitHub and DAG construction
- Work with unstructured datasets a
- Handle Parquet, JSON, AVRO and XML file formats
- 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 Data Engineering, ELT Engineering, Cloud Data Warehouse
- Cloud-based data engineering, AWS and Snowflake
- Orchestration using Apache Airflow and Astronomer
- Python
- DBT
- Five Tran
- Python
- PySpark
- Looker
- Advanced SQL
- Leadership
Good to have:
- Data Visualization - Tableau, Power BI
- Docker
