Data Engineer
Location: Mechanicsburg, PA (ONSITE)
Schedule: Monday-Friday, 8:00AM-5:00PM (Full-Time)
About the role
As a Data Engineer at West Shore Home, you will design, develop, test, deploy, and monitor data pipelines between multiple sources, systems, and platforms. This position is responsible for creating solutions that directly support informed decision making and innovation by providing clean, protected, and effective data management practices.
Responsibilities
- Design, develop, test, deploy and monitor data pipelines using Azure Data Factory and Databricks required for ELT/ETL from a wide variety of data sources.
- Design, develop, test, deploy and monitor scalable code with Python and SQL in Databricks, dbt, and other platforms.
- Integrate source systems with information management solutions and target systems for automated migration processes (e.g., Source-of-record systems with data warehouses or other systems).
- Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, and redesigning infrastructure for greater scalability.
- Lead data migration efforts for mergers and acquisitions.
- Assist Data Architect in leading the migration of data from legacy systems to newly developed solutions.
Requirements
- Bachelor’s degree required, with a degree in a related field preferred.
- Minimum of 2+ years of experience with enterprise data management, integration, and transformation tools including Azure Data Factory, Databricks, dbt, Azure Storage, Fivetran, and Sigma.
- Experience with integration and API tools.
- Follow and lead best practices on all data security, retention, and privacy policies.
- Proven subject matter expert for how systems handle data and develop ELT/ETL solutions based on best practices, their experience, and knowledge of the Company’s goals.
Benefits
- Comprehensive Health Insurance options (Medical, Dental, Vision, Accident, Life, Critical Illness, Short and Long-Term Disability)
- 401(k) Retirement Plan with company match
- HSA plan with company match
- Paid holidays and paid time off (PTO)
- Employee Referral Program
- Employee Discount Program
- Paid training and unlimited professional growth potential
Culture and Community
We believe that when employees feel valued and supported, they perform at their best. Our dedication to fostering a strong, value-driven culture has consistently earned us the Top Workplaces USA award as one of the nation’s top employers, including recognition in Leadership, Purpose & Values, and Compensation & Benefits. West Shore Home strives to Bring Happiness to Every Home® and that goes beyond our customers and employees. We support positive change in our communities by volunteering, giving back, and supporting nonprofits that make a difference.
Learn more about our community efforts.