Data Engineer III

2 months ago


Akron, United States FirstEnergy Corp Full time

FirstEnergy

FirstEnergy at a Glance

We are a forward-thinking electric utility powered by a diverse team of employees committed to making customers' lives brighter, the environment better and our communities stronger.

FirstEnergy (NYSE: FE) is dedicated to safety, reliability and operational excellence. Headquartered in Akron, Ohio, FirstEnergy includes one of the nation's largest investor-owned electric systems, more than 24,500 miles of transmission lines that connect the Midwest and Mid-Atlantic regions, and a regulated generating fleet with a total capacity of 3,780 megawatts.

About the Opportunity

This is an open position with FirstEnergy Service Co., a subsidiary of FirstEnergy Corp. [SC00]

The ability to work remotely within the United States may be available based on business need. This option is not available in the states of California, Colorado, Illinois, Kentucky, Massachusetts, Montana, Nebraska, New York, Oregon or Washington at this time.

The Data Management team within FirstEnergy's Information Technology group is responsible for the design, development and enhancement of Data Warehousing and Analytics applications. We seek an individual that can confidently play the role of a Data Engineer during Data Lake / Data Warehouse development. A Data Engineer at FirstEnergy works closely with Business Systems or Business resources to make appropriate technological choices; proceeds to architect and design the required application. This role requires deep understanding of data architecture, data engineering, data analysis, reporting, and a basic understanding of data science techniques and workflows. The ideal candidate is a skilled data and software engineer with experience creating data products supporting analytic solutions.

Responsibilities Include:

A Data Engineer at FirstEnergy typically performs the following activities during the application development process:
- Requirements analysis: In conjunction with a Business Systems team Analyst or independently, work with the business to collect, document and review functional and non-functional requirements for the application.
- Solutions maintenance: Responsible for maintaining the data warehousing platforms and all components of MemSQL/SingleStore, Teradata and legacy Oracle Data Marts, Azure Synapse Notebooks/Pipelines.
- Architect: In conjunction with a Business Systems team Analyst or independently, decompose the application into various components and make appropriate technological choices in the implementation and integration of the components also giving due consideration to availability, recovery, security, performance, and governance requirements.
- Analysis and design: Define and document the logical data model and create the physical data model in a database. Define and create Data Lake and Data Warehousing models for reporting or analytics. Identify the various contributing source systems and source data elements; help define & build the extraction functions to obtain the source data supporting change data capture. Define and document the various data transformations that must occur during this process. Incorporate maintainability, security and performance requirements into the design and specifications.
- Build and test: Create physical data model. Implement data extraction functions and transformation logic. Document all design and specifications. Document metadata information. Develop early prototypes for the application, as necessary. Support the development of complex logic or functions necessary that help the organization's business achieve their goals.
- Communicate design and logic to business users by explaining how a data model relates, where the data comes from, and logic used in the ETL (extract, transform, load) process. After doing the analysis to understand it, a verbal, written, or interactive explanation must be given to the interested parties. Foster a culture of sharing, re-use, design for scale stability, and operational efficiency of data and analytical solutions.

What You Will Need to be Qualified:

- You have a bachelor's degree in a quantitative discipline such as Computer Science or another related field with 5 years of related experience. - Your related experience should include working knowledge of: Agile/Scrum Methodologies, RDBMS, and ETL

- You are willing to undertake assignments involving unfamiliar subjects and demonstrate aptitude to learn quickly.
- You are highly motivated; can work independently with a high level of productivity.
- You excel at communicating complex ideas and concepts both verbally and through writing.
- You have experience with development and tuning on RDBMS technology including Teradata, SingleStore, Oracle or SQL Server.
- You have knowledge and experience in development and tuning of ETL processes using PowerCenter, Informatica Data Replication (IDR), or other comparable tools.
- You have experience in creating, analyzing, and documenting ER and Dimensional models, preferably with ERWIN experience.
- Preferably you have experience in using the Kimball methodology to design and develop Enterprise Data Warehouses and Data Marts.
- Ability to effectively prioritize and plan activities, multitask and meet deadlines.
- Willingness and ability to mentor less experienced personnel. Encourages, supports, and challenges team members as necessary.
- Ability and willingness to work flexible hours and be available during on-call rotation.

Benefits, Compensation & Workforce Diversity

At FirstEnergy, employees are key to our success. We depend on their talents to meet the challenges of our changing business environment. We are committed to rewarding individual and team efforts through our total rewards philosophy which includes competitive pay plus incentive compensation, a company-sponsored pension plan, 401(k) savings plan with matching employer contribution, a choice of medical, prescription drug, dental, vision, and life insurance programs, as well as skills development training with tuition reimbursement. Please visit our website at www.firstenergycorp.com to learn more about all of our employee rewards programs. FirstEnergy proudly supports workforce diversity. All qualified applicants will receive consideration for employment without regard to race, religion, color, national origin, sex, sexual orientation, gender identity, age, status as a protected veteran, or status as a qualified individual with a disability. No recruiters or agencies without a previously signed contract. Unable to sponsor or transfer H-1B visas at this time.

Safety

Safety is a core value for FirstEnergy and is essential to all of our business activities. We ensure employees have the tools, information, and processes to perform their duties in a manner that assures safety for themselves, their co-workers, our customers and the public. Our goals are to provide a safe work environment, to maintain an accident-free, injury-free workplace, and to promote and maintain public safety. To meet these goals, we dedicate ourselves to achieving world-class safety standards.

Position Classification

Exempt

FirstEnergy Human Resources Team


  • Data Engineer III

    1 month ago


    Akron, Ohio, United States FirstEnergy Corp Full time

    About the OpportunityWe are seeking a highly skilled Data Engineer to join our team at FirstEnergy Corp. As a Data Engineer, you will play a critical role in the design, development, and enhancement of our Data Warehousing and Analytics applications.ResponsibilitiesRequirements analysis: Work with the business to collect, document, and review functional and...


  • Akron, Ohio, United States Omni Inclusive Full time

    Data Engineer and AnalystAt Omni Inclusive, we are seeking a highly skilled Data Engineer and Analyst to join our team. As a Data Engineer and Analyst, you will be responsible for designing, developing, and maintaining large-scale data systems and performing advanced data analysis to drive business decisions.Responsibilities Perform data engineering,...

  • Software Engineer III

    3 weeks ago


    Akron, United States Dr. B Full time

    DRB (A Vontier Company) is the leading provider of technology-enabled devices and software solutions to the North American car care industry. WHAT WE DO: enabling the future of vehicle care - wherever the road takes you. WHY WE DO IT: To fuel our client's growth with connected, data-led technology, driven by our spirit of innovation and commitment to...

  • Sales Executive III

    4 weeks ago


    Akron, Ohio, United States Thermo Fisher Scientific Full time

    Job Description:Thermo Fisher Scientific is seeking a highly motivated and experienced Sales Executive III to join our Sales & Marketing team. As a Sales Executive III, you will be responsible for the sales of consumable and diagnostic lab supplies and instrumentation within a defined territory.Key Responsibilities:Lead territory to ensure effective customer...

  • Data Architect

    1 week ago


    Akron, United States GOJO Industries Full time

    Information about #31829 Data ArchitectWork Location: This role is mostly virtual and can be performed anywhere within the continental US, provided that Eastern Standard Time core business hours are maintained. We are unable to offer sponsorship or Visa transfer assistance for this position. Formulated to CareFor more than 75 years,...

  • Electrical Engineer

    3 weeks ago


    Akron, United States FirstEnergy Full time

    Job DescriptionFirstEnergy at a GlanceThis is an open position with FirstEnergy Service Co., a subsidiary of FirstEnergy Corp. [FEU]We are a forward-thinking electric utility powered by a diverse team of employees committed to making customers' lives brighter, the environment better and our communities stronger.Primary reporting location is Akron, Ohio....

  • Electrical Engineer

    3 weeks ago


    Akron, United States FirstEnergy Full time

    Job DescriptionFirstEnergy at a GlanceThis is an open position with FirstEnergy Service Co., a subsidiary of FirstEnergy Corp. [FEU]We are a forward-thinking electric utility powered by a diverse team of employees committed to making customers' lives brighter, the environment better and our communities stronger.Primary reporting location is Akron, Ohio....

  • Electrical Engineer

    3 weeks ago


    Akron, United States FirstEnergy Full time

    Job Description FirstEnergy at a Glance This is an open position with FirstEnergy Service Co., a subsidiary of FirstEnergy Corp. [FEU] We are a forward-thinking electric utility powered by a diverse team of employees committed to making customers' lives brighter, the environment better and our communities stronger. Primary reporting location is Akron, Ohio. ...

  • Electrical Engineer

    5 months ago


    Akron, United States FirstEnergy Full time

    Job Description FirstEnergy at a Glance This is an open position with FirstEnergy Service Co., a subsidiary of FirstEnergy Corp. [FEU] We are a forward-thinking electric utility powered by a diverse team of employees committed to making customers' lives brighter, the environment better and our communities stronger. Primary reporting location is Akron, Ohio. ...

  • Data Analyst Intern

    4 weeks ago


    Akron, Ohio, United States Continental Full time

    Job DescriptionAt Continental, we are seeking a highly motivated and detail-oriented Data Analyst Intern to join our Human Resources team. As a Data Analyst Intern, you will play a key role in supporting the development and implementation of data-driven initiatives to enhance employee satisfaction and engagement.Key Responsibilities:Support the preparation...


  • Akron, Ohio, United States Randstad Full time

    We are seeking a skilled Senior Data Application Developer to join our Analytic Services team, which supports the hardware and software used for our business analytics.The ideal candidate will have expertise in technical solutions and applications, understanding business processes and translating them into work projects in the form of analytics and...


  • Akron, Ohio, United States Apex Systems Full time

    Job Summary:We are seeking a highly skilled Data Analytics Specialist to join our Analytic Team at Apex Systems. As a key member of our team, you will be responsible for delivering and maintaining applications that enable business transformation.Key Responsibilities:Work with business units and IT to deliver and maintain applications that enable business...

  • Mailroom Clerk III

    2 weeks ago


    Akron, United States Genesis10 Full time

    Genesis10 is seeking a Mailroom Clerk III for a 10-month contract position with a leading client located in Akron, OH. This role pays $16/HR W2 based on experience. Job Duties: Sorts and distributes incoming interoffice and US mail. Accepts and delivers incoming packages (UPS/FedEx/Office Depot) Applies postage to outgoing mail and processes outgoing UPS...

  • Mailroom Clerk III

    6 days ago


    Akron, United States Genesis10 Full time

    Genesis10 is seeking a Mailroom Clerk III for a 10-month contract position with a leading client located in Akron, OH. This role pays $16/HR W2 based on experience. Job Duties: Sorts and distributes incoming interoffice and US mail. Accepts and delivers incoming packages (UPS/FedEx/Office Depot) Applies postage to outgoing mail and processes outgoing UPS...

  • Software Engineer

    3 weeks ago


    Akron, United States Robert Half Full time

    Job DescriptionJob DescriptionWe are on the hunt for a skilled Software Engineer to join our dynamic team. This role is remote and offers a long-term contract employment opportunity. As a Software Engineer, your primary focus will be on developing and maintaining software systems that align with our business needs. You will be working in a fast-paced,...

  • Software Engineer

    1 month ago


    Akron, United States Robert Half Full time

    Job DescriptionJob DescriptionWe are on the hunt for a skilled Software Engineer to join our dynamic team. This role is remote and offers a long-term contract employment opportunity. As a Software Engineer, your primary focus will be on developing and maintaining software systems that align with our business needs. You will be working in a fast-paced,...


  • Akron, Ohio, United States Jobot Full time

    Job SummaryAs a Senior Civil/Structural Engineer at Jobot, you will apply advanced engineering principles with minimal supervision to develop innovative solutions and designs for our clients. You will be responsible for collecting and analyzing data, initiating creative solutions, and working with a team of experienced engineers and designers.Key...

  • Test Driver

    2 days ago


    Akron, United States KLM Careers Full time

    The Test Driver - Engineering position at Kumho America Technical Center (KATC) involves managing and executing tire vehicle testing across North America. This role is focused on scheduling, acquiring test vehicles and wheels, ordering benchmark tires, collecting test data, and creating official test reports. The successful candidate will communicate results...


  • Akron, Ohio, United States Saviance Full time

    Job Title: Telecommunications Engineering ManagerWe are seeking a seasoned and accomplished Telecommunications Engineering Manager to lead our voice engineering organization. This is a vital leadership role, overseeing the strategic direction, architecture, full lifecycle operations, maintenance, and optimization of our enterprise voice infrastructure and...


  • Akron, Ohio, United States FirstEnergy Full time

    About the RoleFirstEnergy is seeking a highly motivated and detail-oriented Network Engineering and Operations Intern to join our team. As a Network Engineering and Operations Intern, you will be responsible for providing daily support for the Data Network team, ensuring high levels of reliability and availability of the systems, and managing the...