Description
You will design and develop ETL processes and business intelligence integrations for the Enterprise Data Asset program.
This role is on-site.
Responsibilities
- Develop data engineering processes leveraging cloud architecture and migrate existing pipelines.
- Design and support database and table schemas for new and existing data sources.
- Build and maintain Data Marts to support specific business requirements.
- Partner with data modelers, architects, and analysts to optimize table structures for reporting.
Required Skills
- 5+ years of experience in ETL development and data warehousing.
- Extensive experience with Azure Data Factory v2, Data Lake Store, and Data Lake Analytics.
- Proficiency with Azure Analysis Services and Azure Synapse.
- Hands-on experience with Snowflake and Azure SQL Data Warehouse.
- Strong command of Python and Linux shell scripting.
- Experience with SQL Server (SSIS, SSRS, SSAS), Oracle, and T-SQL.
- Knowledge of Kimball and Inmon data warehousing architectures.
Preferred Skills
- Understanding of Agile methodologies and processes.
- Advanced knowledge of analytical and dimensional modeling.