SQL/bi Developer

**Fletchers Solicitors Ltd have a fantastic opportunity for an SQL/BI Developer ?to join their growing team**

**Location: Southport/Manchester/Hybrid**

?If you are looking for a new role in a growing company that offers a great work life balance, fabulous benefits, and will support you and your goals, then this could be the role for you

We are looking for someone who has the following skills:

- Proven experience as a BI Developer.
- Self-motivated with the ability to work independently.
- Customer focused approach.
- Strong problem solving and analytical skills with an attention to detail.
- Able to deal with data and present it in an understandable way to business users.
- Business Intelligence reporting & software (eg, DAX, Power BI, Tableau)
- In-depth understanding of DBMS, OLAP and ETL framework.
- Design and implementation of relational databases, dimensional modelling, and data warehousing.
- SQL Server 2008 - 2019.
- SQL Server architecture (SQL Clusters/nodes)
- T-SQL, SSRS, SSAS, SSIS, report builder and SQL Profiler.
- Deploying solutions into live environment via CI / CD build pipelines.
- SQL Server performance tuning and optimisation.
- SQL Server security rules (access, encryption, data integrity etc)
- SQL Server HA/DR (SQL 2016 AlwaysOn - failovers, Async/Sync, AG, Listeners, backups etc.)
- Version control and change management.

As an integral part of the BI team, you will be responsible for the design, development, and administration of databases & data warehousing platforms to transform data into useful insights that help critical business decisions. You will also work with stakeholdersto develop and maintain Power BI reporting solutions.

An experienced BI developer and high-performing problem solver, you will be a self-motivated team-player with excellent communication skills and a strong background in relational databases, T-SQL and in-depth understanding of SQL Server architecture.

**In return Fletchers can offer**:

- A competitive salary based on your experience.
- Pension scheme with tax-efficient salary sacrifice option.
- 35 days holiday a year including bank holidays and Christmas Closure, you also have an option to purchase up to 3 extra days’ holiday per year, until you long service award the 3 days after your 5th, 7th, and 9th full year of employment.
- Medicash, offering cash back on Dental/ Medical care.
- Life insurance.
- Enhanced company sick pay scheme.
- Flexible, agile working environment with a positive work-life balance.
- Varied calendar of funded company social events.

**Our People**:
Our people are at the heart of everything we do We take pride in the results gained for our clients and go the extra mile to get justice.?Fletchers are an employer of choice, rated a top 80 Law Firm by the Times. Our culture drives our employees to achievethe best, not only for the customers but for their own growth, development, and wellbeing.

**So much has happened in the last year at Fletchers**:

- We became Fletchers Group following several acquisitions - and have big plans for more growth.
- We offered legal colleagues more training contracts than ever before.
- Retained excellent rankings with both The Legal 500 and Chambers & Partners
- We opened 2 new office locations in Leeds and Liverpool (alongside Southport and Manchester)
- We launched our first ever Associate and Partner programmes for senior lawyers.
- We launched the Fletchers Foundation charity to support injured people.

That’s just to name a few, check out our website for more

**Main Responsibilities**:

- Assist in the effective development of data management processes and procedures.
- Development of SQL user stories to aid systems development.
- Design, build and deploy BI solutions in Power BI.
- Translate business needs into technical specifications.
- Evaluate and improve existing BI systems.
- Create tools for effective data storage.
- Development of data warehouse for BI reporting solutions.
- Conduct unit testing and troubleshooting.
- Collaborate with QA and other technology functions to integrate systems.
- Develop and execute database queries and conduct analyses.
- Present information through reports and visualization.
- Maintain technical documentation.

**Desirable Skills**:

- Azure SQL data warehouse
- Azure Data Factory
- Non-relational (NoSQL) databases (MongoDB, DocumentDB, Azure Table Storage)
- Machine Learning
- PowerShell, PHP, MySQL, HTML, CSS, JavaScript, Jquery,.Net,C#