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:
<<summarya results driven, detail-oriented data professional with a variety of roles in business and technology. experience includes data quality & governance across different dimensions within data driven environments. resourceful, self-starter with a proven track record of effectively working with cross-functional teams to develop and implement data strategies. education expected in2018totobachelor of arts computer sciencequeens college of the city university of new york,flushing,nygpa:expected in2009totohigh school diploma martin van buren high school,queens village,nygpa: experience 09/2021tocurrentdata quality analystillumina il,state,drive adoption of collibra to provide users with a tool to foster data democratization. this includes an organizationally accepted business glossary, data catalogue, data dictionary, the ability to explore data lineage for tableau-based dashboards, and a single source of truth.perform user acceptance & regression tests on google cloud platform's bigquery data using sql scripts (i.e. test functionality, performance and solution of new product requests to maintain strong development standards and high stakeholder satisfaction).gain a deep understanding of peacock's data pipeline to comprehend the data flow and identify transformations from source to target.perform in-depth exploration of causes, trends, opportunities, and actions required to improve data quality of key metrics, kpis, and additional data centric dashboards.provide ad hoc analysis to support data team, business units, and key stakeholders for complex data quality questions.partner with stakeholders and implementation specialist during the data onboarding phase on various projects, providing analysis and sharing best practices.evaluate large datasets using bigquery to determine quality and accuracy; proactively identifying, addressing and resolving reconcilable discrepancies through daily/weekly/quarterly data analysisimprove data quality across products and projects by collaborating and working closely with engineering, management, product, business teams and other required team, contributing directly to development by participating in feedback sessions.define and operationalize processes to continuously monitor and quality check data completeness and accuracy.develop a complete inventory of data clean up reports, defining the cadence for producing them and addressing uncovered issues. 07/2019to 09/2021enterprise data steward associateonemain (formerly springleaf & onemain financials). ,acted as a liaison between non-technical & technical stakeholders within cross-functional teams to gather business requirements for data solutions.managed a monthly data quality process that helped identify data quality anomalies.analyzed, queried and manipulated data using sql to define business rules and best practices. this included writing data quality rules to add into sql server management studio (ssms) and execute as part of our data quality monthly process.compiled and presented monthly/quarterly reports to management to showcase number of identified data anomalies and remediation progress.performed manual and automated tests on applications and submitted reports.developed process improvements to enhance overall data quality.collaborated closely with business process owners and data/technology stewards to promote team-oriented approach in data quality remediation.participated in technical trainings and workshops to improve skills set and boost overall knowledge.analyzed issues and recommended corrective actions to improve final results.outlined remediation plans to standardize results to meet compliance regulations.executed test scripts using sql to compare specifications and comply with stakeholder requirements.researched and established root cause to data issues. 09/2018to 07/2019database/data entry specialistwinholt equipment group city,state,assisted with the implementation of a new database system running on sql server called epicorcollaborated with it and engineering department in order to integrate key information including but not limited to manufactured items, parts and materials from prior database system, known as as-400, into epicormaintained data integrity by normalizing tables to avoid redundant and duplicate dataimproved reliability of supply chain software, systems, database and order processingassessed department needs and goals through communication and system evaluations to modify existing databases for personalized customization 11/2017to 09/2018administrative assistantachieve beyond city,state,maintained database by updating child files with their c.l.a.i.m.s. softwareverified that information in the computer system was up-to-date and accuratecreated pivot tables in excel to view statistical information for unpaid servicescreated monthly reports using reportvieweridentified and resolved system and account issuesorganized files, developed spreadsheets, faxed reports and scanned documents.