Data Analyst - Melbourne, Australia - Dynamo Recruitment
Description
Permanent position (long-term growth)- Established team (very supportive)
- Microsoft Cloud stack (high market demand)
Our Client, based out of the Melbourne CBD, is recruiting for a Data Analyst to join their team and work on a key account.
Joining an established Data Analytics reporting & visualisation team, this role will involve being responsible for the Data itself, which will include Data Modelling, effective data ingestion and transformation and availability.
As new business capabilities are developed, this position will be integral in creating new data feeds and sets to support delivery.
As this is a customer facing role, we are looking for someone with strong communication skills and an affable approach.
Responsibilities
- Follow documented guidelines to understand the Data platform integration and Data Storage structure.
- Maintain Data pipelines in Azure Data Factory and make changes to the data mapping in the data factory pipeline as per the changes in the data source.
- Maintain data storage structure on Data Sources such as SharePoint, Data Lake, and SQL Tables.
- Carry out data transformation using SQL stored procedures and build triggered procedures to automate data processing.
- Design SQL views as per the report requirements.
- Do data transformations on Power BI and add rowlevel security to the datasets.
- Support Automated Data Correction process; Manually run update queries on Azure SQL DB to correct data values as per data source.
- Communicate with the client to understand the reporting requirements and modify the data platform accordingly.
- Understand business requirements and develop solutions by expanding the Data Platform technologies.
- Manage security groups and configure access to the data platform for new joiners and additional team members when required.
Experience Required:
- Previous experience in Data transformation, Data Modelling, and Data Mapping.
- Previous experience with Power BI Desktop, Power BI Service, and Power BI Workspace.
- Basic understanding of
Azure Platforms:
Azure Data Factory, Data Lake, etc.
- Advanced
SQL:
SQL views, SQL stored procedures, triggers, JOINS.
Benefits:
- Permanent position with leading organisation
- Flexible work environment
- Work with Cloud (Azure)
- Microsoft stack
- Friendly, supportive team
More jobs from Dynamo Recruitment
-
Mscrm Functional Consultant
Haymarket, Australia - 5 days ago
-
Organisational Change Manager
Canberra, Australia - 4 weeks ago
-
Ap & Ar Officer
Melbourne, Australia - 4 days ago
-
Full Stack .NET Developer
Melbourne, Australia - 3 weeks ago
-
Microsoft Dynamics Crm Technical Consultant
Perth, Australia - 5 days ago
-
D365 Business Central Functional Consultant
Sydney, Australia - 4 weeks ago