Data Engineer

Data EngineerWest 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 PositionAs 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.Key Role AccountabilitiesDesign, 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.Minimum RequirementsBachelor'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.BenefitsComprehensive Health Insurance options (Medical, Dental, Vision, Accident, Life, Critical Illness, Short and Long-Term Disability)401(k) Retirement Plan with company matchHSA plan with company matchPaid holidays and paid time off (PTO)Employee Referral ProgramEmployee Discount ProgramPaid training and unlimited professional growth potentialPlease 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.