Data Engineer

It's fun to work in a company where people truly BELIEVE in what they're doing!

We're committed to bringing passion and customer focus to the business.
 

Ready to take the next step in your career journey?

We're committed to bringing passion and customer focus to the business. Ready to take the next step in your career journey?

FHI is hiring a junior to mid-level Data Engineer fluent in SQL and Python to build, debug, and maintain production data pipelines and system integrations. You’ll own these pipelines end to end, partnering with the Business Intelligence team to deliver reliable data, actionable insights and process automation across the business. This role requires comfort reading, understanding, and improving existing systems, not just building greenfield solutions.

We use a combination of SQL Server, Snowflake, Fivetran, and Python with a heavy emphasis on the Pandas library. Experience with these exact technologies is nice but not required. If you have a solid SQL and Python foundation you will be able to pick up our specific tools quickly.

Key Responsibilities

• Build and maintain ETL pipelines that ingest and validate source-system data with minimal transformation.
• Design and implement SQL transformation layers that translate that raw source-system data into analyst-ready models.
• Build and maintain data integrations via inbound and outbound APIs.
• Independently troubleshoot data failures, across the entire data pipeline.
• Automate manual processes and improve data delivery and reliability.
• Create clear documentation (ETL processes, object usage, data models) and test/validate code changes.

Required Skills & Abilities

• Strong SQL skills: able to encapsulate complex logic and messy data into simple, consistent models for analysts.
• Practical experience with Python (Pandas nice to have).
• Experience integrating external systems via inbound and outbound APIs.
• Understanding of logging, error handling, and control flow required to operate production data pipelines.
• Solid grasp of data architecture and modeling (normalized/denormalized, star/snowflake).
• Experience using version control with a team, ideally Git.
• Excellent analytical thinking, problem solving, and communication skills.
• Proven ability to work independently, manage priorities, and deliver in a rapidly changing environment.

Education & Experience

• Bachelor’s in Computer Science, or equivalent experience. Non-traditional candidates are welcome; feel free to share a github link to a project you’re proud of.
• Experience maintaining data pipelines and integrations across SQL Server/Snowflake or similar environments.
• Experience supporting data ingestion from enterprise systems (i.e. Workday, other ERP or HR platforms) and delivering data for downstream reporting.
• Experience with BI or reporting platforms. We primarily use PowerBI, SSRS, and Workday Reports, but if you have strong fundamentals matter more than specific tool experience.
• Relevant certifications are nice to have but not required.

Physical Requirements

• Prolonged periods of sitting and working on a computer.

Location: Remote (U.S.) role with working hours aligned to Eastern Time (ET). Candidates in Central Time are welcome if able to work an ET schedule. Strong preference for candidates based in North Carolina.

Compensation:

• Determined by experience, skills, and role fit.

By submitting this application, you are providing consent for FHI to contact you via phone (call or text) or email.  This job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the associate for the job.  Duties, responsibilities, and/or activities may change at any time with or without notice. FHI provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws. Additional Location: If you like wild growth and working with happy, enthusiastic over-achievers, you'll enjoy your career with us!

Additional Location:

If you like wild growth and working with happy, enthusiastic over-achievers, you'll enjoy your career with us!