Senior Business Intelligence Developer

Business Unit:

Cubic Transportation Systems

Company Details:

When you join Cubic, you become part of a company that creates and delivers technology solutions in transportation to make people’s lives easier by simplifying their daily journeys, and defense capabilities to help promote mission success and safety for those who serve their nation. Led by our talented teams around the world, Cubic is committed to solving global issues through innovation and service to our customers and partners.

We have a top-tier portfolio of businesses, including Cubic Transportation Systems (CTS) and Cubic Defense (CD). Explore more on Cubic.com.

Job Details:

  
Job Summary: 

  

Responsible for providing Business Intelligence (BI) reporting solution 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 Power BI reports required for all projects and clients. The candidate will work on multiple Business Intelligence technologies like Azure, SQL and 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. 

 

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 and Power BI Report Builder., 

• Liaise directly with internal and external customers to respond to data queries, troubleshoot issues and analyse, refine and finalise reporting requirements. 

• Develop and deliver BI requirements as part of the UK project teams for new and existing customers including back-end data transformation in SQL, and dashboard design and development. 

• Creating interactive and highly informative Power BI Paginated reports and Dashboards 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. 

• Troubleshoot technical and system questions from internal and external end-users. 

• Assess severity of problems, determine corrective action, resolve technical issues, and perform 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 the existing Power BI reporting suite, and look to migrate existing manual reporting processes into Power BI 

• 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. 

• Write up project documentation, technical documentation, and sufficiently comment their code to ensure others can understand it.  

 

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:  
 

• Advanced SQL and report development skills, including the development and automation of reports, ideally using Power BI and Power BI Report Builder. 

• Minimum of 5 years of proven experience in relevant Business Intelligence / Data warehousing technologies. 

• Minimum 1+ years experience in working on Azure ML technologies. Proficiency working with libraries such as  Pandas, Numpy, Scikit-Learn, TensorFlow, PyTorch, and MLflow for model tracking. (python, azure sdk,pyspark) 

• ProficientE and experience on working with Machine Learning Algorithms and Techniques for predictive modeling, forecasting, and classification. Proficient and exposure working on Supervised Learning,Unsupervised Learning,Natural Language Processing and Deep Learning 

• Report creation and Dashboard development 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 technologies, Data Modelling and working with various datasource and API’s.  

 

 

 

 

Qualifications 

Essential:  

• Educated to Degree and/or equivalent level 

 

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/Report Builder. 

• 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. 

• 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. 

• Ability to convert business processes into technical requirements, and communicate effectively with a wide range of audiences of varying levels of technical understanding. 

 

Desirable:  

• Experience with Azure technologies. 

• Certification in Power BI / Data Engineering, Azure fundamentals. 

 

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 

• It is essential for the candidate to have excellent English communication skills both oral and written – must be able to clearly communicate complex topics and decisions to an audience who doesn’t hold the same level of technical expertise, and be able to effectively discussion solution options and ensure they are understood

• 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 a positive attitude, and be proactive at recommending and implementing change initiatives 

• Ability to perform work requiring a high degree of accuracy.  

• Able to prioritize work, complete multiple tasks and work under tight deadlines.  

 

  

Worker Type:

Employee