Generate a CV for this Job!

Based on your profile and this job description, you can create a tailored CV to apply directly.

Celonis Data Engineer - Communities, Energy & Infrastructure

Guidehouse • Virginia, US • On-site

Posted on: 15th March, 2025
Employment Type: FULLTIME

Job Description

Job Family

Data Engineering & Architecture Consulting

Travel Required

Up to 50%

Clearance Required

Ability to Obtain Public Trust

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
• Ability to OBTAIN and MAINTAIN a Federal Public Trust
• Bachelor's degree AND Three (3+) years relevant post-graduation work experience; Or Master's degree AND One (1+) years relevant post-graduation work experience
• Must have post-graduation work experience using Celonis platform
• Extensive experience with SQL and PQL or other approaches to query and analyze large data sets
• 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)
• 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 work onsite in a Guidehouse Office and Client Office location 2-3 times per week in the Baltimore, MD / Annapolis, MD areas

What Would Be Nice To Have
• Preference will be given to candidates within reasonable driving distance of a core Guidehouse Office listed
• Certified Data Management Professional (CDMP) or another comparable data management certification
• Hands on experience supporting formal data profiling and data migration initiatives
• Experience with financial data modelling, data migration, and/or data architecture development
• Experience with legacy financial management system modernization and associated data migration plan development
• Familiarity of financial data and understanding of key accounting and financial functions
• Familiarity with large enterprise applications, including enterprise resource planning (ERP) software systems
• Demonstrated work experience for financial services or public sector clients
• 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 [email protected]. 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.

Responsibilities

  • 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
  • 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
  • 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

Requirements

  • Ability to Obtain Public Trust
  • Ability to OBTAIN and MAINTAIN a Federal Public Trust
  • Bachelor's degree AND Three (3+) years relevant post-graduation work experience; Or Master's degree AND One (1+) years relevant post-graduation work experience
  • Must have post-graduation work experience using Celonis platform
  • Extensive experience with SQL and PQL or other approaches to query and analyze large data sets
  • 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)
  • 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 work onsite in a Guidehouse Office and Client Office location 2-3 times per week in the Baltimore, MD / Annapolis, MD areas
  • Preference will be given to candidates within reasonable driving distance of a core Guidehouse Office listed
  • Certified Data Management Professional (CDMP) or another comparable data management certification
  • Hands on experience supporting formal data profiling and data migration initiatives
  • Experience with financial data modelling, data migration, and/or data architecture development
  • Experience with legacy financial management system modernization and associated data migration plan development
  • Familiarity of financial data and understanding of key accounting and financial functions
  • Familiarity with large enterprise applications, including enterprise resource planning (ERP) software systems
  • Demonstrated work experience for financial services or public sector clients
  • Ability to support business development including RFP/RFQ/RFI responses involving data science / analytics
Guidehouse

Guidehouse

Technology

Location

Virginia, US

Job Type

FULLTIME

Benefits

  • 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
  • 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
  • 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

Loading...

Loading...

AI Cover Letter Generator

Generate a Tailored Cover Letter!

Our AI will analyze your profile and create a personalized cover letter that highlights your relevant skills and experience.

Ready to Apply?

Click the button below to start your application process.

Related Jobs

Catalyst Operations & Analytics

4 weeks ago

Full-time

Backend Data Engineer Jobs

District of Columbia, US View Job

Gridiron IT

1 week ago

FULLTIME

Secret Cleared Data Engieer

Virginia, US View Job