Senior Software Engineer - Business Intelligence

24 Jan 2023
28 Jan 2023
Employer Sector
Technology, ICT & Telecoms
Contract Type
Full Time
Job Details
A full-time, permanent vacancy has arisen for the role of Senior Software Engineer - Business Intelligence. The successful candidate will become a core member of the team working across the full software development lifecycle helping to design and build solutions based on industry best practices and providing expertise to broader team.
Key responsibilities will include but are not limited to:
Working within a persistent team to deliver business value by incremental iterations
Design, development and maintenance of the Data Warehouse and Operational Data Store.
Work with architects, business analysts, test teams, project managers and business users to analyze and document outputs, identifying options and end-to-end solutions.
Review, design, and assist in development of requirements and technical specifications in accordance with agreed standards
Coordinate with Enablement Stream Product Owner, Scrum Master and team members to provide consistency to planning, development and delivery of work.
Gain a detailed knowledge of the functional and technical components of systems.
Design and develop complex programs and features using agreed standards and tools, to achieve a well-engineered result.
Perform code reviews.
Participate in agile team ceremonies and practices & participate in design reviews and recommend improvements.
Work with other Engineers in planning, prioritizing and executing assigned tasks within deadlines.
Manage and independently resolve production incidents.
Drive deliverables to completion within timelines ensuring collaboration and effective communication with all stakeholders & Drive the mind-set of continuous improvement.
The successful candidate must have:
Experience in the design and development of new data marts using an Oracle database.
Experience in the design and development of ETL processes using SSIS.
Knowledge of Oracle PL/SQL programming language.
Strong skills in database query optimization and performance.
Sound knowledge of Dimensional Modelling and Data Warehouse design principles.
Knowledge of MicroStrategy report, document and dashboard development desirable.
Experience with data visualization tools such as Tableau desirable.
Knowledge of MicroStrategy and Tableau server administration desirable.
Knowledge of data classification and data cataloging tools desirable
Knowledge of cloud data warehousing, AWS or similar cloud technologies desirable
Knowledge of real-time data warehousing and streaming technologies ( such as Kafka) desirable
Experience with linux shell scripting desirable but not essential
Excellent data analysis, problem solving and troubleshooting skills
Demonstrate Alignment with Vhi Values
Education and knowledge
Relevant third level qualification and/or business analyst professional qualification
5+ years business intelligence development experience.
Strong experience of data warehousing and modelling
Extensive experience of project delivery methods (Agile/Waterfall SDLC)
Experience in Quality of technical design and data design.
Data and requirement analysis capability.
Track record in producing fit for purpose solutions.
Experience of resolution of production incidents and troubleshooting.
VHI is an equal opportunities employer.