Data Analyst / Business Intelligence Developer at Vontier

KEY RESPONSIBILITIES

• Dashboard Development: Utilize Power BI to design and develop interactive dashboards and reports that provide actionable insights for various departments within the company. This includes creating visually appealing and user-friendly dashboards to meet business requirements.
• Data Extraction: Extract data from various sources, including Oracle databases and other relevant data systems, and ensure that data extraction processes are efficient and reliable.
• Data Transformation: Transform and clean data as necessary to ensure data accuracy and consistency, aligning it with reporting and analysis needs. Implement Extract, Transform, Load (ETL) processes as needed.
• SQL Expertise: Write and optimize complex SQL queries to retrieve and manipulate data for reporting purposes. Ensure SQL queries are efficient and well-structured.
• Data Modeling: Create and maintain data models that efficiently represent and aggregate the data for reporting, ensuring that data is organized and structured for optimal performance.
• Business Collaboration: Collaborate closely with business stakeholders to understand their data requirements, gather feedback, and translate business needs into effective data models, visualizations, and reports.
• Performance Optimization: Optimize data processing and reporting performance to ensure efficient and timely access to information. Continuously monitor and improve the performance of data solutions.
• Data Quality Control: Implement and maintain data quality controls and procedures to ensure the accuracy and integrity of the data used in reports and dashboards.
• Data Solution Maintenance: Maintain and enhance existing data solutions, troubleshoot data-related issues, and apply updates or improvements as necessary.
• Continuous Learning: Stay up-to-date with industry best practices and emerging trends in data analytics, business intelligence, and relevant technologies to ensure the organization remains at the forefront of data analytics.
• Documentation: Create and maintain documentation for data models, data sources, ETL processes, and report development for knowledge sharing and future reference.
• Training and Support: Provide training and support to end users, helping them understand and navigate the dashboards and reports you create.
• Collaboration: Work closely with cross-functional teams, including data engineers, data scientists, and other stakeholders to facilitate data-related projects.
• Reporting: Generate and distribute regular reports, as well as ad-hoc reports, in response to specific business needs.

DELEGATION OF AUTHORITY

As per the actual Schedule of Levels of Authority within Gilbarco.

POSITION RELATIONSHIPS

Internal               

• Works directly FMS Team leader
• All Departmental Managers
• Training & Development Department
• Team members: Needs to develop a strong working relationship with team members to ensure that countermeasures initiated as required are seen through.
• EMEA: Global WMS teams to deliver services and consult
• Technical team for escalated calls to be resolved              

External

• Customers: Needs to be highly customer focused, and able to form effective working relationships with key customers,
• Approved Sub-contractors: Effective management of sub-contractor and supplier relationships based on various contracts for work carried out onsite

MEASURES OF PERFORMANCE (INDICATORS)

Leading 

• Zero Loss Time incidences (LTI), 100% near miss / potential incidences with implemented corrective action within 14 days, 100% employee participation in NM / PI reporting and achievement of HSSE targets
• Sustained use of Standard Work in area of responsibility

Lagging 

• Internal SLA as set by the General Manager
• Drive continuous productivity level improvements measured by completed analysis on various delivery issues
• Maintain Variances on tanks at 0.5% on a continuous basis for project and maintenance calls
• Meet / exceed all customer contracted KPI’s

PERSONAL QUALIFICATIONS & EXPERIENCE

Education/achievements   

• Bachelor’s degree in computer science, Information Technology, Data Science, Business Intelligence, or a related field.   
• BSc Computer Science

Experience/Knowledge        

Required

• Proven experience in data analysis, database management, and data visualization.
• Strong proficiency in Power BI, including the ability to create complex reports and dashboards.
• Solid knowledge of Oracle databases and SQL, with the ability to write and optimize queries.
• Relevant certifications in Power BI, Oracle, or SQL is highly desirable.
• Excellent problem-solving and analytical skills.
• Effective communication and data storytelling abilities.
• Attention to detail and a commitment to data accuracy.

Additional Information:

Preferred

• Basic understanding of the fuel and fleet industry
• Basic accounting understanding
• Technical understanding of forecourt service station equipment

Specific Skills

Required

• Multilingual: French & English 
• Data cleaning and preparation
• Creating data visualizations
• Creating dashboards and reports
• Writing and communication
• Data analysis and exploration
• Statistical knowledge
• Presentation skills           

Preferred

• Analytical and problem-solving skills.
• Strong communication & interpersonal skills
• Attention to detail.
• Personal Organisation and time management
• Understand the importance of being “hands-on” in our operational processes and customer relations.
• Quality First: Plan & execute accurate, complete, timely and reliable work. 
• anagement by Fact: Gathers, analyses, and summarizes data to draw rational, fact-based conclusions