Areas of Responsibility
- Will work with BI Analysts, Software Developers, Database Engineers, Product Management in addition to stakeholders in sales, finance, marketing and service teams to create a coherent customer view.
- Develop and improve the current data architecture using Azure Data Factory, Analysis Service, Synapse Analytics and Data Lake
- Improve upon the data ingestion models, ETL jobs, and alarming to maintain data integrity and data availability.
- Stay up-to-date with advances in data persistence and big data technologies and run pilots to design the POC
- Partner with analysts across teams such as product management, operations, sales, finance, marketing and engineering to build and verify hypothesis to improve the business performance.
- Manage weekly business reports via dashboards and paper the analyses of daily, weekly, and monthly reporting of performance via Key Performance Indicators on Power BI
Skill Requirements
- 3+ Years experience in Azure Data Factory, Analysis Services and Synapse Analytics
- 3+ Years experience in Java/Python for Spark and Kafka is advantageous
- Strong knowledge of Data types and Structured and un-structured data types
- Good understanding ETL best practices
- Good knowledge of Star schema
- Design and develop ETL to support data delivery to our internal and external clients
- Manage, monitor and benchmark our data infrastructure, scale it if necessary
- Design and develop new infrastructure if and when necessary
- Present research on best Data tools and solutions
- Help Data Analyst to develop SQL queries and tables to perform data analytics Identify the need for need data and work with developers to get this data from application
- Develop solutions to validate data
- Communicate with stakeholders from other teams to understand what data they require and how to present in the most efficient way
- English level: B2+