Guidehouse, a "next-generation consultancy" and a portfolio company of Veritas Capital, provides management, risk consulting, and technology services to help cl
Technical Celonis Developer
Location
Ohio
Posted
16 days ago
Salary
$135K - $225K / year
Seniority
Senior
Job Description
Technical Celonis Developer
Guidehouse
• Develop and maintain Celonis integrations, including ETL (Extract, Transform, Load) pipelines and data connectors, leveraging SQL, Python, and the Celonis Platform. • Lead the design, development, and implementation of data models and ETL solutions to integrate functional data into Celonis. • Build process intelligence solution views, analyses, and dashboards to enable actionable insights for clients. • Design and implement scalable data ingestion processes from ERP systems and third-party applications. • Ensure reliable and secure connections to source systems using technologies such as JDBC for database connectivity and Kafka for real-time data streaming. • Perform ETL operations, troubleshoot data connections, and validate large datasets for accuracy and performance. • Optimize Celonis data models and ETL processes for performance and scalability. • Design, develop, and implement audit processes to ensure data integrity from application platforms to Celonis. • Govern access rights for Celonis processes and maintain operational support for the Celonis production platform. • Collaborate with clients, Celonis teams, and third-party resources to align technical delivery with project goals. • Participate in workshops, demos, and client-facing sessions to showcase technical capabilities. • Facilitate and lead the establishment of governance and Process Intelligence best practices. • Provide ongoing support to business and technology teams to ensure continuous improvement.
Job Requirements
- A MINIMUM of FOUR (4) years of overall system development experience, with at least 4 years hands-on in Celonis or process mining tools
- Strong understanding of process mining methodologies, process improvement frameworks, and business process management (BPM).
- Strong proficiency in SQL and PL/SQL (must-have), Python, and data modeling.
- Expertise in ETL processes for data extraction and transformation.
- Proven experience with Celonis features and capabilities, including data model optimization.
- Ability to interpret complex data and deliver meaningful business insights.
- Excellent communication and interpersonal skills with a strong collaboration mindset.
Benefits
- Medical, Rx, Dental & Vision Insurance
- Personal and Family Sick Time & Company Paid Holidays
- Parental Leave
- 401(k) Retirement Plan
- Group Term Life and Travel Assistance
- Voluntary Life and AD&D Insurance
- Health Savings Account, Health Care & Dependent Care Flexible Spending Accounts
- Transit and Parking Commuter Benefits
- Short-Term & Long-Term Disability
- Tuition Reimbursement, Personal Development, Certifications & Learning Opportunities
- Employee Referral Program
- Corporate Sponsored Events & Community Outreach
- Care.com annual membership
- Employee Assistance Program
- Supplemental Benefits via Corestream (Critical Care, Hospital Indemnity, Accident Insurance, Legal Assistance and ID theft protection, etc.)
Related Guides
Related Job Pages
More Software Engineer Jobs
Automotive Mechanical Engineering Workflow Specialist
24-MAGThis opportunity is available through a leading AI-driven work platform.
Role Description We are sharing a specialised part-time consulting opportunity for professionals experienced in automotive mechanical engineering, vehicle design, manufacturing engineering, CAE/CAD workflows, automotive quality systems, and structured engineering documentation. This role supports current and upcoming remote consulting opportunities focused on structured automotive engineering review, vehicle and subsystem documentation, manufacturing workflow analysis, quality documentation, simulation review, and high-quality project execution. Selected professionals will apply their automotive engineering expertise to review realistic technical scenarios, evaluate engineering requirements, prepare structured written outputs, and support accurate, evidence-based automotive workflow tasks. Key Responsibilities - Vehicle Design & Mechanical Engineering Review - Review automotive engineering scenarios involving vehicle design, subsystem design, body, chassis, interior, powertrain, thermal systems, EV systems, battery components, or ADAS-related engineering workflows. - Evaluate design review materials against source documentation, technical requirements, tolerance expectations, and expected engineering outcomes. - Support structured review of benchmarking decks, CAD-related materials, design documentation, test reports, and vehicle engineering workspaces. - Identify missing assumptions, documentation gaps, design inconsistencies, and expected automotive engineering review outcomes. - CAE, Simulation & Manufacturing Workflow Support - Review CAE, CAD, and simulation scenarios involving structural analysis, NVH, CFD, durability, tolerance analysis, and manufacturing feasibility. - Evaluate manufacturing engineering materials involving stamping, body-in-white, assembly, paint, process documentation, and production workflows. - Support structured review of materials connected to ANSYS Fluent, STAR-CCM+, Siemens Opcenter, Rockwell FactoryTalk, SAP S/4HANA, or similar automotive engineering systems. - Prepare clear written explanations for automotive engineering decisions based on source materials and verifiable technical criteria. - Automotive Quality & Program Documentation - Review automotive quality scenarios involving DFMEA, PFMEA, APQP, PPAP packages, IATF 16949 documentation, test reports, and quality records. - Evaluate quality and program materials against documented requirements, engineering standards, test expectations, and manufacturing controls. - Support structured review of tolerance analyses, validation reports, quality documentation, design reviews, and cross-functional engineering records. - Maintain accuracy, consistency, and professional judgment across submitted work. Qualifications - 3+ years of experience in automotive mechanical engineering, vehicle engineering, subsystem design, manufacturing engineering, process engineering, CAE/CAD, simulation, automotive quality, EV engineering, battery engineering, ADAS engineering, or related technical roles. - Experience in automotive OEM, Tier-1 supplier, mobility, transportation manufacturing, or related vehicle engineering environments. - Background in one or more areas such as body, chassis, interior, powertrain, thermal systems, structural analysis, NVH, CFD, durability, stamping, body-in-white, assembly, paint, APQP, PPAP, DFMEA, PFMEA, EV, battery, or ADAS workflows. - Familiarity with tools and systems such as ANSYS Fluent, STAR-CCM+, Siemens Opcenter, Rockwell FactoryTalk, SAP S/4HANA, CAD/CAE platforms, PLM tools, or similar automotive engineering systems. - Comfort reading and preparing automotive artifacts such as design reviews, DFMEA/PFMEA documents, PPAP packages, tolerance analyses, benchmarking decks, test reports, quality records, and technical summaries. - Strong analytical thinking and written communication skills. - Ability to translate automotive engineering workflows into clear, structured task documentation. Educational Background - Bachelor's or master's degree in mechanical engineering, automotive engineering, manufacturing engineering, industrial engineering, systems engineering, electrical engineering, or a related technical field is helpful. - Equivalent practical experience in automotive engineering, vehicle design, manufacturing workflows, automotive quality, simulation, or technical documentation review is also highly relevant. Nice to Have - Experience at an automotive OEM, Tier-1 supplier, vehicle systems company, EV company, or automotive manufacturing organization. - Familiarity with IATF 16949, APQP, PPAP, DFMEA, PFMEA, CAD/CAE, tolerance analysis, manufacturing transfer, validation testing, or program launch workflows. - Experience preparing or reviewing design review decks, tolerance analyses, DFMEA/PFMEA files, PPAP packages, benchmarking materials, validation reports, or automotive quality documentation. - Familiarity with EV, battery, ADAS, thermal systems, powertrain, chassis, interior, body engineering, or manufacturing process development. - Strong attention to detail in technical, manufacturing-heavy, and documentation-heavy automotive environments. Why This Opportunity - Apply automotive mechanical engineering expertise to structured remote project work. - Contribute to high-quality automotive workflow review, design documentation, simulation assessment, and manufacturing scenario development. - Work on flexible, project-based assignments aligned with your automotive background. - Use your engineering judgment in a focused, detail-oriented technical environment. - Remote structure with competitive hourly compensation. Contract Details - Independent contractor role. - Fully remote with flexible scheduling. - Part-time commitment depending on project availability. - Competitive rates between $50–$75 per hour depending on expertise. - Weekly payments via Stripe or Wise. - Projects may be extended, shortened, or adjusted depending on scope and performance. - Work will not involve access to confidential or proprietary information from any employer, client, or institution. About the Platform This opportunity is available through 24-MAG LLC. We connect experienced professionals with remote consulting opportunities across technical, evaluation, and project-based workstreams. By submitting this application, you acknowledge that your information may be processed by 24-MAG LLC for recruitment and opportunity matching in accordance with our Privacy Policy: https://www.24-mag.com/privacy-policy .
Senior PL/SQL Developer
LucyRxLucyRx is an independent, next-generation pharmacy benefits manager (PBM) transforming how healthcare works. We’re fixing what’s broken in the PBM industry by putting people first and challenging outdated norms. For too long, traditional PBMs have prioritized profit over patients, and we believe that’s just plain wrong. LucyRx offers bold, innovative solutions powered by LucyIQ, our proprietary AI platform, to deliver actionable insights that lower costs, improve care, and simplify prescription management. While we’re new to the PBM space, LucyRx is built on decades of leadership experience and a commitment to meaningful change. We’re a nimble, remote-first team with a bold mission to redefine pharmacy benefits—and we’re just getting started.
Role Description We are seeking a highly skilled Senior PL/SQL Developer to join our team. The ideal candidate will have extensive experience with Oracle databases and PL/SQL programming, with a strong focus on database development and cloud migration. You will be responsible for designing, developing, and optimizing PL/SQL solutions while contributing to the migration of Oracle databases to cloud platforms such as Oracle Cloud, AWS RDS, or Azure SQL Database. - Design, develop, and optimize PL/SQL code for Oracle databases. - Implement database triggers, stored procedures, functions, packages, and views. - Perform performance tuning and query optimization to improve database efficiency. - Assist in the migration of Oracle databases to cloud platforms, ensuring minimal disruption and maximum efficiency. - Develop and maintain ETL processes to support data integration and reporting. - Collaborate with cloud architects, DevOps engineers, and business analysts to define migration strategies and best practices. - Ensure data integrity, security, and compliance with company and industry standards. - Troubleshoot and resolve database-related issues in both on-premises and cloud environments. - Develop and maintain documentation for database processes, cloud migration strategies, and coding standards. Qualifications - Bachelor's or master's degree in computer science, Information Technology, or a related field. - 6+ years of experience as a PL/SQL Developer working with Oracle databases. - Strong proficiency in writing complex SQL queries, stored procedures, functions, and packages. - Experience with performance tuning, query optimization, and database indexing. - Familiarity with data modeling, normalization, and database design principles. - Hands-on experience with database migration to cloud environments (e.g., Oracle Cloud, AWS RDS, Azure SQL Database). - Knowledge of Oracle tools such as SQL*Loader, Data Pump, and Oracle SQL Developer. - Understanding of database security, roles, privileges, and access control. - Excellent problem-solving, analytical, and troubleshooting skills. - Strong communication and collaboration skills. - 3+ years experience in the following technologies: .NET; Oracle Forms/Reports, Crystal Reports, or similar reporting tools; JavaScript, HTML, CSS; Web Services; MS Visual Studio, Toad, APEX; XML, JSON. Requirements - Experience with Oracle 12c/19c and advanced features. - Exposure to cloud-based databases and migration tools. - Familiarity with Agile methodologies and DevOps practices. - Experience with scripting languages such as Shell, Python, or Perl for automation. - Knowledge of Oracle APEX for front-end application development. Benefits - Oracle certification. - Experience working with PBM, managed care organizations or integrated delivery networks. Physical Requirements The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. - This is a largely sedentary role; however, some standing, walking, bending, and reaching may be required. - Regularly operates in an office or home office setting which involves utilizing a computer, mouse, keyboard, and occasionally operates other standard office equipment, such as printer, copier, phone. - Travel may be required by either car or airplane, or a combination of multiple modes of transportation. Salary $100,400 - $117,660
Role Description You are required to: - Communicate directly with team members of various roles, such as blockchain developers, game designers, and artists. Good communication skills and eagerness to problem solve in a collaborative manner is a huge plus. - Design and build game systems with scalable architecture in mind. - Implement and maintain game components that are well optimized and reusable. - Have the ability to convert design concepts or requirements into functional game features and integrate them seamlessly into the game. - Have a sense of ownership of what you are building and a no-compromise attitude towards quality of work. Requirements - English language proficiency. - At least 1 year of professional experience in software development with Unity3D. - Good knowledge of Unity3D and dealing with standard work processes such as scripting and animation. - Familiar with level design, camera, textures, and GUI implementation for isometric environments/maps. - Experience with application of game physics. - Experience with mobile game development. - Knowledge of best practices for system architecture.
Role Description We are looking for a Python Developer to join our engineering team and help us develop and maintain various software products. Python Developer responsibilities include: - Writing and testing code - Debugging programs - Integrating applications with third-party web services - Building highly responsive web applications that align with our business needs Responsibilities - Write effective, scalable code - Develop back-end components to improve responsiveness and overall performance - Integrate user-facing elements into applications - Test and debug programs - Improve the functionality of existing systems - Implement security and data protection solutions - Assess and prioritize feature requests - Coordinate with internal teams to understand user requirements and provide technical solutions Qualifications - Work experience as a Python Developer - Expertise in at least one popular Python framework (like Django, Flask or Pyramid) - Knowledge of object-relational mapping (ORM) - Familiarity with front-end technologies (like JavaScript and HTML5) - Team spirit - Good problem-solving skills - BSc in Computer Science, Engineering or relevant field

