Senior SQL/Data Solution Designer

1. Strong, proven SQL design expertise: designing schemas, data models and database objects in MS SQL Server (T-SQL), including in legacy systems

2. Data modelling concepts and techniques (data warehouse and transactional)

3. Experience planning and executing schema and data migrations

4. Good knowledge of the Azure data engineering stack: Azure Data Factory, Azure Data Lake knowledge would be highly beneficial

5. Working knowledge of DevOps, testing, operating and optimizing complex data flows

1. Databricks and Delta Lake

2. Python

3. PowerShell

4. Cosmos DB

5. PowerBI

About Us

Ascent has recently been acquired by Acuity Analytics. 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 organizations. 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 SQL/Data Solution Designer with strong SQL design expertise to join our team.

You will design SQL solutions and data models in our system (MS SQL Server, T-SQL, Azure SQL), including schema design, versioning and performance optimization; and plan and execute schema and data migrations. You will create solution designs for features, drive feature refinements in collaboration with requirements engineers and the Product Owner, and support the Team Lead during planning cycles. Experience with Databricks and Python is highly desired, but you can also build it up on the job.

1. Design SQL solutions and data models in our system, including versioning of data models

2. Develop and execute schema and data migrations

3. Create solution designs for new features

4. Drive feature refinements in collaboration with requirement engineers and the Product Owner

5. Create technical user stories

6. Support the Team Lead during planning cycles

7. Optimize ETL performance and complex data flows with Azure Data Factory

8. Design and implement data processes (e.g. Azure Data Factory pipelines, Databricks)

9. Work with cloud-based data infrastructure (Azure)

10. Conduct technical QA

Nice-to-have (can be learned on the job)