Senior SQL/Data Solution Designer

About the role

Ascent, recently acquired by Acuity Analytics, is looking for an experienced SQL/Data Solution Designer with strong SQL design expertise. You will design SQL solutions and data models in the company's system (MS SQL Server, T-SQL, Azure SQL), including schema design, versioning and performance optimization, and plan and execute schema and data migrations. Experience with Databricks and Python is highly desired but can be built up on the job.

Key responsibilities

• Design SQL solutions and data models, including versioning of data models
• Develop and execute schema and data migrations
• Create solution designs for new features and drive feature refinements with requirements engineers and the Product Owner
• Create technical user stories and support the Team Lead during planning cycles
• Optimize ETL performance and complex data flows with Azure Data Factory
• Design and implement data processes such as Azure Data Factory pipelines and Databricks
• Work with cloud-based data infrastructure (Azure) and conduct technical QA

Required profile

• 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

Required skills

• Highly desirable: good knowledge of the Azure data engineering stack (Azure Data Factory, Azure Data Lake)
• Nice to have: working knowledge of DevOps, testing and optimizing complex data flows
• Nice to have (can be learned on the job): Databricks, Delta Lake, Python, PowerShell, Cosmos DB, PowerBI