Data Analyst

Ebara Elliott Energy•Jeannette, PA

About The Position

The Data Analyst discovers data from multiple sources and learns the business context of data attributes across organizational domains. The role defines data structures and attributes, creates data dictionaries, documents data lineage, and develops algorithms for mastering data to support reliable reporting and analytics. It produces moderately complex solutions and is accountable for small and medium-sized projects of low to moderate complexity, while assisting with portions of larger projects under supervision. The position involves collecting, organizing, structuring, profiling, and clarifying data. It regularly interacts with internal business users across departments and global locations, and works closely with visualization engineers, data engineers, and data scientists to resolve ambiguity in data attributes. The role receives limited general direction, has work reviewed routinely, and selects appropriate procedures and approaches to technical challenges. It also cooperates with colleagues and vendors and must be ready to work in a fast-paced environment.

Requirements

Bachelor’s degree in Data Analytics, Business, Mathematics, Computer Science, or Engineering.
Two years of work experience in a Data Analyst role.
Working knowledge of typical data pipelines.
Developing skills in SQL, Excel, source-to-target mapping, data pipelines, and data visualization.
Ability to define data and business terms in data dictionary format.
Knowledge of operational processes in the defined area of work and familiarity with industry practices and standards.

Responsibilities

Discover data across applications, databases, and spreadsheets.
Catalog data and provide governed data definitions.
Document data lineage and communicate findings from data discovery.
Map common attributes across different data sources.
Profile data quality and provide solutions to improve it.
Define algorithms for mastering data, using Master Data Management practices.
Write SQL queries to profile data and identify the right source for each data domain.
Clarify data attributes for business users and members of the Data Analytics team.
Develop dashboards and reports for end users.
Define processes for data collection and maintenance, with a focus on data quality.
Provide reports on data quality and improvements.
Build solutions supporting larger projects.
Take responsibility for completing assigned tasks, including tasks involving cooperative efforts with others.
Obtain source data from Elliott systems to compile new reporting functionality.