Data Warehouse Analysts
Salary undisclosed
Apply on
Original
Simplified
Job Description
The main areas of focus for the Data Warehouse Analysts will be requirement gathering, analysis, specification design, Azure data pipeline and schema development in the Enterprise Analytic Platform to support implementation of reporting solutions.
Deliverables
Standard software development deliverables and supporting documentation will be expected. These include, but are not limited to, the following:
- End-to-end data pipeline in ADF.
- Data models in ADF.Data migration to ADF.
- Power BI Reports.Design Specification Documents
- Use Cases.
- Current state analysis and as-is data maps
- Future state analysis and to-be data maps.
- Data flow architecture documents.
- Risk Analysis.
- Assistance with Standard Operating Procedures (for future state).
- Assistance with User Acceptance Test (UAT) documents.
- Other documents produced through the related project activities listed above.
Required Skills/Experience
- Minimum of ten (10) years experience with Business Intelligence (or related).
- Hands-on experience with a range of Azure Services, including ADF, Azure Databricks, Delta Lake, Azure Data Lake Storage, Azure Synapse, Power BI Reports, Crystal Reports.
- Hands-on experience with authoring Power BI reports, exposure to Power BI Cloud.
- Experience designing, building, and maintaining ETL/ELT data pipelines, (preferably Azure Data Factory).
- Demonstrated ability to interact professionally with a diverse group of executives, managers, supervisors, subject matter experts and end users.
- Skilled at facilitating and managing consultation processes with a wide range of stakeholder groups.
- Hands-on experience with Spark (PySpark/Python) in Azure.
- Experience with data migration from on-prem to cloud (preferably Azure Data Factory).
- Strong knowledge and experience designing Data Lakes and Data Warehouses.
- Strong knowledge of Azure data ecosystem for compute and storage.
- Hands on experience with developing BI reports with Power BI.
Desired Skills/Experience
- Hands-on knowledge of Azure SQL Data Warehouse architecture and best practices.
- Extensive knowledge of Dimensional Modelling and Kimball EDW principles Understanding of AzureManaged Instance.
- Experience working with Data Lakes and Data Marts.
- Ability to work with large volumes of data from multiple sources.
- Microsoft SQL Server SSIS/SSRS/ETL.
- Experience in Azure IaaS, PaaS and Database migration.
- Experience working with external vendors.
- Experience working in a unionized environment.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
Report this job