Senior Data and Reporting Analyst

The Senior Data & Reporting Analyst will support the API Statistics Program by analyzing statistical data designing surveys benchmarking studies (i.e. data collection harnessing data to drive insights) designing data visualizations architecting robust data integrations and overseeing the production of recurring and one-time statistical reports. They will provide expertise to staff across API member company representatives and others on statistical data.

Duties/Responsibilities

Reporting and Analysis Lead

• Analyze statistical data and provide support to API programs API Segments Communications and external customers.
• Collaborate with team members and IT to review and update outdated code including re-writing programming languages for applications such as DWDS JAS etc.
• Oversee the departments efforts in developing models for data analysis including text analytics NLPs and predictive learnings.
• Collaborate with the Weekly Statistical Bulletin (WSB) team in producing the WSB report help ensure data quality and accuracy through data entry auditing and report generation. Assist in the enhancement of data collection processes including data scraping and automation of data validation review tools.
• Work with cross-functional teams on designing creating and editing surveys data analysis benchmarking and report generation for ad-hoc projects; and serve as Project Lead in new department projects.
• Manage analysis and reporting midstream pipeline data from the U.S. DOTs Pipeline and Hazardous Materials Safety Administration (PHMSA) the API Pipeline Strategic Data Tracking System (PSDTS) and other governmental/regulatory agencies.
• Automate and oversee the data scraping compilation analysis and reporting of data from the Federal Energy Regulatory Commission (FERC) Form 6 database.
• Automate and oversee the data scraping and analysis of enforcement actions in the industrys pipeline activities producing benchmark reports for pipeline operators.
• Oversee various data mapping projects such as the API Environmental and Social Justice mapping tool and generate analytical reports to support industry activities.

Data and Information Expert

• Design and implement interactive Power BI dashboards to translate complex datasets into executive-ready visualizations for members internal stakeholders and external stakeholders
• Leverage programming languages to extract clean and analyze data from multiple sources to identify trends and patterns.
• Identify opportunities for increased efficiency in existing processes and implement improvements by leveraging data analytical tools.
• Performs and maintains data extracts and imports; assists users as necessary.
• Provides analysis of business data needs and makes recommendations for viable solutions.
• Addresses issues of data integrity and migration (validation clean-up and mapping).
• Troubleshoots data issues validates results and recommends and implements process solutions and improvements.
• Support the development and implementation of the API Survey Portal.
• Lead the evaluation and modification of the departments applications data management and analytical software.
• Contribute to the development of a Statistics Program Procedures Manual documenting processes and procedures used in the collection management and distribution of data.

Key Relationships

• Work with IT staff engaged in programming report codes.
• Coordinate with the API staff and managers to develop and deliver Statistics Department work products.

Qualifications

• Requires 3-5 years of experience in a similar role and subject matter expertise.
• Bachelors degree in relevant area or other related field equivalent work experience.
• 2years experiencein statistical issuesparticularly those related to the petroleum industry including development of statistical models and data visualization (e.g. Power BI).
• 2 years of IT experience in successful implementation of information technology with a heavy focus on database development data analysis and reporting preferred.
• Excellent interpersonal and communication skills and the ability to function effectively in ateam-oriented environment.
• Ability to work independently in a fast-paced deadline-oriented environment.
• Attention to detail.
• Excellent skills with Microsoft Office (Word PowerPoint Excel and Access).
• Excellent skills in one or more programming languages such as Python R SQL JavaScript and VBA.
• Familiarity with either SAS ArcGIS and Forsta (or similar survey software/tools) is a bonus.
• Information management data governance data analysis expertise is strongly desired.
• Familiarity with application and website development.

Physical Requirements

• Able to remain in a stationary position working on a computer.
• Move about the office to access office machinery meeting rooms etc. on occasion.
• Operate a computer and other office machinery such as printers and copy machines.
• Transport items and equipment up to 10 lbs. on occasion.

Travel Requirements

• Up to 25%

Percentage of travel time expected for the position where the travel occurs such as locally or in specific countries or states and whether the travel is overnight.

This job outline describes the typical accountabilities and requirements of the position and should not be construed as anall-encompassingdescription of every duty performed by or expected of the incumbent.

EEO Statement

API is an equal opportunity employer. We are dedicated to creating and sustaining a diverse and inclusive workplace. All aspects of employment will be based on merit competence performance and business needs. Our success in maintaining a reputation for professional excellence depends on selecting the best qualified candidates. Achieving this objective means that no employee or applicant for employment will be discriminated against because of race color religion age gender expression or identity sexual orientation pregnancy (including childbirth related medical conditions breastfeeding and reproductive health decisions) genetic information national origin disability marital status personal appearance family responsibilities political affiliation matriculation credit information the status as a victim or family member of a victim of domestic violence stalking or sexual offense or any prohibited basis under federal state or local law.

APIis committed to providing access equal opportunity and reasonable accommodations for individuals with disabilities in employment its services programs and activities. If you require reasonable accommodation in completing this application interviewing completing any pre-employment testing or otherwise participating in the employee selection process please direct your inquiries to the Human Resources Department via email at.

This salary range is DC based and may be adjusted accordingly based on the candidates geographic location. Candidates are typically hired at a point in the salary range based on prior experience education and market demand for the role; candidates are also compared internally to their peers.

API offers a comprehensive benefits package for our employees and their families. More information about our benefits may be found at Experience:

Senior IC