Celonis Data Engineer – Communities – Energy & Infrastructure
| Company | Guidehouse |
|---|---|
| Location | Washington, DC, USA, Annapolis Junction, MD, USA, McLean, VA, USA, Arlington, VA, USA, Alexandria, VA, USA, Baltimore, MD, USA |
| Salary | $85000 – $141000 |
| Type | Full-Time |
| Degrees | Bachelor’s, Master’s |
| Experience Level | Mid Level, Senior |
Requirements
- 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
Responsibilities
- 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
Preferred Qualifications
- 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