Cloud Data Engineer

Position: Cloud Data Engineer
Location: Mechanicsburg, PA (ONSITE)
Schedule: Monday-Friday, 8:00AM-5:00PM (Full-Time)

Who We Are:
West Shore Home is a technology-driven and industry-leading home improvement company specializing in high-quality and convenient remodels of Bathrooms, Flooring, Windows, and Doors. West Shore Home operates in over 40+ locations nationwide and is home to over 3,000 employees!

Purpose of Position:
As a Data Engineer at West Shore Home, you will design, develop, test, deploy, and monitor data pipelines using Azure Data Factory, Databricks, and Synapse Analytics required for ELT/ETL from a wide variety of data sources, systems, and platforms that will create solutions and support key stakeholders in informed decision-making across the enterprise.

Key Role Accountabilities:

• Design, develop, test, deploy, and monitor scalable code with Python and SQL and data pipelines using Azure Data Factory, Databricks, dbt, and Synapse Analytics required for ELT/ETL from a wide variety of data sources.
• Create and design solutions from clean, protected, and effective data management practices that directly support informed decision making and innovation.
• Build data quality dashboards and/or monitoring tools to utilize the data pipeline, providing active monitoring and actionable insights into overall data quality and data governance.
• 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 using common web API frameworks and web services.

Minimum Requirements:

• Bachelor’s degree required, with a degree in a related field preferred.
• Minimum of 3+ years of experience with enterprise data management, integration, and transformation tools including Azure Data Factory, Databricks, dbt, Azure Storage, Azure SQL DB, Alteryx, Retool, and Power BI.
• Solid understanding of Git-based version control and experience with GitHub, Azure DevOps, or similar.
• 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

Please note: Applicants must be authorized to work in the United States at the time of their application on a full-time basis. The Company will not sponsor applicants for work visas.

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 here: https://westshorehome.com/community/
#LI-RM1

It is the policy of West Shore Home to provide equal employment opportunity (EEO) to all persons regardless of age, color, national origin, citizenship status, physical or mental disability, race, religion, creed, gender, sex, sexual orientation, gender identity and/or expression, genetic information, marital status, status with regard to public assistance, veteran status, or any other characteristic protected by federal, state or local law. All employees are subject to a pre-employment screening process including a background check and drug screen. In addition, we will provide reasonable accommodations for qualified individuals with disabilities. If you require reasonable accommodation in completing the application, interviewing, completing any pre-employment testing, or otherwise participating in the employee selection process, please direct your inquiries to your recruiter.