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

Resume:
<<qualifications over two years' experience of data analysis at loyola chicago university; providing statistical analysis plan and generating report, tables, graphs; proficient in r and sas. proficient in microsoft office, word, excel and power point. ability to effectively organize and manage multiple assignments with hard deadlines. great team player and extensive experience and skills in collaboration and communication. professional experience 09/2016tocurrentdata analyst internenvestnet , merge spreadsheets from different sources to create a more compact and centralized data platform for easy updating and data analysis using ms excel advanced functions and formulas. data cleaning and data validation of existing spreadsheets to promote a robust data management platform for accurate data entry and data analysis. train employees on the use of pivot tables and tips and tricks in ms excel for efficient data entry and analysis. 07/2013to 04/2014research assistantsuny upstate medical university ,supervisor: drs. michael crum and david rayome paper: self-employment and subjective well-being: a multi-country analysis using the world values survey. international journal of entrepreneurship (published in 2014) statistical analysis of elements influencing self-employment and life happiness using r studio literature research on topics of self-employment and satisfaction 04/2012to 07/2012accounting internshipamica mutual insurance park ridge. provide data management for accounting journals using government-secured software prepare written report of asset inspection and sorted the documents 04/2011to 07/2011finance internshipsiemens corporation wichita. sales consultant for financial products and services education expected in2016totomaster of science applied statisticsloyola chicago university,chicago,ilgpa:expected in2013totobachelor of science finance and risk managementnorthern michigan university,marquette,migpa: skills computer software: ms word, powerpoint, excel, access statisticalsoftware: r studio, sas, minitab, sqllanguage: mandarin and english.