Senior SQL/Data Solution Designer
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.
Your 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
Your skills
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
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 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.