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.

Responsibilities

Design SQL solutions and data models in our system, including versioning of data models
Develop and execute schema and data migrations
Create solution designs for new features
Drive feature refinements in collaboration with requirement engineers and the Product Owner
Create technical user stories
Support the Team Lead during planning cycles
Optimize ETL performance and complex data flows with Azure Data Factory
Design and implement data processes (e.g. Azure Data Factory pipelines, Databricks)
Work with cloud-based data infrastructure (Azure)
Conduct technical QA

Requirements

Absolute Must-Have

Strong, proven SQL design expertise: designing schemas, data models, and database objects in MS SQL Server (T-SQL), including in legacy systems
Data modelling concepts and techniques (data warehouse and transactional)
Experience planning and executing schema and data migrations

Highly Desirable

Good knowledge of the Azure data engineering stack: Azure Data Factory, Azure Data Lake knowledge would be highly beneficial
Working knowledge of DevOps, testing, operating, and optimizing complex data flows

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

Databricks and Delta Lake
Python
PowerShell
Cosmos DB
PowerBI

We Offer

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 for more details.

Locations

Malta
Bulgaria
United Kingdom

Apply for This Position

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).

Senior SQL/Data Solution Designer

Job description