Lead Developer-Modeling, Data and Automation

Lead Developer- Modeling, Data and Automation

Sponsorship for Work Authorization Not Available.

This dynamic role is responsible for developing, maintaining, and enhancing CEI’s proprietary models and databases with a strong emphasis on Python development. The Lead Developer- Modeling, Data and Automation will modernize existing VBA-based models and reports by leading the transition to Python-based solutions. This role involves ensuring the integrity and functionality of CEI’s database systems, implementing automation, and optimizing data workflows. A successful candidate will provide support for existing VBA applications, with a willingness to learn and maintain current developments while managing the organization's transition to Python.

Essential Duties and Responsibilities:

• Software Development & Maintenance – Develop, optimize, and maintain proprietary models, databases, and    reporting tools primarily using Python. Support existing VBA-based models with the goal of transitioning them to    Python.
• Automation & Optimization – Implement automation solutions to streamline data processing, reporting, and decision-making. Develop scripts and applications that improve efficiency and accuracy.
• Data Management & Integrity – Ensure data integrity, accuracy, and accessibility across CEI’s systems. Design and maintain databases, ETL processes, and reporting structures.
• Python Migration Strategy – Lead the strategic transition from VBA to Python-based solutions, ensuring minimal disruption to current operations. Evaluate and recommend best practices for modernizing legacy models.
• Technical Support & Troubleshooting – Act as the primary technical resource for database and model-related    issues. Provide troubleshooting and support for existing models, ensuring smooth functionality.
• Collaboration & Training – Work closely with internal stakeholders to understand requirements and deliver effective    solutions. Provide training and support for team members adopting Python-based models and automation tools.
• IT Coordination – Liaise with IT support vendors and internal teams to address development-related technical issues.
  
  

Knowledge and Skills:

•  Strong proficiency in Python for data analysis, automation, and application development.
•  Experience with SQL for database management and query optimization.
•  Familiarity with VBA (or willingness to learn) to support legacy models and reporting tools.
•  Experience with data processing, ETL pipelines, and reporting automation (Preferably within Power BI).
•  Ability to transition legacy Excel-based models into modern, scalable Python-based solutions.
•  Strong understanding of Microsoft Office tools, especially Excel and Outlook.
•  Well-organized, with strong project management skills and the ability to prioritize development tasks.
•  Excellent problem-solving skills and a proactive approach to identifying and resolving technical challenges.
•  Strong communication skills, with the ability to document processes and provide training as needed.          

Education and Work Experience: 

     • Bachelor’s degree in Computer Science, Information Systems, Data Science, Engineering, or a related field                      preferred.             
     • Minimum of 4 years of experience in Python development, data analysis, and similar technical work 

        responsibilities.
     • Experience in energy, finance, or operations-based industries is a plus but not required.

Benefits:

• Competitive pay
• Medical, dental, vision & prescription drug coverage
• Health Savings Account
• Life insurance & disability
• 401K with company match
• Paid holidays and time off

Learn more about CEI at: https://ecg-llc.com/

CEI participates in E-Verify and will provide the federal government with your Form I-9 information to confirm that you are authorized to work in the U.S.

Sponsorship for Work Authorization Not Available.

All contingent offers are based upon successful completion of our pre-employment verification process.