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 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. 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 warehousing concepts, dimensional models, and established data flows, with the ability to work within existing structures.
• Problem Solving: Ability to resolve routine issues using documented methods, identify data discrepancies, and escalate complex problems appropriately.
• Communication: Ability to communicate data findings and support information clearly, document work, and collaborate effectively with technical and non-technical partners.
• Time Management: Ability to manage assigned priorities, meet time commitments, and follow established work processes.

Note: The statements above are intended to describe the general nature and level of work being performed by people assigned to the job. They are not construed to be an exhaustive list of responsibilities, duties, and skills required of personnel. Furthermore, they do not establish a contract for employment and are subject to change at the discretion of the employer.

About Michelman

Michelman is a global developer and manufacturer of environmentally friendly advanced materials for industry, offering solutions for the coatings, printing & packaging, and fibers & composites markets. The company's surface modifiers, additives, and polymers are used by leading manufacturers around the world to enhance performance attributes and add value in applications including wood and floor care products, metal and industrial coatings, paints, varnishes, inks, fibers, and composites. Michelman is also well-known as an innovator in the development of barrier and functional coatings, as well as digital printing press primers that are used in the production of consumer and industrial packaging and paper products, labels, and commercially printed materials. Michelman serves its customers with production facilities in North America, Europe, and Asia, product development and technical service centers in several major global markets, and a worldwide team of highly trained business development personnel.

No phone calls, please. Employment requirements, including drug screening and tobacco testing (where legally permissible), will be administered in accordance with applicable local laws and company policies prior to employment.

For more information about Michelman, please visit https://www.michelman.com/.

It is Michelman, Inc. policy to seek and employ qualified persons in all jobs in a manner which will ensure equal employment opportunity as well as administer personnel actions in a manner as to not discriminate against any person on the basis of race, religion, national origin, age, sexual orientation or disability. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Michelman is an Equal Opportunity Employer Minorities/Females/Disabled/Veterans