Data Analyst

Company: ACS Solutions
Location: Petaluma
Posted on: January 11, 2022

Job Description:

Please Contact Aparna Ghosh at (925) 627 4984 or email at Title: Sr. Data Analyst Location: Remote Required Skills and EducationBachelor's degree in a STEM or business-related discipline.Master's degree, or equivalent work in data science, statistics, business, or mathematics strongly preferred.Advanced capability with Excel, with understanding of arrays, macros, and formula optimization.Ability to code measures (in DAX) and build compelling visualizations in Power BIHigh proficiency with PowerPoint and adjusting graphical layout for polished presentations.2 - 4 years' experience with data modeling, and sensitivity and what-if analysis required.Computer programming experience preferred, among: SQL, R, Python, Java, API calls, or VBAAdvanced experience with Salesforce reporting, dashboards, and workflow development.Excellent written and verbal communication skills, particularly with technical information; strong interpersonal skills.Outstanding attention to detail, strong analytical and problem-solving skills.Ability to articulate a positive vision when undesired outcomes arise.Writes in a clear, concise, and convincing manner for the intended audience.Self-directed, highly independent, and excellent time management and organizational skills. Key ResponsibilitiesAbility to quickly grasp large data sets and manipulate them for desired outcomes.Ability to identify and digest problems, weighing the relevance and accuracy of available information, then drive solutions across a dynamic stakeholder base.Proactively determine and communicate alternative solutions to undesirable outcomes.Research data and site issues and perform quality assurance to validate results.Utilize Excel to create and manipulate arrays, macros, queries, power pivot, and formula optimization.Uncover and investigate process improvements and analysis approaches.Perform ad hoc analyses and support the Hydro-Analysis team as needed.Provide feedback to Product Management regarding bugs, product & process improvement, QA & system validation.Provide live analysis expertise and decision-making support to HA Team, Sales, Executives, CSS for Account and Site savings outcomes, on phone or MS Teams calls with clients.Be a team player who will collaborate with HA, Sales, CSS, and Engineering Development teams.Develop and utilize analysis models in Power BI, connected to multiple database inputs.Process and prepare customer historical water use and cost data analysis to estimate savings.Use Salesforce to track and process analysis requests from Sales and Customer Success teams.Import/Export bill, budget, and other vital data to/from WeatherTRAK systems. Additional Experience that would be a plusKnowledge of landscape irrigation requirements, basic water management best practices.Experience with water utility bill processing or analysis.Geographic Information Systems (GIS) experience using Google Earth Pro, ArcGIS, or the like.Other data visualization applications, such as Tableau, Google Data Studio. -- --- - -ContactCompanyCandidateIdeal JobsMatch a Job Add in JobDiva Match Back CloseSaving Record to JobDiva... Close

Keywords: ACS Solutions, Petaluma , Data Analyst, Professions , Petaluma, California