Benefits:
Competitive pay
Medical, dental, vision & prescription drug coverage
Health Savings Account
Life insurance & disability
401K with company match
Paid holidays and time off
Preferred Education:
4 Year Degree
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.
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.
