General Summary
The Business Intelligence (BI) Engineer supports business reporting and data needs by gathering, compiling, validating, and analyzing data using established tools, methods, and formats including Operational Data Store (ODS), JD Edwards (JDE), MS SQL Server, SSAS, and Power BI. This role prepares requested data extracts, contributes data inputs to reports and dashboards, supports routine enhancements to existing BI solutions, and troubleshoots or escalates issues according to defined procedures.
Work Hours
Due to support requirements at Michelman Asia sites, the required work hours for this role is Monday – Friday from 11 am – 8 pm Singapore Standard Time, with occasional on-call availability for P1 incidents outside of this window.
Key Responsibilities
- Report Preparation: Prepare Power BI reports, dashboards, KPI scorecards, and analytics by gathering, validating, and providing required data inputs using established templates and standards.
- Support Tickets: Log, categorize, route, and escalate Power BI, security, access, and report-request tickets. Provide end-user support for routine or unresolved queries within established procedures.
- Data Analysis: Collate and analyze data using preset tools, methods, calculations, and formats. Update SQL Server Analysis Services (SSAS) models and DAX calculations based on finalized specifications and manager direction.
- Database and ETL Support: Prepare requested data extracts and perform updates to existing T-SQL stored procedures, views, functions, and ETL processes using approved standards. Escalate data structure, architecture, or complex integration changes to the Manager, BI and Reporting.
- ERP Data Support: Use JD Edwards data mappings to extract, compile, validate, and translate ERP data (e.g. Finance, Supply Chain, Manufacturing) into standard reporting formats.
- Data Management: Extract, compile, and manipulate data from the Operational Data Store and other approved sources using preset tools and formats.
- ERP Support: Support the JD Edwards application team by logging, categorizing, routing, and escalating JDE and EDI tickets. Resolve routine issues and straightforward defects using documented procedures, including occasional critical-incident support during Singapore working hours.
- Routine Troubleshooting: Conduct routine troubleshooting of queries, existing SSAS models, Power BI reports, and data processes. Correct straightforward defects and escalate complex performance or design issues.
- Collaboration: Work with business analysts and business stakeholders to clarify data needs, support document and work