Junior Automation & Business Intelligence Developer (1-Year Contract)

Howden; Singapore; On-site; SGD 40,000 - 60,000; Full time

Job summary

Howden is seeking a Junior Automation & Business Intelligence Developer to join the Strategy & Operations team in Singapore. The role focuses on building Power BI dashboards, automation with Power Automate and VBA, and enabling data-driven decision-making while improving processes across the organisation.

You will develop data models, reports, and KPI solutions, while collaborating with the API/tech team and business users.

Qualifications

• Bachelor-level or higher in a data/analytics related field is preferred.
• Experience with BI reporting, automation or Power Platform is desirable.
• Familiarity with data governance and quality practices is advantageous.

Responsibilities

• Develop, enhance and maintain Power BI dashboards and reports translating business needs into insights.
• Design and implement data models, DAX calculations and data transformations.
• Create and maintain automation scripts using Power Automate and VBA.
• Support Power Apps and SharePoint-based solutions and ensure data quality and governance.

Skills

Power BI

DAX

Power Query

Excel

VBA

Power Automate

SharePoint Online

Data validation

Data modelling

Education

Diploma or degree in Business Analytics, Information Systems, Computer Science, Data Analytics, Engineering or related discipline

Tools

Power BI Desktop

Power Apps

SharePoint Online

SQL

VBA

Excel

Job description

At Howden, we employ talented individuals and empower them to make a real difference to the company, whilst building successful and fulfilling careers.

The entrepreneurial atmosphere is one of the biggest reason people love to work for us. We are a leading independent, global insurance brokers but have a noticeably flat hierarchy. It doesn’t matter how junior or senior, anyone with a good idea will be heard. This means our employees can shape their own career paths and determine their own success.

This atmosphere attracts the brightest talent in the market. If that includes you, get in touch.

Job role: Junior Automation & Business Intelligence Developer

Department: Strategy & Operations

Reports to: Assistant Manager, Strategy & Operations

A LEADING GLOBAL INDEPENDENT BROKER

Howden is a specialist commercial insurance broker. Its regional footprint covers Singapore (regional headquarters), Malaysia, Hong Kong, Indonesia, Thailand, and Philippines. It is part of the London-headquartered Howden Broking Group, a leading independent, global broker with offices in 55 countries worldwide.

Job Overview

The Junior Automation & Business Intelligence Developer is responsible for building practical data, reporting, and automation solutions that simplify work processes, strengthen decision-making, and support operational transformation across Howden Singapore.

This includes developing and maintaining Power BI dashboards, operational reports, and KPI solutions; designing workflow automations using Microsoft Power Automate and Microsoft 365; creating Excel-based tools and process automations with VBA; delivering operational solutions through Power Apps and SharePoint; ensuring data quality through cleansing, transformation, validation, and continuous improvement initiatives; supporting and enhancing existing reporting and automation systems; and exploring emerging use cases involving Microsoft Copilot, Copilot Studio, and the responsible application of generative AI to drive business efficiency and innovation.

YOUR ROLE AND RESPONSIBILITIES:

Business intelligence and reporting

• Develop, enhance and maintain Power BI dashboards and reports that translate business requirements into clear, actionable insights.
• Build reliable data models and create calculations using Data Analysis Expressions (DAX).
• Use Power Query and the M language to connect, cleanse, transform and combine data from multiple sources.
• Define and implement operational metrics, key performance indicators and management reporting views.
• Apply sound data visualisation principles to produce intuitive, accessible and decision-ready reports.
• Validate outputs, investigate discrepancies and maintain appropriate documentation for calculations and data sources.
• Publish and maintain reports within the Power BI Service, including refresh schedules, access and deployment support.

Automation and Power Platform delivery

• Design, build, test and maintain cloud flows using Microsoft Power Automate.
• Automate repetitive activities across Microsoft Excel, Outlook, SharePoint, Teams and other approved business applications.
• Develop and maintain Excel tools, macros and process automations using Visual Basic for Applications (VBA).
• Support the development and enhancement of Microsoft Power Apps and SharePoint-based solutions.
• Assess whether Power BI, Power Automate, Power Apps, VBA or another approved approach is the most appropriate solution for a business need.
• Monitor solution performance, troubleshoot failures and implement sustainable fixes.

Project delivery and business engagement

• Deliver assigned small-to-medium projects independently, from requirements clarification through build, testing, deployment and handover.
• Collaborate with the other developer and relevant partners on larger or technically complex initiatives.
• Participate in business discovery sessions and translate operational needs into clear functional and technical requirements.
• Provide realistic effort estimates, flag delivery risks early and maintain transparent progress updates.
• Prepare test scenarios and support system integration testing and user acceptance testing.
• Create clear technical documentation, user guides, process maps and support materials.
• Support solution adoption through demonstrations, training and post-implementation assistance.
• Manage multiple concurrent assignments within the prioritised project pipeline.

Data quality, governance and controls

• Perform data profiling, cleansing, reconciliation and validation to improve the reliability of reporting and automation outputs.
• Apply appropriate access controls, documentation, version management and change controls.
• Handle business and personal data responsibly and follow applicable information security, privacy and organisational requirements.
• Promote reusable components, consistent development standards and controlled deployment practices.
• Identify opportunities to simplify and standardise processes before automating them.

SKILLS AND EXPERIENCE

Essential technical capabilities

• Microsoft Power BI Desktop, including data modelling, report development and data visualisation.
• Data Analysis Expressions (DAX) for calculated columns, measures and analytical logic.
• Power Query and M language for data connection, cleansing and transformation.
• Advanced Microsoft Excel, including formulas, lookup functions, PivotTables and structured data handling.
• Visual Basic for Applications (VBA) and Excel macros for business process automation.
• Microsoft Power Automate for workflow, notification, approval and file-processing solutions.
• Working knowledge of SharePoint Online, including lists, document libraries, metadata and permissions.
• Strong understanding of data accuracy, validation and troubleshooting.

Preferred capabilities

• Microsoft Power Apps, including canvas apps and SharePoint-integrated forms.
• Structured Query Language (SQL) for querying and combining relational data.
• Power BI Service administration concepts, including workspaces, refresh, gateways and row-level security.
• Microsoft Fabric, Dataverse, Copilot Studio, Python, APIs or other integration technologies.
• Exposure to generative AI, intelligent document processing or automation platforms.
• Awareness of data governance, privacy, information security and controlled change practices.

Experience and qualifications

• Diploma or degree in Business Analytics, Information Systems, Computer Science, Data Analytics, Engineering or a related discipline.
• Typically one to three years of relevant experience in business intelligence, reporting, data analytics, process automation or Power Platform development.
• Fresh graduates with strong internships, academic projects or a demonstrable portfolio in Power BI, Power Platform, VBA or data analytics are encouraged to apply.
• Experience gathering requirements and working with non-technical business users is advantageous.
• Experience delivering a solution through testing, deployment and post-launch support is advantageous.

YOUR BENEFITS AND SALARY:

• Commensurate with qualification and experience
• Working in a collaborative environment with excellent learning opportunities

DATA PROTECTION NOTICE FOR JOB APPLICANTS

This Data Protection Notice (“Notice”) sets out the basis upon which Howden Insurance Brokers (S.) Pte. Limited (“we”, “us” or “our”) may collect, use, disclose or otherwise process personal data of job applicants in accordance with the Personal Data Protection Act (“PDPA”). This Policy applies to personal data in our possession or under our control, including personal data in the possession of organizations which we have engaged to collect, use, disclose or process personal data for our purposes.”

For more information, please refer to the link below.

• https://www.howdengroup.com/sg-en/Howden_SG_PDPA_Notice_for_Job_Application