Sr Professional, Business Analysis

Ingram Micro Inc.; Irvine (CA); Hybrid; USD 86,000 - 137,000; Full time

Job summary

Ingram Micro Inc. is hiring a Sr Professional, Business Analysis to design and implement Celonis dashboards, KPIs, and data models across ERP/CRM data.

This role collaborates with process owners to translate business needs into actionable Celonis implementations and provides ongoing data support and optimization. The ideal candidate has 5+ years of experience in data analysis/ETL, strong SQL/PQL skills, and proficiency with Power BI or Tableau to enable daily value generation.

Qualifications

• Bachelor's degree in a related field (or additional relevant experience in lieu of a degree); minimum 5 years functional experience including 3+ years specific experience.
• Proficiency in PQL and SQL coding, including writing, refactoring, and optimizing transformations.
• Extensive experience in ETL processes.
• Strong experience with relational databases and data modeling.
• Python skills.
• Hands-on data visualization (Power BI, Tableau) and data analysis experience.
• Experience in process improvement, business analysis, or technology consulting, applying technology solutions to core business problems.
• Experience in core business processes (e.g., procurement, customer onboarding) and business transformation initiatives.
• Proficiency in leading and facilitating workshops and meetings.
• Relevant domain / process expertise (for internal hire).

Responsibilities

• Data Analyst — Build Analyses & KPIs in Celonis; Collaborate with process owners to translate requirements into Celonis use cases.
• Data Engineer — Translate requirements into technical/data specs; build Celonis data model and ETL pipelines; validate data and optimize performance.

Skills

PQL

SQL

ETL

Relational DBs

Data modeling

ERP/CRM

Python

Power BI

Tableau

Data analysis

Workshops facilitation

Process improvement

Celonis ML (preferred)

Education

Bachelor's degree

Tools

Celonis

Job description

## Sr Professional, Business AnalysisApply: Irvine, CA, United States of America: Full time: Posted Today: R-117613**Accelerate your career. Join the organization that's driving the world's technology and shape the future.**Ingram Micro is a leading technology company for the global information technology ecosystem. With the ability to reach nearly 90% of the global population, we play a vital role in the worldwide IT sales channel, bringing products and services from technology manufacturers and cloud providers to business-to-business technology experts. Our market reach, diverse solutions and services portfolio, and digital platform Ingram Micro XvantageTM set us apart. Learn more at www.ingrammicro.comCome join our team where you’ll make technology happen in surprising ways. Let’s shape tomorrow - it’ll be a fun journey! This role combines the data and technical analysis functions in a single individual contributor. This role is expected to build and validate all Celonis dashboards, analyses, and standardized KPIs and translate data into actionable insights for daily operational use, drive the system/tool implementation behind them, identify source data, extracting, transforming, and loading it, building and optimizing the Celonis data model, writing PQL transformations, and managing Celonis test environments. This role is expected to partner closely with warehouse management analysts and process owners to translate business requirements into technical and data requirements, keep data loads clean, and provide ongoing technical support. Seasoned professional individual contributor. Works independently with limited supervision. May manage projects/processes. Coaches and reviews the work of lower-level professionals. Problems faced are difficult and often complex. Influences others regarding policies, practices and procedures.Provides solutions to a variety of complex technical and business matters. Will champion significant projects, programs and business initiatives using demonstrated creativity and ingenuity. May assist more junior staff members with aspects of their job.Incumbents provide a leadership role for the work group through knowledge in his/her area of specialization. Generally free to determine work priorities based on general direction from managers.Specialist in technical or business skills. Four-year college degree (or additional relevant experience in a related field). Minimum 5 years functional experience including a minimum of 3 years specific experience. Ability to make significant contribution to processes and systems. **Key Responsibilities** Data Analyst — Build Analyses & KPIs in Celonis • Collaborate with process owners and end users to understand their goals, objectives, and requirements and translate them into Celonis requirements and use cases.• Design, implement, test, and validate all dashboards, analyses, and reports within Celonis.• Define, build, and organize standardized KPIs, ensuring consistent calculation logic, and translate data into actionable insights users need for daily value generation.• Document Celonis implementations and build a library of use cases.• Manage and prioritize all incoming requests for Celonis enhancements.• Lead business value workshops with process improvement and business teams to identify and qualify operational and process improvement opportunities.• Support and enable end users. Data Engineer — Technical Implementation & Support • Work with business analysts and business application owners to translate business requirements and use cases into technical and data requirements.• Identify all source system tables and fields that need to be brought into Celonis.• Extract, transform, and load all source system data needed for each process implemented within Celonis.• Write and maintain PQL transformations and build the Celonis data model and connections for each process.• Revise and optimize existing calculations and data queries to improve efficiency and ensure ideal response times.• Manage Celonis test environments, including validation and promotion of data models, transformations, and assets.• Collaborate with warehouse management analysts and business experts to validate data within Celonis and ensure smooth data loads.• Document all technical and data requirements and all extract, transform, load (ETL) work.• Provide ongoing support for any data-related issues. **Required Skills / Qualifications** • Bachelor's degree in a related field (or additional relevant experience in lieu of a degree); minimum 5 years functional experience including 3+ years specific experience.• Proficiency in PQL and SQL coding, including writing, refactoring, and optimizing transformations.• Extensive experience in ETL processes.• Strong experience with relational databases and data modeling.• Solid understanding of the data structures of core enterprise systems (e.g., ERP, CRM).• Python skills.• Hands-on data visualization (Power BI, Tableau) and data analysis experience.• Experience in process improvement, business analysis, or technology consulting, applying technology solutions to core business problems.• Experience in core business processes (e.g., procurement, customer onboarding) and business transformation initiatives.• Proficiency in leading and facilitating workshops and meetings.• Relevant domain / process expertise (for internal hire). **Preferred** • Experience building machine learning models in the Celonis ML workbench for predictions.• Experience managing Celonis development / test / production environments and promoting assets between them.• Familiarity with warehouse management systems and warehouse operations data. #LI-LB2 The typical base pay range for this role across the U.S. is USD $85,800.00 - $137,300.00 per year.The ranges above reflect the potential annual base pay across the U.S. for all roles; the applicable base pay range will depend on the candidate’s primary work location, pay grade, and variable compensation plan. Individual base pay within each range depends on various factors, in addition to primary work location, such as complexity and responsibility of role, job duties/requirements, and relevant experience and skills. Base pay ranges are reviewed and typically updated each year. Offers are made within the base pay range applicable at the time of hire. New hires starting base pay generally falls in the bottom half (between the minimum and midpoint) of a pay range.At Ingram Micro certain roles are eligible for additional rewards, including merit increases, annual bonus or sales incentives and long-term incentives. These awards are allocated based on position level and individual performance. U.S.-based employees have access to healthcare benefits, paid time off, parental leave, a 401(k) plan and company match, short-term and long-term disability coverage, basic life insurance, and wellbeing benefits, among others.This is not a complete listing of the job duties. It’s a representation of the things you will be doing, and you may not perform all these duties.Please be prepared to pass a drug test and successfully pass a pre-employment (post offer) background check.Ingram Micro Inc. is proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, veteran status, or any other protected category under applicable law.