BI Database Developer

ROLE TITLE:  
BI Database Developer

VISION:
We strive to make great learning easy

MISSION:
By responding to our customers’ needs we provide outstanding educational tools that have a positive impact on teaching and learning

PURPOSE:
The BI Database Developer will be responsible for BI and SQL Development and Administration.

The BI Database Developer will manage the SQL Server and Cognos and Power BI reporting platforms.

They will help Folens to collect data and to use the data collected to understand trends, solve business problems and monitor performance.

The BI Database Developer will be responsible for managing expectations of key internal stakeholders, to deliver results in line with Folens goals. 

REPORTS TO
Head of Information Systems & Technology

ESSENTIAL DUTIES AND RESPONSIBILITIES:

SQL Dev / Admin (50%)
Install and patch SQL Server software, and maintain databases
Manage all SQL Server environments
Develop and maintain scripts, views, stored procedures, functions and triggers
Provide Ad-hoc database requests to support the business and IT Team
Perform Data Extraction & Transformation tasks. 
Database Performance and Security
Provide support to other technical colleagues on all matters relating to database technologies

BI Dev / Admin (50%)
Administer Cognos and Power BI and associated components
Engage with stakeholders to understand and help define business requirements
Provide datasets to colleagues to allow them create BI Reports and Dashboards
Manage the Data Warehouse and associated Data Cubes
Develop ad-hoc reports / dashboards / analysis as necessary
Be responsible to provide accurate analysis, assuring data reliability and consistency
Ensure that all reports and dashboards are documented
Analyse data and recommend data collection and processing improvements
Perform data cleansing and address anomalies in the data

Communicate with stakeholders and explain technical concepts in an audience-appropriate way
Update relevant stakeholders on the on-going operation of services, incident management and Improvement Programmes
Perform Continual Service Improvement
Contribute to disaster recovery and business continuity planning

COMPETENCIES:

  • Excellent analytical and problem-solving skills
  • Demonstrate high standards of accuracy and attention to detail
  • Strong understanding of technology and its application in business
  • Proven track record of continuous improvement
  • Can demonstrate commercial awareness 
  • Willingness to learn new technologies
  • Strong interpersonal and communication skills

 

QUALIFICATIONS/EXPERIENCE:

Must have (essentials)

  • Relevant Technical degree 
  • 4+ years of commercial experience with MS SQL database design, development, and maintenance 
    • Develop and maintain scripts, views, stored procedures, functions and triggers
    • Solid understanding of database performance tuning techniques such as Indexing or partitioning
    • Solid knowledge of ETL processes using SQL Server Integration Services 
  • Experience of administering a Data Warehouse
    • Understanding of Data Cubes / OLAP
    • Good experience of creating reports and dashboards with tools like Power BI or similar
    • Creating and maintaining datasets for others
    • Data analysis / Data cleansing / data quality
  • Have proven experience of delivering under tight deadlines.
  • Demonstrable experience of Incident Management and Change Management
  • Excellent English communication skills both written and spoken

Desirable

  • Cognos experience (Report Studio, Analysis Studio, Transformer)
  • Windows / Unix Scripting experience (scheduling, parsing, cron jobs)
  • Experience of using Web APIs to read / write data
  • Basic AWS or Azure, specifically with databases / reporting

 

If you have any further queries, please contact Folens HR on careers@folens.ie