Senior Data Engineer

$145,000 - $150,000/Yr

Emerald Resource Group - Dublin, OH

Full-time - Mid Level

Onsite - Dublin, OH

Administrative and Support Services

About the position

The Senior Data Engineer is a pivotal role within our organization, responsible for modeling complex problems and developing robust data pipelines. This position requires a deep understanding of ETL processes and the ability to troubleshoot issues within a cloud environment. The Senior Data Engineer will utilize cloud databases, Databricks, and other advanced technologies to support a comprehensive infrastructure that drives large, revenue-generating data strategies. This role is not only about technical execution but also involves collaboration with architects to suggest architectural improvements and mentoring junior engineers in their tasks and approaches. In this hybrid position, the Senior Data Engineer will participate in feasibility discussions to translate business ideas into actionable use cases. They will be responsible for maintaining and updating models in the production environment, developing and enhancing complex ETL processes, and ensuring the smooth transfer of data from PMS to cloud databases. Daily monitoring and troubleshooting of processes are essential, along with thorough documentation of both new and existing processes. The Senior Data Engineer will proactively identify performance issues and recommend enhancements, modernizing legacy data models and pipelines using ETL tools and cloud database capabilities. Collaboration is key in this role, as the Senior Data Engineer will work closely with the Chief Architect to implement improvements and larger architectural changes. They will also support junior team members by answering technical questions, conducting code reviews, and providing guidance on code enhancements. A strong understanding of business problems and needs is crucial, as the Senior Data Engineer will be expected to propose effective solutions that align with the company's core business objectives.

Responsibilities

• Participate in use case feasibility discussions and translate business ideas/problems into use cases.
• Provide support to maintain and update models running in the production environment.
• Develop and maintain complex ETL processes and algorithms.
• Own and enhance ETL processes to move data from PMS to cloud databases.
• Monitor and troubleshoot processes on a daily basis.
• Document new and existing processes.
• Proactively identify performance issues and recommend enhancements.
• Modernize legacy data models and pipelines using ETL tools and cloud database capabilities.
• Collaborate with the Chief Architect to make improvements and larger architectural changes.
• Recommend or suggest improvements to the existing architecture.
• Support junior team members with technical questions, code reviews, and code enhancements.
• Understand business problems/needs and provide proposed solutions.

Requirements

• 6+ years of data analysis experience.
• Expertise in algorithm design, machine learning, and applied statistics.
• Proven track record in SQL, specifically in cloud databases, and working with data.
• Bachelor's degree in Business, Computer Science, Information Systems, or equivalent combination of education and experience.
• Ability to work effectively with people of various backgrounds and education levels.
• Strong communication skills to timely and effectively convey information and consult with others.
• Responsible, trustworthy, and ethical behavior in decision-making.
• Proficient written communication skills with attention to proper grammar, spelling, and document formatting.
• Adaptability in problem-solving, evaluating tasks from multiple perspectives, and finding creative solutions.
• Timely completion of assigned job tasks.
• Preparation for meetings and presentations with follow-up to ensure task fulfillment.
• Commitment to achieving the company's core business objectives.

Nice-to-haves

• Experience working with healthcare professionals in a clinical setting.
• Problem-solving experience in ambiguous situations.
• Thorough experience with Databricks, Glue, Talend, Informatica, or similar ETL tools.
• Cloud database experience (Redshift, BigQuery).
• Highly motivated with excellent interpersonal, problem-solving, and technical skills.
• Strong sense of urgency, accountability, and adaptability.
• Proven ability to work effectively in a team.
• Passion for data and attention to detail.
• Ability to take calculated risks based on data-driven analytics.
• Self-starter with a passion for working in a fast-paced environment.

Benefits

• Choice of Medical, Dental, and Vision Plans with no waiting period.
• Voluntary Life Insurance and AD&D.
• Critical Illness, Accident, and Hospital Indemnity Coverage.
• Voluntary Long-Term Disability available.
• Health Savings Account & Flexible Spending Account options available.
• Onsite Flu Shots & Biometric Screenings.
• Fertility & Family Planning Benefits.
• Paid Parental Leave policy.
• Associate Recognition Program.
• Professional Development and Growth.
• Employee Resource Groups (PRIDE, Women, Race & Ethnicity, Parents & Caregivers).
• Up to 15 PTO days in the first year of employment for hourly associates.
• Flexible PTO policy for salaried associates.
• 11 Paid Holidays.
• Casual Dress/Work Environment.
• Corporate Wellness Program.
• Quarterly Wellness Challenges with Cash Prizes.
• Mental Health Resources.
• Companywide Associate Assistance Program.
• Competitive Salary.
• 401K Employer Match and Roth Option Available.
• Immediate eligibility for Prudential Financial Wellness Program.
• 100% Company Paid Basic Life and AD&D Insurance.
• Adoption Assistance Program.
• Pet Insurance.