Senior BI Report Developer

Full Job Description

Business Unit:

Cubic Transportation Systems

Company Details:

Responsible for providing Business Intelligence (BI) report development including the support and analysis of large and complex business data. The role will involve driving the use and ongoing adoption of data and analytics for our internal and external customers and will lead on innovation and development whilst promoting and delivering best practice in the business intelligence field. It will include managing, maintaining and developing the Business Objects (BO) Crystal Reports required for all projects and clients. The candidate will work on multiple Business Intelligence technologies like Power BI for creating reports and dashboards and deliver reporting solutions that are efficient and satisfy project requirements. The incumbent will have regular technical interactions with onsite teams, customers and will work under limited supervision and exercise decision making authority.Job Details:

Essential Job Duties and Responsibilities :

• Provide subject matter expertise within the BI team, identifying and implementing process improvements that drive efficiency and return on investment using Business Intelligence (BI) strategies.
• Develop a broad range of, often complex, reports using BI reporting tools such as Power BI, Power BI Paginated reports, and Crystal Reports.
• Develop and deliver BI requirements as part of the global project teams for new and existing customers including dashboard design and development.
• Creating interactive and highly informative Power BI Paginated reports using advanced DAX features.
• Expert in writing SQL and advanced SQL queries.
• Solution design/architecture inputs for both new and established environments and provide regular and ad-hoc data analysis to key business units across the business.

• Analyse Business Intelligence report requirements and communicat with project team to clarify requirements.
• Troubleshoot technical and system questions from the development teams and end-users.
• Assesses severity of problems, determines corrective action, resolves technical issues, and performs fault isolation and implement solutions.  

• Coordinate and maintain the reporting requirements backlog, working with stakeholders to deliver value at the right time.
• Support and maintain existing Crystal reports with a focus on moving these across to a new platform.

• In addition to the duties and responsibilities listed, the job holder is required to perform other duties assigned by their manager from time-to-time, as may be reasonably required of them.

General Duties and Responsibilities:

• Comply with Cubic’s Quality Management System.
• Comply with Cubic Occupational Health, Safety and Environment policies and procedures.
• Comply with security in accordance with established policies and procedures of the organisations.
• Comply with Cubic Human Resources Procedures.
• Active participation in global team meetings and events when required.
• Other duties as requested.

Minimum Job Requirements:
 

• Minimum of 7 years of proven experience in relevant Business Intelligence / Data warehousing technologies.
• Expert in using reporting tools like Power BI/Power BI report builder.
• Report creation and Dashboard using Data Warehouse.
• Ability to interact professionally with internal and external customers at a technical and non-technical level.
• Demonstrated ability to handle high-pressure deadlines.
• Experience in Data Warehouse , Data Modelling and working with various datasource and API’s.

Qualifications

Essential:

• Bachelor and/or Post Graduate qualifications in a related field.

Skills/Experience/Knowledge

Essential:

• Proven expertise in creating Power BI datasets, dashboards, using external tools like DAX Editor, Tabular Editor and skills in using Power BI/Paginated reports.
• Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases, using CETAS querying serverless/dedicated SQL pool.
• Experience of working wtih SAP Business Objects (Webi, Universes, Crystal) and report development.
• Strong business analysis skills with an ability to understand complex business process and ability to using a JIRA tool.
• Experience in BI development cycle and BI best practices.

Desirable:

• Experience with Azure technologies.
• Certification in Power BI / Data Engineering, Azure fundamentals.
• Experience with SQL DB2.

Education and qualifications

Essential:

• Educated to Degree level in Computer Science, Engineering field, or equivalent education/experience.

Desirable:

• Master’s degree or equivalent within a relevant field or equivalent education/experience.

Personal Qualities

• Must have excellent English communication skills both oral and written.
• Someone who is always striving for continuous improvement and understands the need for change controls and coding best practices.
• A positive work ethic, analytical thinker, and an effective communicator.
• A self-motivated, focused individual with excellent interpersonal and presentation skills.
• The ability to manage multiple initiatives simultaneously and capable of working effectively under pressure.
• Able to work effectively with remote management, minimal supervision and regularly exercise discretion and decision-making.
• Must be self-motivated with an excellent attitude. 
• Ability to perform work requiring a high degree of accuracy. 
• Able to prioritize work, complete multiple tasks and work under tight deadlines. 

Condition of Employment:

Successful outcome of a National Police Check

The description provided above is not intended to be an exhaustive list of all job duties, responsibilities, and requirements. Duties, responsibilities, and requirements may change over time and according to business need.

Worker Type:

Employee