Energy Consulting Group , LLC
Lead Developer-Modeling, Data and Automation
Energy Consulting Group , LLC, Marietta, Georgia, United States, 30064
Overview
Lead Developer- Modeling, Data and Automation Sponsorship for Work Authorization Not Available. This dynamic role is responsible for developing, maintaining, and enhancing CEIs 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 CEIs 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. Responsibilities
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 CEIs 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. Qualifications
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: Bachelors
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. Learn More Here
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. #J-18808-Ljbffr
Lead Developer- Modeling, Data and Automation Sponsorship for Work Authorization Not Available. This dynamic role is responsible for developing, maintaining, and enhancing CEIs 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 CEIs 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. Responsibilities
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 CEIs 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. Qualifications
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: Bachelors
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. Learn More Here
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. #J-18808-Ljbffr