Data Analyst

Elliott Company; Jeannette (Westmoreland County); On-site; USD 65,000 - 90,000; Full time

Job summary

Ebara Elliott Energy seeks a Data Analyst to uncover data across multiple sources, learn business context, and define data structures and lineage. You will produce moderately complex solutions and collaborate with operations, sales, marketing, and finance teams globally.

The role focuses on mastering data quality, building dashboards, and delivering governed data definitions alongside data engineers and data scientists. A data-driven mindset is essential.

Qualifications

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

Responsibilities

• Discover data across the various applications, databases and spreadsheets.
• Catalog and provide governed data definitions.
• Document lineage of the data.
• Communicate findings during the data discovery.
• Map common attributes across various sources of data.
• Profile the data for quality and provide solutions for improving the quality of the data.
• Well versed with Master Data Management and define algorithms for mastering data.
• Write SQL queries, to profile that data and identify the right source for all the domains of data.
• Provide clarification about data attributes to the business and other members of the Data Analytics team.
• Develop dashboards and reports to deliver data to end users.
• Define processes needed for data collection and maintenance, with focus on data quality.
• Provide reports on data quality and its improvements.
• Build solutions in support of larger projects.
• Takes responsibility for completion of assigned tasks, involving the cooperative efforts of others.
• Begins to obtain source data from Elliott systems to compile new reporting functionality.
• Be ready to work in a fast paced environment.

Skills

SQL

Excel

Data pipelines

Data visualization

Data Dictionary

Operational processes

Education

Bachelor’s degree in Data Analytics or related field

Tools

Data visualization tools

Master Data Management

Job description

Overview & Responsibilities

The Data Analyst will be responsible for data discovery from various data sources, and understand and learn the business context of all the data attributes pertaining to the several domains across the organization. This role will define the data structure, create data dictionaries, define attributes, explore and document data lineage, provide algorithms for mastering data, so as to enable quality reporting and analytics. Analyst responsible for producing moderately complex solutions to assigned tasks.

Background and Experience

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

Nature of the Job

This position’s main activities is discovering collecting, organizing and structuring the data.

• Accountable for small and medium-size projects of low to moderate complexity.
• Assists with portion(s) of large projects under supervision.
• Receives limited general direction; work in progress is reviewed routinely.
• Selects appropriate work procedures or approaches to address technical challenges.
• Makes own decisions regarding how to approach a work assignment.
• Requires regular interaction with internal business users from all departments including Operations, Sales, Marketing, and Finance across all global locations.
• Works closely with Visualization engineer, Data engineer and Data scientist to remove ambiguity related to the data attributes.
• Interacts with others using basic courtesy and straightforward information exchange.
• Cooperates with and works effectively with colleagues across the organization and with vendors.

Specific Job Responsibilities / Competencies

• Discover data across the various applications, databases and spreadsheets.
• Catalog and provide governed data definitions.
• Document lineage of the data.
• Communicate findings during the data discovery.
• Map common attributes across various sources of data.
• Profile the data for quality and provide solutions for improving the quality of the data.
• Well versed with Master Data Management and define algorithms for mastering data.
• Write SQL queries, to profile that data and identify the right source for all the domains of data.
• Provide clarification about data attributes to the business and other members of the Data Analytics team.
• Develop dashboards and reports to deliver data to end users.
• Define processes needed for data collection and maintenance, with focus on data quality.
• Provide reports on data quality and its improvements.
• Build solutions in support of larger projects.
• Takes responsibility for completion of assigned tasks, involving the cooperative efforts of others.
• Begins to obtain source data from Elliott systems to compile new reporting functionality.
• Be ready to work in a fast paced environment.

Equal Employment Opportunity

Ebara Elliott Energy is an equal employment opportunity/affirmative action employer and does not discriminate on the basis of race, color, religion, sex, national origin, age, marital status, genetic information, disability, veteran status, or any other characteristic protected by the federal, state or local laws of the United States. Applicants and employees are protected under U.S. federal law from discrimination.

About Ebara Elliott Energy

We are proud of our legacy, but our focus is on the future, putting our tradition of innovation to work on the new challenges facing global energy production and processes. Using advanced technologies, producing high-quality products, and offering reliable services are just a few of the ways that Ebara Elliott Energy is doing its part to contribute to a cleaner, more sustainable future. As a solution provider in the energy industry, Ebara Elliott Energy designs, manufactures, and services technically advanced centrifugal and axial compressors, steam turbines, power recovery expanders, custom pumps, and cryogenic products used in the petrochemical, refining, oil & gas, and liquefied gas industries, as well as in power applications. We employ 2,300 people in 30 locations around the world. The company is a wholly owned subsidiary of Ebara Corporation, a major industrial conglomerate headquartered in Tokyo, Japan. Ebara employs 19,000 people and has sales of US $5 billion.