BI Engineer: Power BI & SQL Data Analytics

Michelman, Inc.; Cincinnati (OH); In loco; USD 85.000 - 120.000; Tempo pieno

Descrizione del lavoro

Michelman, Inc. is hiring a Business Intelligence Engineer to support reporting and data needs by gathering, validating, and analyzing data using Power BI, MS SQL Server, SSAS, and JD Edwards.

You will prepare data extracts, contribute inputs to reports and dashboards, and assist in enhancements to existing BI solutions. Responsibilities include building Power BI reports, maintaining SSAS models, performing ETL updates with T-SQL, and translating ERP data into standard formats for business

Competenze

• 2+ years of 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.
• Data Warehousing: General understanding of data warehousing concepts, dimensional models, and established data flows.
• 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.

Mansioni

• Prepare Power BI reports, dashboards, KPI scorecards, and analytics by gathering, validating, and providing required 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.
• Update SSAS models and DAX calculations based on finalized specifications and manager direction.
• Prepare requested data extracts and perform updates to existing T-SQL stored procedures, views, functions, and ETL processes using approved standards.
• Use JD Edwards data mappings to extract, compile, validate, and translate ERP data into standard reporting formats.
• Extract, compile, and manipulate data from the Operational Data Store and other approved sources using preset tools and formats.
• Log and escalate JDE and EDI tickets; occasional critical-incident support during Singapore working hours.
• Conduct routine troubleshooting of queries, existing SSAS models, Power BI reports, and data processes.
• Collaborate with business analysts and stakeholders to clarify data needs and finalize requirements.

Conoscenze

Power BI

SQL Server

SSAS

DAX

T-SQL

ETL

JD Edwards

Data analysis

Report development

Communication

Formazione

Bachelor's degree in Computer Science, Information Technology, or related field

Strumenti

JD Edwards EnterpriseOne

Microsoft Excel

Descrizione del lavoro

Michelman, Inc. is hiring a Business Intelligence Engineer to support reporting and data needs by gathering, validating, and analyzing data using Power BI, MS SQL Server, SSAS, and JD Edwards.

You will prepare data extracts, contribute inputs to reports and dashboards, and assist in enhancements to existing BI solutions. Responsibilities include building Power BI reports, maintaining SSAS models, performing ETL updates with T-SQL, and translating ERP data into standard formats for business