Data Engineer II

Futura Systems; Atlanta (GA); Hybrid; USD 80,000 - 110,000; Full time

Job summary

An established industry player is seeking a passionate Data Engineer II to join their innovative team. In this hybrid role, you'll engage in all stages of the development life cycle, ensuring data integrity and optimizing performance for proprietary software applications. Your expertise in SQL and ETL processes will be crucial in analyzing and resolving issues, while your strong analytical skills will help you write detailed data specifications that meet customer needs. This company values creativity and thought leadership, offering a dynamic work environment where your contributions will directly impact the success of their software solutions. If you're ready to make a difference in the utility software space, this opportunity is for you!

Benefits

Outstanding Medical/Dental/Vision

Education/Training Reimbursement

Flexible Spending Account

Health/Wellness Reimbursement

Vacation: 22 days accrued time off

In Office Gym

Relaxed Dress Code

Flexible Hybrid Work Schedules

Qualifications

• 5+ years of Oracle SQL and backend development experience.
• 3+ years of data warehouse architecture and ETL development experience.

Responsibilities

• Responsible for data component of implementation life cycle for utilities.
• Analyze, identify, troubleshoot, and resolve issues throughout the implementation.

Skills

Oracle SQL

Data Analysis

ETL Development

Problem-Solving

Analytical Skills

Communication Skills

Time Management

Education

Bachelor's Degree in Computer Science or related field

Equivalent work experience

Tools

Alteryx

SQL

PL/SQL

GIT

Job description

Meridian Cooperative is seeking a Data Engineer II to join a team of passionate innovators and problem-solvers, empowered to rise above challenges and swarm around solutions. Here at Meridian, we are energized by the fact that our work is important. We are driven to make work as easy as possible for our Members, Customers, Partners and Employees. Headquartered in Dunwoody, this role is Hybrid.

Help us lead the way in Utility Software, join a winning company and thrive.

Job Summary:

The ideal candidate participates in all stages of the development life cycle for proprietary software and/or database applications for market sale, to address user needs, and/or to improve operational efficiency. Core code, troubleshoot, and deep-dive analysis. May analyze databases within an application area, working individually or coordinating application development as part of a team. Designs and modifies proprietary company applications or specialized utility programs, using analysis and models to predict and measure the outcome of the design and providing direction to peers as needed. Modifies applications to correct errors, adapt to new technologies, or improve performance; analyzes code and/or data to identify causes of errors, as needed.

• The Data Engineer will be responsible for the data component of the implementation life cycle for utilities of low to high complexity.
• In addition to extracting, transforming and loading customer data, the ideal candidate is responsible to analyze, identify, troubleshoot, research and resolve issues throughout the implementation life cycle which includes after the customer is live on the new software platform.
• Works effectively with other team members to perform in depth data analysis to write detailed data specifications and mapping which meet the customers business needs.
• Responsible for identifying and working to resolve performance gaps and issues.
• Analyzes data for transfer, designs and develops data migration process using Alteryx.
• Conducts quality assurance testing and verification throughout the implementation lifecycle utilizing both SQL or PL/SQL, and application knowledge.
• Demonstrate knowledge of working with queries/applications, including performance tuning, utilizing indexes, and materialized view to improve query performance.
• Responsible of ensuring end to end data integrity throughout the system.
• Uses organizational tools effectively in conjunction with sound judgement to independently make reasonable assumptions and decisions.
• Delegates tasks to other team members as appropriate. With minimal oversight supports the implementation life cycle for the cross functional or interdepartmental teams.
• Exhibits excellent customer service skills with both internal and external customers, which includes cross functional teams.
• Take the initiative in thought leadership, innovation, and creativity.
• Represent the company at conferences and networking events.
• Adheres to all Meridian Cooperative corporate policies and procedures.
• Travel as required.
• Any additional responsibilities assigned by management.

Qualifications:

• Bachelor's Degree or equivalent work experience in SQL, relational database design, and development.
• 5+ years of Oracle SQL and backend development experience with enterprise software systems.
• 3+ years of professional experience with detailed knowledge of data warehouse technical architectures, infrastructure components, and ETL development process using Alteryx or any ETL software.
• 3+ years of professional experience with writing, tuning and optimizing SQL complex queries.
• Strong analytical, design, testing, problem-solving and time management skills.
• Detail-oriented, able to manage competing priorities effectively within project timelines.
• Knowledge of data integrity and relational rules
• Interpersonal and communications skills, including ability to present and explain technical information within an interdisciplinary team setting.

Preferred Qualifications:

• 3+ years hands-on experience in any programming languages, preferably PL/SQL, C# or Java.
• Understanding of, and ability to apply AGILE development methodology in performing duties.
• Understanding of GIT concepts.
• Understanding of putty environment and ftp process.
• DBA experience.

We Offer:

• Outstanding Medical/Dental/Vision that starts on the first day of employment.
• Education/Training Reimbursement
• On-Site Education Courses
• Flexible Spending Account
• Health/Wellness Reimbursement (fitness tracking device up to $300)
• Excellent Life Insurance & Disability
• Vacation: 22 days of accrued time off (no waiting period). 9 holidays, which include the day after Thanksgiving & Christmas Eve. Up to 240 hours of vacation time can rollover to the following year.
• Volunteer Time: 8 hours per year
• Retirement: Very robust 401(k). Employees are 100% vested in the Company-funded employer basic contributions from the date they enter the plan. The Company will match 100% of each dollar you contribute on the first five percent (5%) of eligible compensation that you contribute to your account. Employer basic contribution eligibility occurs on the first day of the month following the employee’s completion of one year of continuous service (contribution of 4-11% of base salary based on years of service).

In Addition, We Also Offer:

• Relaxed Dress Code
• Flexible Hybrid Work Schedules: 3 days remote, 2 days onsite.
• In Office Gym

About Us:

Meridian Cooperative was formed in 1976 by a group of Electric Membership Cooperatives with a vision for a single enterprise solution provider to serve data processing, IT, and operational needs to cooperatives, public utility districts, and municipal utilities. Through carefully curated acquisitions and partnerships, Meridian has unified multiple leading-edge companies under its umbrella in order to truly execute that vision. Today, the Meridian Co-op Suite serves over 500 utilities across the country with industry leading enterprise software solutions. Meridian is proud to be named as a 2022 Top Atlanta Workplace by the AJC!

Our employment practices are in accordance with the laws that prohibit discrimination against qualified individuals on the basis of race, religion, color, gender, age, national origin, physical or mental disability, genetic information, veteran’s status, marital status, gender identity and expression, sexual orientation, or any other status protected by applicable law.

Meridian Cooperative is an equal opportunity employer (Minority/Female/Disabled/Veteran).

We do not sponsor applicants for work visas.