Data Analyst/Sr ETL

Responsibilities:
Decompose requirements into Epics and Features and create clear and concise user stories to implement by technical staff
Assist Product Owner in maintaining the product backlog
Create conceptual prototypes and mock-ups
Project Managers/Scrum Masters are informed of the progress
Designs and develops systems for the maintenance of the Data Asset Program(Data Hub), ETL processes, ETL processes for spatial data, and business intelligence.
Design and supports the DW database and table schemas for new and existent data sources for the data hub and warehouse. Design and development of Data Marts.
Qualifications
5+ years of experience as an Agile Business Analyst; strong understanding of Scrum concepts and methodology
Experience organizing and maintaining Product and Sprint backlogs
Exceptional experience writing complex sql queries for Sql Server and Oracle
Experience with Azure Databricks
Experience with ESRI ArcGIS
Experience with reporting systems operational data stores, data warehouses, data lakes, data marts
Strong knowledge of database architectures
PowerPoint, MS Excel, MS Project, MS Visio, and MS Team Foundation Server, which will all be necessary in the creation of visually and verbally engaging ETL, data designs and tables as well as the communication of documentation and reporting. Deep passion for data analytics technologies as well as analytical and dimensional modeling. The candidate must be extensively familiar with ETL data warehousing and business intelligence tools such as business objects PowerBI and Tableau
Knowledge of database design and modeling in the context of data warehousing.
Experience with key data warehousing architectures includes Kimball and Inmon, and has a broad designing solutions using a broad set of data stores (HDFS, Azure Data Lake Store Azure Blob Storage Azure SQL Data Warehouse Azure Cosmos DB
Technologies:
·Data Factory v2, Data Lake Store, Data Lake Analytics, Azure Analysis Services, AZURE Synapse
·IBM Datastage, Erwin, SQL Server (SSIS, SSRS, SSAS), ORACLE, T-SQL, Azure SQL Database, Azure SQL Datawarehouse.
·Scripting experience with Windows and/or Python, Linux Shell scripting