Senior Data Engineer

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 CompanyJoin our newly introduced team as a Data Engineer, where your expertise in Microsoft Full Stack technologies will shine. We're 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 T-SQL, 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

• Bachelor's 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, T-SQL, and adeptness in database development.
• Hands-on 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 ApplyClick APPLY or contact James Higgs on 0402619858 or email jhiggs@charterhouse.com.au for 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.com.au