Data Analyst at Ebara Elliott Energy
Jeannette, PA — full-time
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 an 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 This position requires regular interaction with internal business users from all departments including Operations, Sales, Marketing, and Finance across all of the global locations of the organization. It will also work closely with the Visualization engineer, Data engineer and Data scientist to remove ambiguity related to the data attributes. Interacts with others using basic courtesy and a straightforward exchange of information. 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, in