Senior SQL/Data Solution Designer

About us

Ascent has recently been acquired by [Acuity Analytics](https://www.linkedin.com/safety/go/?url=https%3A%2F%2Fwww.acuityanalytics.com%2F&urlhash=K74P&mt=M804QjXf3ie8FTF-vfqdfwbOR_h6cE9y7AIX78XYB21n1DF7cNUWFOCFQA8eliLKD00T9oEU9iGvG6CdnuuL12qzzA&isSdui=true). This is both a significant milestone for us and a tremendous opportunity for you. Acuity Analytics is a business with a strong global reputation, an impressive client base and ambitious growth plans. We deliver deep insights and domain-led digital transformation to high-growth and heavily regulated organisations. To our customers, we bring a partnership that provides the talent, technology and capability to enhance performance and operational efficiency.

About the role

We are looking for an experienced Data Engineer with strong SQL and Databricks expertise to join our team.

You will be creating solution designs for features, driving feature refinements in collaboration with requirements engineers and the Product Owner, supporting the team lead during planning cycles.

Key responsibilities

• Create technical user stories

• Design and implement data processes (e.g. ADF Pipelines, Databricks)

• Data models developing and versioning

• Work with cloud-based data infrastructures (Azure)

• Development & execution of schema + data migration

• Optimize ETL performance

• Conduct technical QA

Required experience

• Data modelling concepts and techniques (DWH, transactional)

• Databricks & Delta Lake, Python, PowerShell, MS SQL Server, T-SQL

• Good knowledge of the Azure data engineering stack - Azure Data Factory, Azure Data Lake, Cosmos DB

• Good working knowledge of DevOps, testing, operating and optimizing complex data flows

• Experience with Azure DevOps, Git, Visual Studio

Nice to have experience

• Hands-on experience with PowerBI

• Hands-on experience with Agent Bricks

Why join us

People are at the Heart of our Business. By investing in people, we achieve exceptional results for our clients and create new opportunities for our teams to thrive. Check out [this page](https://www.linkedin.com/safety/go/?url=https%3A%2F%2Fwww.acuityanalytics.com%2Fworking-here%2F&urlhash=fJGI&mt=_C0MuPPcsfORz0gpiisMXti2T6iI6cLU6B0jMy64SYBGE4w-qtCSTw1kxw18Ba1mB6GY0aatnX7P6cXRMSMXjvSkYQ&isSdui=true) for more details.

If you have any questions contact our Talent Acquisition team on ta.admin@acuityanalytics.

For more details about Acuity Analytics please see here: [Read here](https://www.acuityanalytics.com).