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: <<SummaryLogical Data Analyst skilled in requirement analysis, software development and database management. Self-directed and proactive professional with 5 years of vast experience collecting, cleaning and interpreting data sets. Natural problem-solver possessing strong cross-functional understanding of information technology and business processes.
SkillsQuery ToolsAnalytical Problem SolvingReporting ToolsData MiningData QualityData AnalysisData Visualization and PresentationsDatabase Programming and SQLLinear and Logistic regressionR and Python
Experience01/2022toCurrentData AnalystGranicus|Chicago,Il Or Denver,Conducted data analysis to prepare forecasts and identify trends.X-13ARIMA-SEATS model to seasonal adjustment for time series analysis 2+ delinquencies.Generated reports and obtained data to develop analytics on key performance and operational metrics.Partnered with data scientists to support ongoing research and analytics initiatives.Worked with internal teams to understand business needs and changing strategies.Created and designed business intelligence databases, spreadsheets or outputs.Recommended metrics and models based on observed trends.Generated standard or custom reports summarizing business, financial or economic data.Managed diverse projects for data capture, storage and forecast analysis.Developed a new credit scoring matrix to target personal loans using linear and logistic predictive modelsMachine learning using descriptive models in analyzing the internal scoring model for personal loansUse descriptive analytics to implement new credit criteria for personal loans, Debt-to-Income ratio to Free Cash FlowExperience using Yeo-Johnson Transformation and center/scale a vector to attempt normalizationImplemented internal reporting using power bi to Forecasting using 2 + delinquency comparisonsBuilt compelling data stories and visualizations to influence decision makers.02/2021to12/2021Data SpecialistAscension Health|Wichita,KS,Worked with internal processes using various modeling and machine learning in R to analyze inpatient care to hospice.Generated customized reports on client data, providing valuable insights into requested data points.Audited data regularly to guarantee data integrity and quality.Reconciled data to identify anomalies.Corrected data errors and entered missing information into new data parcels being processed for clients, maintaining compliance with guidelines.Reviewed and updated account information in company computer system.Extracted, imported and exported data into various database applications.Gathered data from multiple sources to assimilate meaningful inputs for databases.Created reports and audited charts to maintain concise records.Utilized Microsoft Power BI to create interactive and reporting dashboards used for internal operations.Developed and implemented a new payroll system using SSRS.Imported and implemented new data by creating a linked server with Microsoft SQL Server Management Studio.05/2020to10/2020Report DeveloperCgi Group Inc.|Springfield,VA,Monitored and reported on key performance indicators and shared results with management team.Assessed and prioritized departmental reporting needs, functions and strategies and reported findings to management.Streamlined reporting processes by evaluating data sources, compiling data and redesigning output.Drafted and formatted reports in alignment with data quality requirements.10/2017to03/2020Data AnalystGranicus|Columbus,OH,Audited internal data and processes to identify and manage initiatives, improving business performance.Generated reports and obtained data to develop analytics on key performance and operational metrics.Created impactful business reports utilizing large datasets and Crystal Reports, SQL, and MS Excel.Worked in a close team to build data support and report generation used for both internal and external reporting.Assisted in the administration and auditing of SQL databases.Created and maintained custom queries, views, and stored procedures using T-SQL for data and driven datasets.Assisted in change management validation and verification to ensure data quality.Managed Crystal to distribute daily, weekly, and monthly reports and dashboards for internal clients.Generated standard or custom reports summarizing business, financial or economic data.
Education and TrainingExpected in05/2017totoBachelor of Science|Business Administration – MISUtah Tech University,St. George, UT,GPA:Expected intotoMaster of Science|Business AnalyticsUniversity of Utah,Salt Lake City,UTGPA:>>. The result is, No Fit

Fit assessment: No Fit