Celonis Data Engineer

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 utilizing Celonis.

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:

• Must be able to OBTAIN and MAINTAIN a Federal or DoD "PUBLIC TRUST"; candidates must obtain approved adjudication of their PUBLIC TRUST prior to onboarding with Guidehouse
• 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. Candidates who do not have Celonis experience will not qualify nor can be considered for this role
• 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:

• Candidates with an ACTIVE PUBLIC TRUST or SUITABILITY are preferred
• Preference will be given to candidates within reasonable driving distance of a core Guidehouse Office listed on the posting only
• Certified Data Management Professional (CDMP) or another comparable data management certification in addition to CELONIS
• Hands on experience supporting formal data profiling and data migration initiatives in combination with Celonis experience
• Experience with financial data modelling, data migration, and/or data architecture development in combination with Celonis experience
• 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