For the given job description <<Primary PurposeThe JPI Group is seeking a Business Analyst (BA) to join our rapidly growing team. The successful candidate will provide analytical support for our utility-led energy efficiency incentive programs by collecting, analyzing, and reporting program data. This role will also serve as the programs point of contact with IT Teams to manage, improve and test program databases.
Tasks May IncludeCompile and analyze program and project level data such as energy savings, incentives, and application statusDevelop and run reports, processes, graphs, and dashboards to track key program performance metrics, including forecasting energy savings, tracking budgets and client invoicesDevelop, streamline, document, and automate program processesUtilize group-wide and ad hoc databases for analysis and reportingPerform a critical analysis of program data to identify operational and data anomalies and exceptionsQuickly translate data and accompanying analysis into internal, client, and management presentationsManage and perform quality control on reports and analysesManage backend processes to provide cadence reporting to the client and in-house finance and accounting teamsNotify manager of projected anomaliesPrepare backend data to make ready for other parties to processFollow and enforce QAQC processesAssist with trade ally managementDocument role to ensure continuity of workManage small initiatives to completionContinuous improvement of backend tools and client deliverablesOther tasks as neededWhat were askingBachelors degree in the analytic discipline.Three to Five years of experience compiling and analyzing data and producing data-intensive reportsHigh attention to detail and reporting precisionUnderstanding of and management within large utility-client bureaucraciesA proven and demonstrable grasp of data analysis tools such as Power BI, Oracle, SQL Server, Excel or equivalentHigh Degree of Proficiency with Excel inclusive of Pivot Tables, Data Management Tools, and advanced formulas and functionsDemonstrated analytical abilities to develop and implement resolutions for business challenges and issues.Willingness and ability to travel, via airplane, as required up to approximately 10% of the year.Preferred SkillsFive to Eight Years of energy efficiency experiencePrior experience in market research inclusive of market analysis, market assessment, and market segmentationFamiliarity with energy savings analysis and modeling toolsProficiency in and understanding of accounting concepts (invoicing, accruals, forecasting, etc.)Familiarity with data reconciliation applications (e.g. month-end accounting reconciliations, accruals, inventory reconciliations, etc.)Excellent oral and written communications skillsPrior participation in complex database management system projects. Experience with JIRA is desiredPrior project experience in data mining andor analytics initiativesPro-active approach to the analytical tool and analytical model developmentPositive, collaborative, and team-oriented attitudePassion for energy and sustainability>> the resume: <<Experience10/2019to06/2019Data AnalystAngi Homeservices Inc.–Rockledge,FL,Built an end to end analytics-based solution for animal shelters to verify optimality of current capacity, with a vision to deliver recommendations to improve animal outcomes and health in the future.Created a cloud-based (AWS/Flask/HTML) UI to source animal shelter data & present optimal solution.Utilized Delphi method to generate synthetic data (for missing values) using information from animal experts.Leveraged SQL/Python to pre-process and optimize animal shelter data.Dealt with a tricky client, with unclear outcomes (and impacted by COVID-19 times) - yet delivered a complete, extendable analytics/ UI solution.Predicted the outcome of animals with 73% accuracy, based on characteristics of the animals at the time of intake.01/2019to06/2019AnalystAmeresco–Half Moon Bay,,INDTraders of import export licenses in India, Operationalized and negotiated the prices/rate of various MEIS/SEIS by predicting the price of the MEIS/SEIS licenses using Time-series analysis and supervised machine learning model, resulting in savings of INR 1,000,000.Created a new billing system from scratch to increase efficiency and reduce time spent in creating bills using Excel, VLOOKUP, HLOOKUP and Formulas, which resulted in time spent in creating bills reducing by 50.06/2018to09/2018Analyst InternSpencer Stuart–Chicago,,INDAlthough junior, quickly earned responsibility for creation of data architecture & automation for BSE's Mutual Funds.Processed 1 million+ weekly transactions to enable audits, executive reporting - Presented to CXOs weekly.
EducationExpected inJuly 2018totoBachelor of Engineering:Information TechnologyUniversity of Mumbai, Vidyalankar Institute of Technology-Mumbai,GPA:Expected inJunetotoMaster of Science:Business AnalyticsUniversity of California-San Francisco,CAGPA:
SummaryA motivated data enthusiast with 5+ years of SQL and data analysis experience, 3+ years of Object-Oriented Programming experience and 2+ years of Python and R experience. Self-taught Machine Learning and Big Data and applied to various settings by taking 3 Coursera Courses, 3 Udacity Courses, 2 Udemy Courses and am an AWS Certified Cloud Practitioner. Motivated to make a difference and hence currently analyzing publicly available animal shelter data.
HighlightsTools: SQL, Python, Jupyter Notebook, Flask, R, Tableau, Spark, MongoDB, Excel, HTML, MapReduceSkills: A/B Testing, Data Analysis, Database Management, Data Mining, Data Visualization, Hypothesis Testing, Modeling, Machine Learning, Statistical Analysis, DashboardsAutomationBilling systemClientData AnalysisData MiningData VisualizationDatabase ManagementDelphiFundsHTMLMachine LearningExcelModelingMongoDBPythonReportingSQLStatistical AnalysisTableauVision
SkillsTools: SQL, Python, Jupyter Notebook, Flask, R, Tableau, Spark, MongoDB, Excel, HTML, MapReduceSkills: A/B Testing, Data Analysis, Database Management, Data Mining, Data Visualization, Hypothesis Testing, Modeling, Machine Learning, Statistical Analysis, Dashboards,Automation, billing system, client, Data Analysis, Data Mining, Data Visualization, Database Management, Delphi, Funds, HTML, Machine Learning, Excel, Modeling, MongoDB, Python, reporting, SQL, Statistical Analysis, Tableau, vision>>. The result is, No Fit

Fit assessment: No Fit