Celonis Data Engineer

Job Family:

Data Engineering & Architecture Consulting

Travel Required:

Up to 10%

Clearance Required:

None

About our Data and Analytics Team

Our consultants on the CEI Solutions - Data and Analytics team help clients maximize the value of their data and automate business processes. This high performing team works with clients to implement the full spectrum of data analytics and data science, from data architecture and storage to data engineering and querying, to data visualization and dashboarding, to predictive analytics, machine learning, and artificial intelligence as well as intelligent automation. Our services enable our clients to define their information strategy, enable mission critical insights and data-driven decision making, reduce cost and complexity, increase trust, and improve operational effectiveness. We focus on client services, while also supporting business development, internal firm initiatives, and ongoing professional development.

About our Project

Guidehouse is supporting a statewide ERP implementation, to include: 1) Developing a financial data strategy; 2) Assessing current financial and related data; 3) Developing a data migration plan; 4) Establishing data governance practices. This position will concentrate on supporting the data profiling and migration activities for this digital modernization effort.

What You Will Do:

• Participate in data discovery and assessment activities to determine current data quality, data capabilities, and implications on organizational operations and data usage
• Execute data profiling activities and support the review and interpretation of results using Celonis and other analytical tools
• Support data engineering activities to map and transform data prior to ingestion into Celonis for process mining
• Develop custom SQL and PQL scripts in the Celonis platform to support data integration and transformation activities
• Assist with developing a data migration plan for the ERP system
• Coordinate closely with the broader data team to include the data strategy workstream

What You Will Need:

• Requires a University Degree and minimum of Three (3) years of prior experience
• Experience with Celonis and/or financial management business process mining
• Experience with SQL and PQL
• Data management experience that spans across the data lifecycle and critical functions (e.g., data profiling, data modelling, data engineering, data consumption product and services)
• Extensive experience with SQL or other approaches to query and analyze large data sets
• Ability to obtain and maintain a public trust clearance
• Excellent communications and demonstrated hands on experience communicating technical topics with non-technical audiences
• Ability to effectively collaborate and manage the timely completion of assigned activities while working in a highly virtual team environment
• Ability to commute on site 2-3 times per week in the Baltimore, MD / Annapolis, MD areas

What Would Be Nice To Have:

• Hands on experience supporting formal data profiling and data migration initiatives
• Familiarity of financial data and understanding of key accounting and financial functions
• Familiarity with large enterprise applications, including enterprise resource planning (ERP) software systems
• Experience with financial data modelling, data migration, and/or data architecture development
• Experience with Celonis and/or financial management business process engineering
• Experience with legacy financial management system modernization and associated data migration plan development
• Demonstrated work experience for financial services or public sector clients
• Certified Data Management Professional (CDMP) or another comparable data management certification
• Ability to support business development including RFP/RFQ/RFI responses involving data science / analytics

The annual salary range for this position is $85,000.00-$141,000.00. Compensation decisions depend on a wide range of factors, including but not limited to skill sets, experience and training, security clearances, licensure and certifications, and other business and organizational needs.

What We Offer:

Guidehouse offers a comprehensive, total rewards package that includes competitive compensation and a flexible benefits package that reflects our commitment to creating a diverse and supportive workplace.

Benefits include:

• Medical, Rx, Dental & Vision Insurance

• Personal and Family Sick Time & Company Paid Holidays

• Position may be eligible for a discretionary variable incentive bonus

• Parental Leave and Adoption Assistance

• 401(k) Retirement Plan

• Basic Life & Supplemental Life

• Health Savings Account, Dental/Vision & Dependent Care Flexible Spending Accounts

• Short-Term & Long-Term Disability

• Student Loan PayDown

• Tuition Reimbursement, Personal Development & Learning Opportunities

• Skills Development & Certifications

• Employee Referral Program

• Corporate Sponsored Events & Community Outreach

• Emergency Back-Up Childcare Program

• Mobility Stipend

About Guidehouse
Guidehouse is an Equal Employment Opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, national origin, ancestry, citizenship status, military status, protected veteran status, religion, creed, physical or mental disability, medical condition, marital status, sex, sexual orientation, gender, gender identity or expression, age, genetic information, or any other basis protected by law, ordinance, or regulation.

Guidehouse will consider for employment qualified applicants with criminal histories in a manner consistent with the requirements of applicable law or ordinance including the Fair Chance Ordinance of Los Angeles and San Francisco.

If you have visited our website for information about employment opportunities, or to apply for a position, and you require an accommodation, please contact Guidehouse Recruiting at 1-571-633-1711 or via email at RecruitingAccommodation@guidehouse.com. All information you provide will be kept confidential and will be used only to the extent required to provide needed reasonable accommodation.

Guidehouse does not accept unsolicited resumes through or from search firms or staffing agencies. All unsolicited resumes will be considered the property of Guidehouse and Guidehouse will not be obligated to pay a placement fee.