We are seeking a driven person that is motivated by our mission to discover and deploy the most effective strategies that reduce energy and carbon emissions. This person will join our IT team but primarily work for CEE’s Market Transformation Team. The Market Transformation Team is responsible for scoping, designing, and implementing a portfolio of emerging technology initiatives, to accelerate the adoption of new energy efficient technologies in Minnesota.

The Technical Data Analyst will be responsible for developing data intake and organization processes and managing the wrangling of large data sets. The analyst will support the calculation of the energy savings for each market transformation initiative, as well as tracking progress and forecasting trends.

The ideal candidate will have a passion for creating and managing data pipelines. They will be able to develop data intake processes and collaborate with the Market Transformation team to develop and implement methods to forecast sales trends for the state of Minnesota. They will have a team-oriented approach, be agile, and goal oriented as they implement data cleaning, validation, and a variety of other tasks needed to support the Market Transformation team.

Background:

CEE is a data-driven, consumer-focused, and community-based clean energy nonprofit with locations in the North Loop of Minneapolis and St. Paul's Midway. For nearly 40 years, CEE has collaborated with utilities, governments, nonprofits, and businesses to deliver actionable research and innovative programs that reduce energy waste and harmful emissions. We have established a national reputation for innovation and excellence in program implementation, emerging technology and field research, local and state policy work, and our work with communities. We collaborate regularly with partners and employ curious people who share a passion for the organization’s mission. Our workplace invites open door communications, respect for diverse backgrounds and points of view, and an emphasis on work-life balance. Our organizational culture is professional but easy-going, with a deep emphasis on collaboration, innovation, and technical expertise. We are proud to operate in Minnesota, a national leader in clean energy and energy efficiency. While we prefer someone in or willing to relocate to Minnesota for this position, we are open to employing an exceptional candidate from out of state for remote employment.

CEE launched the Market Transformation program in 2023, with committed and growing funding from the State of Minnesota and its utilities. This program accelerates and rapidly scales the development and adoption of emerging energy efficiency and decarbonization technologies, including workforce efforts. The Technical Data Analyst will report to the Director of IT and may support projects across the organization but will primarily work with the MT team at CEE.

Responsibilities

• Help develop and implement the team’s overall data architecture strategy.

• Develop processes for managing datasets provided by external partners.

• Write scripts using python/R or other programming languages to clean and enrich data.

• Design repeatable processes to combine raw or unstructured data from multiple sources into clean, searchable data sets housed in relational databases.

• Build and maintain simple data models.

• Implement data validation and QA/QC processes to ensure integrity of datasets.

• Collect, organize, analyze, and visualize program and energy data.

• Use modeling tools and/or software to estimate annual sales and energy use of energy efficient technologies. Maintain and iterate on existing tools to improve functionality.

• Create documentation for databases and processes such as schema diagrams, workflows, data dictionaries.

• Teach teammates how to use software programs to query and visualize data.

• Partner with Market and Data Analysts to build solutions to inform analysis, reporting and insights.

• Facilitate conversations with cross functional teams to understand reporting, data intake, and data cleaning needs; build queries and views to support these needs.

• Coordinate with IT staff to ensure infrastructure and performance needs are met.

• Coordinate with Senior Management, IT staff, and external partners to ensure data security protocols are properly implemented.

• Other duties as assigned or apparent

Qualifications

• Bachelor’s degree in computer science, information systems, data analytics, or similar field. Bachelor’s degree may be replaced by equivalent years of experience in a relevant field.

• Minimum 2-4 years’ experience with Python and SQL processing data.

• Minimum 2-4 years’ experience building a database in SQL.

• Experience with PostgreSQL, Microsoft Azure, Power BI, Tableau, and R a plus.

• Experience organizing large data sets with limited guidance.

• Basic knowledge or interest in energy efficiency and decarbonization a plus.

• Basic knowledge of Data Engineering a plus.

• Excellent written and verbal communication, and interpersonal skills.

• Exceptional ability to craft clear and compelling deliverables.

• Ability to work effectively in cross-functional teams and on a variety of tasks.

• Exceptional organization and time management skills and the ability to prioritize.

Compensation

Depending upon qualification and experience.

Equal Opportunity Employer

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities

The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor’s legal duty to furnish information. 41 CFR 60-1.35(c)