Technical Data Analyst

3 weeks ago


Minneapolis, United States Center for Energy and Environment Full time

Description

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) #J-18808-Ljbffr



  • Minneapolis, Minnesota, United States Center for Energy and Environment Full time

    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...


  • Minneapolis, Minnesota, United States Center for Energy and Environment Full time

    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...

  • Data Analyst

    6 days ago


    Minneapolis, United States C4 Technical Services Full time

    Data Analyst - Privileged Access Remediation Location: Remote Position Overview: The Data Analyst will play a crucial role in supporting privileged access remediation efforts within our Cybersecurity Operations team, with a focus on leveraging data analysis techniques to identify and address security risks associated with privileged accounts and access in...


  • Minneapolis, United States C4 Technical Services Full time

    Workday Testing and Data Conversion Analyst Location: Remote Lead and execute testing and data conversion activities for assigned functional area in support of Workday deployment. They will create and execute test scripts for assigned functional area (focus will be primarily Time & Absence, with potential secondary support in payroll space) Coordinate End...

  • Data Analyst

    2 months ago


    Minneapolis, United States Wipro Limited Full time

    We are seeking a Sr. Data Analyst to join our Consumer Data Strategy and Operations Team. In this role you will leverage your technical expertise and passion for big data to integrate and establish leading SaaS and analytics solutions that advance consumer data capture & management across mobile and web. You will work closely with the Marketing Engagement...

  • Data Analyst

    2 months ago


    Minneapolis, Minnesota, United States Wipro Limited Full time

    We are seeking a Sr. Data Analyst to join our Consumer Data Strategy and Operations Team. In this role you will leverage your technical expertise and passion for big data to integrate and establish leading SaaS and analytics solutions that advance consumer data capture & management across mobile and web. You will work closely with the Marketing Engagement...

  • Data Analyst

    6 days ago


    Minneapolis, United States Diverse Lynx Full time

    Title: Data Analyst Location: Minneapolis/Remote Type : Contract Job Description: Technical/Functional Skills Main skills: Editing, writing, and running Oracle SQL scripts. ble to analyze data to help troubleshoot issues and optimize processes. Requires an analytical mindset with an attention to detail as well as the ability to communicate...

  • Data Analyst

    3 weeks ago


    Minneapolis, United States Randstad USA Full time

    job summary: Required: 10+ years of Oracle Database experience.5+ years of experience with data warehouses/marts supporting business requirements5+ years of advanced PL/SQL and SQL experience5+ years of UNIX command prompt navigation, including VI editor- (Shell Scripts)5+ years of experience working with healthcare data, to include 2+ years with Claims...

  • Data Analyst

    2 weeks ago


    Minneapolis, Minnesota, United States Randstad USA Full time

    job summary: Required: 10+ years of Oracle Database experience.5+ years of experience with data warehouses/marts supporting business requirements5+ years of advanced PL/SQL and SQL experience5+ years of UNIX command prompt navigation, including VI editor- (Shell Scripts)5+ years of experience working with healthcare data, to include 2+ years with Claims...

  • Data Analyst

    3 weeks ago


    Minneapolis, Minnesota, United States Randstad USA Full time

    job summary: Required: 10+ years of Oracle Database experience.5+ years of experience with data warehouses/marts supporting business requirements5+ years of advanced PL/SQL and SQL experience5+ years of UNIX command prompt navigation, including VI editor- (Shell Scripts)5+ years of experience working with healthcare data, to include 2+ years with Claims...


  • Minneapolis, United States Russell Tobin Full time

    What are we looking for in our SDoH Business Analyst/Data Analyst? Title: SDoH Business Analyst Location: Minneapolis, MN (Remote) Duration: 9 Months (CTH) Pay Range: $40/hr to $45/hr (As per experience) Summary: This is a telecommute role, which will support the acquisition of SDOH data, integration of that data into our SDOH platform, and sharing the data...

  • CRM Data Analyst

    2 weeks ago


    Minneapolis, United States Virtual Full time

    CRM Data AnalystPosition Objective The CRM Data Analyst manages the overall quality of contact and engagement data in the company’s CRM and knowledge management platform.  This individual will be entering, reviewing, verifying, and standardizing data from end users and integrated applications. Additional tasks will be running proactive data quality...


  • Minneapolis, United States Resource Informatics Group Full time

    Job Description Job Description Position: Technical Business Analyst (Please check if they have red marked skills before sharing the resume) Location: Minneapolis, MN Duration: Long Term Visa:-Any Interview:-Video/Skype Job Description:- • Someone who knows how to query MongoDB. •Exp with MongoDB Compass (connect to UI) •Understand data...


  • Minneapolis, United States Russell Tobin & Associates Full time

    What are we looking for in our SDoH Business Analyst/Data Analyst? Title: SDoH Business Analyst Location: Minneapolis, MN (Remote)  Duration: 9 Months (CTH)  Pay Range: $40/hr to $45/hr (As per experience)   Summary: This is a telecommute role, which will support the acquisition of SDOH data, integration of that data into our SDOH...


  • Minneapolis, United States Russell Tobin Full time

    What are we looking for in our SDoH Business Analyst/Data Analyst? Title: SDoH Business Analyst Location: Minneapolis, MN (Remote) Duration: 9 Months (CTH) Pay Range: $40/hr to $45/hr (As per experience) Summary: This is a telecommute role, which will support the acquisition of SDOH data, integration of that data into our SDOH platform, and...


  • Minneapolis, United States Resource Informatics Group Inc Full time

    Job DescriptionJob DescriptionPosition: Technical Business Analyst (Please check if they have red marked skills before sharing the resume)Location: Minneapolis, MNDuration: Long TermVisa:-AnyInterview:-Video/SkypeJob Description:-• Someone who knows how to query MongoDB.•Exp with MongoDB Compass (connect to UI)•Understand data models.•Understand...


  • Minneapolis, United States Resource Informatics Group Inc Full time

    Job DescriptionJob DescriptionPosition: Technical Business Analyst (Please check if they have red marked skills before sharing the resume)Location: Minneapolis, MNDuration: Long TermVisa:-AnyInterview:-Video/SkypeJob Description:-• Someone who knows how to query MongoDB.•Exp with MongoDB Compass (connect to UI)•Understand data models.•Understand...


  • Minneapolis, United States Concord Full time

    Concord isn't your typical consulting firm; we are an execution company with a passion for making things happen. Our mission is to help clients enhance customer experiences, optimize operations, and revolutionize their product offerings through seamless integration, optimization, and activation of technology and data. We are looking to add a Business...

  • Senior Data Analyst

    2 weeks ago


    Minneapolis, Minnesota, United States Gravie Full time

    Hi, we're Gravie. Our mission is to improve the way people purchase and access healthcare through innovative, consumer-centric health benefit solutions that people can actually use. Our industry-changing products and services are developed and delivered by a diverse group of unique people. We encourage you to be your authentic self - we like you that way. A...

  • Senior Data Analyst

    1 month ago


    Minneapolis, Minnesota, United States Gravie Full time

    Hi, we're Gravie. Our mission is to improve the way people purchase and access healthcare through innovative, consumer-centric health benefit solutions that people can actually use. Our industry-changing products and services are developed and delivered by a diverse group of unique people. We encourage you to be your authentic self - we like you that way. A...