Data Warehouse Engineer

Data Warehouse Developer/Data EngineerRemote (EST / CST preferred candidates) Direct Hire Position Summary:We are seeking a skilled Data Warehouse Developer/Data Engineer to join our team. This role involves analyzing, designing, and developing solutions for Data Warehouse and Business Intelligence projects to address business challenges through data. Responsibilities include modeling, constructing, and populating the Data Warehouse, along with delivering reporting capabilities. The developer will support both on-premises and cloud-based data warehouses, as well as legacy data systems.General Duties and Responsibilities:Participate in all phases of Data Warehouse implementation: requirements gathering, design, development, testing, implementation, and support, ensuring best practices for quality and scalability.Create and maintain logical and physical dimensional data models.Evaluate business rules; perform source-to-target data mappings; design, review, implement, and optimize ETL processes; automate ETL and batch jobs.Implement data integration services between source systems and the Data Warehouse.Productionize data solutions and maintain source control.Implement various levels of data security.Participate in peer code reviews.Create and maintain documentation for work products.Gain knowledge of source systems and their data structures to support the design, development, testing, implementation, and support of data solutions.Provide data analysis and identify data-related issues within the Data Warehouse environment and source systems as needed.Support and maintain existing legacy data solutions.Migrate existing legacy data solutions to the Data Warehouse.Develop and execute queries upon request for business users.Work independently to complete assigned tasks.Qualifications and Experience:Bachelor’s degree in Computer Science, Information Technology, or a related field, or equivalent experience.6+ years of experience with relational databases, SQL, stored procedures, and Data Warehouse systems, utilizing sound Data Warehouse development methodologies.4+ years of experience with ETL and data engineering on the Microsoft Azure Cloud platform, including SQL Server on Azure, Azure Data Factory, and Azure Synapse.Experience with notebooks using PySpark and Python.Proficiency in data cleansing, profiling, validation, and reporting.Experience with SQL Server databases, both on-premises and in Azure Cloud, for building Data Warehouses.Familiarity with data integration tools and techniques.Experience with Power BI.Software development experience is a plus.Strong communication, analytical, and reasoning skills.Proficient with Microsoft Office products.