Job Introduction
Landmarc are undergoing a Digital Transformation and Data is at the centre of the transformation programme. We are investing in both the data literacy of our organisation and our existing Data platform. We are looking for an experienced Data professional to play a pivotal role.
As the successful applicant, you will help manage our Business Intelligence and Analytics solutions to turn our data into knowledge to help us make the right decisions.
Main Responsibility
In this role, you should have a background in data and business analysis. You should be analytical and an excellent communicator. With the ability to interpret business requirements into technical solutions, curating a data platform which allows you, other BI developers and our Data Analysts to deliver insights in the form of reports and dashboards
Designing, developing and maintaining business intelligence solutions
Crafting and executing queries upon requests for data
Presenting information through reports and visualisations as require (and/or supporting Data Analysts in doing the same)
Translate business needs to technical specifications
Design, build and deploy BI solutions
Maintain and support the data analytics platforms
Create cubes and data marts within the data warehouse
Conduct unit testing and troubleshooting
Evaluate and improve existing BI systems
Collaborate with technical teams to integrate systems
Develop and execute database queries and conduct analyses
Create visualizations and reports for requested projects
Develop and update technical documentation
The Ideal Candidate
What you know
At least 5 years commercial experience as a data professional
Background in data warehouse design (e.g. dimensional modelling) and data mining
In-depth understanding of database management systems, online analytical processing (OLAP) and ETL (Extract, transform, load) framework
Experience with SQL Server Analysis Services (SSAS) Tabular
Familiarity with BI technologies (e.g. Microsoft Power BI)
Knowledge of SQL queries, SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS)
Proven abilities to take initiative and be innovative
Analytical mind with a problem-solving aptitude
Optimising and tuning non-performant queries/jobs
Nice to have
BSc/BA in Computer Science, Engineering or relevant field
Experience and knowledge in Cloud Data Platforms (especially Azure)
Knowledge of best practice data architectures
BIML
Use of/understanding of C# in SSIS script tasks’
Familiarity with Data Dictionary/Data Catalogue process & tools (e.g. solutions like Dataedo)
What you can do
Must be results-oriented with a proactive, flexible and positive approach to work
Will have excellent critical thinking and problem solving skills with an ability to quickly grasp technical issues
Effective communication both written and verbal. Able to bridge the gap between non-technical and technical stakeholders
Ability to elicit business requirements from stakeholders at all levels and steer/guide/influence as required
Ability to establish, maintain and develop effective working relationships. Display a willingness to work alone and as part of a team in a fast paced technical environment.
Can respond effectively to conflicting work demands, prioritise accordingly and set realistic expectations for stakeholders
Package Description
Landmarc will provide you with a competitive salary, in addition to this we also offer the following main benefits, amongst many others:
Pension
Landmarc offers all employees an opportunity to join the company stakeholder pension scheme, where the company will contribute up to 8% of the employee’s salary
Holiday
Employees are entitled to 25 days pro rata during each year of employment plus public holidays. 3 extra discretionary days are normally given in addition to annual leave allowances at Christmas
Annual leave allowance will increase in recognition of your continued service
Holiday purchase – purchase up to 10 more days holiday to use throughout the year
Other benefits
Edenred – Employee Discount scheme
Tusker – Salary sacrifice car scheme
Annual salary review, in consultation with the recognised Trade Unions
Life assurance insured for three times your annual salary, to help the loved ones that are left behind
Reimbursement of professional fees and on-going training
Family friendly policy
Sick pay
About the Company
Landmarc provides the support services that enable Armed Forces from around the world to prepare for frontline military operations across the UK Defence Training Estate (DTE). This includes maintaining and delivering safe and sustainable infrastructure, managing and operating training areas and ranges and delivering multi-million pound projects to improve vital training assets.
By joining Landmarc you will be supporting our vision to provide the best training experience we can for our Armed Forces. We are the first and only Special Purpose Vehicle to be contracted by the Ministry of Defence (MOD) as their Industry Partner on the UK Defence Training Estate and the only company that is solely dedicated to the UK DTE, delivering essential support services since 2003.