Opportunities Across HG Ventures' Portfolio Companies
You can help solve the world's biggest problems today.
\n
\n\n\n\n
\n
*Don’t meet every single requirement? Studies have shown that women and people of color are less likely to apply to jobs unless they meet every single qualification. At 120Water we are dedicated to building a diverse, inclusive and authentic workplace, so if you’re excited about this role but your past experience doesn’t align perfectly with every qualification in the job description, we encourage you to apply anyways. You may be just the right candidate for this or other roles.
\n
","datePosted":"2023-02-28T10:04:21.067Z","validThrough":"2024-02-19","employmentType":[],"hiringOrganization":{"@type":"Organization","name":"120Water","description":"120Water is the end-to-end lead management solution designed to ease the compliance burden and optimize the efforts of water systems. Comprised of software, consultative services and sampling kits, 120Water’s solution meets systems where they are, providing a roadmap for lead compliance and program success. Their team of water alumni and technology experts have supported over 7,000 sampling events across the country, partnering with water systems and facilities of all sizes to protect public health and provide clean drinking water to communities.","numberOfEmployees":75,"address":[{"address":{"@type":"PostalAddress","addressLocality":"Zionsville, IN, USA"}}],"sameAs":"https://120water.com","url":"https://120water.com","logo":"https://cdn.getro.com/companies/e337b997-3a23-5730-a726-a10d1c411532","memberOf":{"@type":"Organization","name":"HG Ventures","description":"HG Ventures has the ability to offer emerging companies the right skills and tools to support you on the path of growth and success. Over the years our partners have been leaders of corporate and entrepreneur activities and can attribute themselves to the success of numerous companies. The skills our partners possess ensure we serve our clients with the best possible leadership, business insights and management resources, which provide a perfect platform for your company to grow at an explosive pace. We partner with your company and provide you with our extensive expertise that will in turn develop your company and achieve greater profits. As we have a vested interest in how well your company performs you can rest assured that you get the highest level of service from our advisors. HG Ventures provides equity related finance services for raising capital, company buy outs, decentralizations, IPO's, Mergers, public to private transactions. We also look at the viability of startup companies and conduct full market analysis.","logo":"https://cdn.filepicker.io/api/file/allviG5DSFqjlrhgZz03","url":"portcojobs.hgventures.com"},"keywords":"Energy, Government and Military, Information Technology, Software, Sustainability"},"jobLocation":{"@type":"Place","address":{"@type":"PostalAddress","addressLocality":"Zionsville, IN, USA"}}}
IT, Data Science
Zionsville, IN, USA
Posted on Feb 28, 2023
Details:
Reports To: Lead Data Analyst
Department: Services
FLSA: Exempt
Position Summary:
120Water is seeking a passionate Data Analyst. You will turn data into information, information into insight, and insight into a compliant Lead Service Line inventory (LSLI) by working within the Client Delivery Program Consulting team and collaborating with clients and the Client Success team. You will also execute data analysis for many clients through collaboration with the Program Consultants. Data analysis primarily takes place within R and QGIS, therefore, experience within these programs is integral to the success of a candidate. Data Analysts will report to the Lead Data Analyst.
Responsibilities Include:
- Work with a fellow Program Consultant (PC) and fulfill the role of data analyst for your shared client. Communicate effectively with the PC as you gradually incorporate the client’s data into the 120Water platform. You will also fulfill other data requests for PCs within your capacity.
- Record your work through code and a methodology support document. We are conducting a Lead Service Line Inventory for our clients so all your work must be recorded to provide adequate evidence to meet EPA standards.
- Filter and “clean” data by reviewing customer billing, work order, and other reports and exports, PDFs, and 120Water software exports for locations and asset data.
- Transcribe or review transcriptions of historical data submitted by the client, analyze the data, and incorporate this data into the LSLI.
- Identify and interpret trends or patterns in client data sets that identify areas for lead service line replacement (LSLR) prioritization.
- Stay up-to-date on the EPA’s LSLI guidance and how this affects your ongoing data analysis.
- Create maps in QGIS to show the results of the preliminary inventory review, and to identify future areas for prioritization.
- Interpret data, analyze results using statistical techniques and provide ongoing reports on status of inventory development.
Successful Candidates Will Possess:
- Proven working experience as a Data Analyst or Business Data Analyst.
- Technical expertise in data management, database development, data modeling, and data mining and segmentation techniques.
- In-depth knowledge of and experience with reporting packages, databases (SQL, QGIS etc), and programming (XML, Javascript, etc).
- Knowledge of statistics and experience using data analysis packages for analyzing datasets (Excel, SPSS, SAS, R, etc).
- Two semesters of or work experience with ArcGIS or QGIS.
- Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy.
- Adept at queries, report writing and presenting findings and methodology.
- BS in Mathematics, Economics, Computer Science, Information Management, Statistics or similar.
*Don’t meet every single requirement? Studies have shown that women and people of color are less likely to apply to jobs unless they meet every single qualification. At 120Water we are dedicated to building a diverse, inclusive and authentic workplace, so if you’re excited about this role but your past experience doesn’t align perfectly with every qualification in the job description, we encourage you to apply anyways. You may be just the right candidate for this or other roles.