Business Intelligence Engineer

Michelman•Deer Park, OH

About The Position

The Business Intelligence Engineer supports business reporting and data needs by gathering, compiling, validating, and analyzing data using established tools and formats, including the Operational Data Store (ODS), JD Edwards (JDE), MS SQL Server, SSAS, and Power BI. The 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. The required work hours are Monday through Friday, 11 a.m. to 8 p.m. Singapore Standard Time, to support Michelman’s Asia sites. Occasional on-call availability for P1 incidents outside this window is required. The role works with business analysts and stakeholders to clarify data needs, support document and workflow analysis, and complete assigned work based on finalized requirements and technical specifications. Routine and complex issues are handled according to established procedures, with complex design, architecture, performance, or integration matters escalated to senior team members or the Manager, BI and Reporting.

Requirements

Bachelor’s degree in Computer Science, Information Technology, or a related field, or equivalent practical experience.
At least 2 years of relevant BI, reporting, ERP, or data support experience.
Working proficiency in Power BI Desktop, Power BI Service, Power Query, and DAX, with the ability to maintain and enhance existing solutions.
Working knowledge of SQL Server, T-SQL, and SSAS, including the ability to prepare data extracts and make routine updates to existing objects.
Hands-on experience supporting JD Edwards EnterpriseOne 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.
General understanding of data warehousing concepts, dimensional models, and established data flows, with the ability to work within existing structures.
Ability to resolve routine issues using documented methods, identify data discrepancies, and escalate complex problems appropriately.
Ability to communicate data findings and support information clearly, document work, and collaborate effectively with technical and non-technical partners.
Ability to manage assigned priorities, meet time commitments, and follow established work processes.
Availability to work Monday through Friday, 11 a.m. to 8 p.m. Singapore Standard Time, with occasional on-call availability for P1 incidents outside this window.

Responsibilities

Prepare Power BI reports, dashboards, KPI scorecards, and analytics by gathering, validating, and providing data inputs using established templates and standards.
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.
Collate and analyze data using preset tools, methods, calculations, and formats.
Update SSAS models and DAX calculations based on finalized specifications and manager direction.
Prepare requested data extracts and update 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.
Use JD Edwards data mappings to extract, compile, validate, and translate ERP data, including Finance, Supply Chain, and Manufacturing data, into standard reporting formats.
Extract, compile, and manipulate data from the Operational Data Store and other approved sources using preset tools and formats.
Support the JD Edwards application team by logging, categorizing, routing, and escalating JDE and EDI tickets.
Resolve routine JDE issues and straightforward defects using documented procedures, including occasional critical-incident support during Singapore working hours.
Troubleshoot queries, existing SSAS models, Power BI reports, and data processes; correct straightforward defects and escalate complex performance or design issues.
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.