Data Analyst

Is working with Data in the latest technologies your passion?

Our amazing client is looking for an experienced and passionate Data Analyst who is a gun in developing insightful dataset that provide our business with the data they need to drive better business outcomes. In this role, you will have the opportunity to work closely with Data Engineers to design new Datawarehouse structures, build complex queries to provide data and work closely with the data engineers to develop data pipelines to feed the Warehouse and Data Lake with data from new sources.

Your duties will include requirements gathering and documentation, database design, development of SQL scripts, testing and data analytics. You will work closely with data engineers to develop ETL pipelines into the Data Lake and the Warehouse.

Data Analyst Job Responsibilities

• Collects requirements from the business users and/or stakeholders
• Documents the Data Entities and Fields required (incl Data Types)
• Documents non-functional requirements.
• Peer reviews database and schema designs.
• Creates mappings documentation for pipelines and data requirements.
• Develops, unit tests and deploys DDL Scripts and data fixes.
• Develops adhoc queries for the Business and other teams.
• Assists Data Engineers in the development of ETL pipelines.
• Suggests improvements to the coding standards.
• Creates test cases for all the work and tickets assigned and closed.
• Ensures the tests are working and showing in the Data Quality Dashboard
• Performs rostered operational activities and system health checks.

Key Experience and Skills

• 2+ years of solid working experience in data analytics
• 2+ years experience with relational databases and / or data warehouse systems.
• Experience designing and developing new database or data warehouse tables.
• Experience developing stored procedures ideally in an MSSQL/Azure environment

Interested? Reach out to Hazel at hfaustino@welovesalt.com for a confidential chat today!

Salt is acting as an Employment Agency in relation to this vacancy.