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: <<SummaryDetail oriented and team focused epidemiologist with 8 years of experience working as an epidemiologist and statistician for public health agencies.
SkillsStatistical Analysis and Coding: SAS, R, SQL, EpiInfoData Visualization: Tableau, Arc GISMicrosoft Suite: Excel, Access, Word
Experience07/2021toCurrentEpidemiologist/Data AnalystCalifornia Department Of Public Health–City,STATE,Current epidemiologist on the Epidemiology and Surveillance Team within the COVID-19 California Department of Public Health (CDPH) response responsible for maintaining and providing case-based surveillance and epidemiologic data for COVID-19 cases in the state of California.Generated daily and weekly reports identifying COVID-19 trends including case rates, death rates, test positivity and health equity measures.Monitored data quality of death, duplicate, and reinfection data and worked with individual counties and other partners.Led efforts to create a process for deduplicating COVID-19 reinfection data by working closely with the data team and responding to feedback from individual counties.Assigned to the MPOX emergency response for 8 weeks and produced daily reports and visualizations using SAS and R. Led efforts to improve on LGBTQIA+ representation in data.Created a staff roster using SAS from several different teams on the emergency COVID-19 response. Combined multiple datasets and created a new dataset with unique variable key.Assisted with coding of COVID-19 racial equity analyses in SAS.12/2017to07/2021Research Statistician IVHawaii Department Of Health–City,STATE,Developmental Disabilities Division's research statistician responsible for submitting annual reports to national agencies, consulting on data needs, assisting in division's new IT project, and providing data quality control.Analyzed variety of data sources including fiscal data, Medicaid claims, and demographic data.Coordinated efforts to transition entire division to new database system. Trained staff on data analysis concepts and methods, and use of Microsoft Excel and new system.Recommended data quality improvement policies and standards.Assisted with legislative reports and generated frequent data reports to Division Director.Lead of PPE Distribution efforts to providers across the state of Hawaii during COVID-19 pandemic when the division was assigned responsibility for allocating donated PPE. Allocated millions of units of PPE across hundreds of providers by analyzing needs versus requests. Coordinated hundreds of allocations with donors, distribution centers, and organizations.07/2017to12/2017Research Statistician IIIHawaii State Hospital–City,STATE,Research statistician for the Department's Maternal and Child Health BranchCollected and analyzed data from reproductive health care providers around the state and produced weekly reports using Microsoft Access & Excel.Assisted supervisor in providing data for annual grants.Submitted a poster that was accepted for a national maternal and child health conference.07/2015to07/2017Epidemiology FellowCSTE/Hawaii Department Of Health–City,STATE,Two year epidemiology fellowship through the Council of State and Territorial Epidemiologists, funded through CDC and assigned to Hawaii Department of Health.Provided epidemiological support for maternal and child health capacity in Hawaii.Developed multiple research projects for adolescent health, injury prevention, teen births, and infant mortality.Proficient analysis of multiple data sources: Behavioral Risk Factor Surveillance System, Youth Risk Behavior Survey, Pregnancy Risk Assessment Monitoring System, Vital Statistics, Medicaid claims data using SAS.Produced reports for grant applications and legislative briefings.Developed surveys for different audiences and evaluated surveillance systems.Participated in Hawaii Dengue outbreak investigation in 2015.Presented oral sessions and posters at national and statewide conferences, trainings, and workshops.Mentored graduate student interns working on oral health.Evaluated programs and projects and received opportunity to attend national program evaluation training.
Education and TrainingExpected in05/2015totoMasters of Public Health:EpidemiologyUniversity of Georgia-Athens, GA,GPA:UGA Dual Degree Program: obtaining masters and bachelors degrees within 4 yearsCoursework: clinical epidemiology, modeling infectious disease (PhD course), biostatistics, environmental health, health policy, clinical trials, and health promotion and behavior3.9 GPAExpected in05/2015totoBachelor of Arts:International AffairsUniveristy of Georgia-Athens, GA,GPA:Honors International Scholar 2014Zell B. Miller Scholarship Recipient 2011-20153.9 GPA>>. The result is, Good Fit

Fit assessment: Good Fit