Job Description
Seeking Data Engineer skilled in Microsoft Stack. SQL ETL Azure. 5 yrs exp.
- Senior Data Engineer Must have 5 years advanced SQL skills
- Must be an Australian/New Zealand Citizen or Permanent Resident
- Join a newly established Data team
About the Company
Join our newly introduced team as a Data Engineer where your expertise in Microsoft Full Stack technologies will shine. Were on the lookout for someone with advanced SQL skills including crafting and optimizing complex queries managing Stored Procedures views and Indexing. Your proficiency should extend to working with ETL Tools such as Azure Data Factory Azure Synapse or SSIS.
About the Role
- Develop and maintain robust data pipelines using Microsoft SQL Server employing TSQL stored procedures functions and views.
- Implement efficient ETL processes using Azure Data Factory and Synapse to handle data extraction transformation and loading seamlessly.
- Collaborate with diverse teams to integrate data from multiple sources into centralized data repositories.
- Ensure peak database performance troubleshoot issues and uphold data integrity and security standards.
- Utilize Azure Blob Storage effectively for streamlined data storage and retrieval.
- Harness the power of Azure DevOps for version control continuous integration and deployment of data solutions.
- Create compelling data visualizations and reports using Power BI leveraging DAX and Power Query.
About You
- Bachelors degree in computer science Engineering or a related field.
- 3 years of proven experience as a Data Engineer with a strong command of Microsoft Full Stack technologies.
- Experience working with Accounting & Finance systems
- Proficiency in Microsoft SQL Server TSQL and adeptness in database development.
- Handson experience with Azure Data Factory Synapse and Blob Storage.
- Familiarity with Azure DevOps for efficient management of data projects and deployments.
- Working knowledge of Python for scripting and automation purposes.
- Experience with cloud platforms such as AWS and Azure.
- Bonus skills in Power BI DAX and Power Query for enhanced data visualization and analytics.
Benefits
- Hybrid working 2/3 days on site
- Cross functional Tech team a lot of opportunity to learn new areas
- Extensive professional development and learning opportunities
How you can Apply
ClickAPPLYor contact James Higgs onor emailfor a confidential discussion.
At Charterhouse we embrace and value diversity of culture working arrangements sexual orientation and gender identity. On behalf of our client we promote a workplace that actively seeks to include and welcome unique contributions of all people; to embrace and celebrate the value of Aboriginal and Torres Strait Islander staff their skills and contributions to the workplace.
www.charterhouse
$150k Super
Required Experience:
Senior IC