Business Intelligence Engineer

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 workflow analysis, and complete assigned work from finalized requirements and technical specifications.

Qualifications & Education

Education:

Bachelor’s degree in Computer Science, Information Technology, or a related field, or equivalent practical experience, with 2+ years of relevant BI, reporting, ERP, or data support experience.

Power BI:
Working proficiency in Power BI Desktop, Power BI Service, Power Query, and DAX, with the ability to maintain and enhance existing solutions.

Microsoft BI Stack:
Working knowledge of SQL Server, T-SQL, and SSAS, including the ability to prepare data extracts and make routine updates to existing objects.

JD Edwards:
Hands-on experience supporting JD Edwards Enterprise One in a production environment. Working knowledge of relevant JDE tools and processes, with the ability to complete routine support, testing, data extraction, and enhancements to existing solutions using established specifications. Complex design, development, upgrades, security administration, database design, and data-structure decisions are escalated to senior team members or the manager.

Data Warehousing:
General understanding of data…