Data Analyst

Data Analyst | Fort Washington, PA                         

CMC Energy is passionate about making the world more energy efficient; ensuring a cleaner, healthier environment for this and future generations. For the past 40 years, we have worked hard to not only save energy, but also to save our customers money.

If you are interested in working for a company in an exciting growth industry, doing meaningful work while connecting and building relationships with a diverse group of clients, we are interested in hearing from you!

CMC Energy is committed to investing in our employees; believing that if our employees are happy, our customers will be happy and our company will thrive. We offer excellent career opportunities, training and development programs, employee recognition and innovation awards, competitive pay and incentives, and an attractive benefits package.

Learn more about story: https://youtu.be/4UhMnmcEkXw

Check us out at: www.cmcenergy.com

Summary:

The Data Analyst monitors and collects data for various projects using database and spreadsheet software for Operations. This individual is also responsible for reconciling subcontractor work completed for integrity and accuracy based on program guidelines.

Essential Functions:

1. Ensure high quality data is collected and maintain integrity of the data.
2. Analyze and evaluate data to identify outliers and patterns.
3. Create and implement reports for users to identify, review and correct outliers.
4. Develop and prepare data that can be used for data analysis, presentation and reporting.
5. Identify database design changes needed to improve efficiency and accuracy of the data.
6. Prepare and reconcile program data for daily, weekly, monthly, yearly processing for program.
7. Test new data capabilities in the ERMS System (Energy Reduction Management System).
8. Run scheduled and special reports, correspondence, spreadsheets, and presentations.
9. Develop and maintain procedural manuals.
10. Prepare invoicing and savings reports as needed.
11. Train subcontractors on ERMS, other programs and how to invoice CMC for completed work.
12. Prepare data weekly for export to Client servers.
13. Conduct work in compliance with OSHA and company safety procedures.
14. Perform other duties as assigned.

Job Qualifications:

1. High school diploma or equivalent required. Associate’s degree preferred.
2. SQL Server and SSRS knowledge to include creating and scheduling complex SQL queries. Microsoft MCSA: SQL Server 2012/2014 certification a plus.
3. Strong organizational, project management, problem solving and prioritization skills necessary.
4. Ability to collaborate with Senior Leadership on all topics related to program data, including the ability to obtain consensus, approval and manage projects through to implementation.
5. Advanced knowledge of Microsoft Office Suite, including Access.
6. Ability to communicate clearly and effectively, in speech and writing, with customers, staff, managers, supervisors, contractors and clients.
7. Resourcefulness to meet tight deadlines and flexibility with fluctuating priorities.
8. Ability to handle confidential information with the highest level of integrity and ethics.
9. Although this position is based in Fort Washington, PA, travel to other offices may be occasionally required.
10. Perform the essential functions and physical demands of the position with or without accommodation.

Physical Requirements:

1. Consistently spending time sitting, typing, talking, walking and using repetitive motion.
2. Frequent use of eye, hand, and finger coordination enabling the use of automated office machinery, such as a computer.
3. Oral and auditory capacity enabling interpersonal communication as well as communication through automated devices such as the telephone.
4. Visual capacity enabling frequent use of computer equipment.
5. Medium work: ability to exert up to 50 pounds of force occasionally, and/or up to 30 pounds of force frequently and/or up to 10 pounds of force constantly to lift, carry, push, pull or otherwise move objects.

Equal Employment Opportunity

CMC Energy Services encourages diversity and provides equal employment opportunities to all qualified individuals without regard to race, creed, color, religion, national origin, age, sex, marital status, sexual preference or non-disqualifying physical or mental handicap or disability in each aspect of the human resources function.