Data Engineer: Build Scalable Data Pipelines & Warehouses

The Data Engineer will be responsible for a wide variety of tasks which include all aspects of the development and delivery of data solutions and maintaining the enterprise data warehouse. You will work closely with business analysts, product managers, quality assurance and business stakeholders to effectively implement data solutions. This role will be responsible for building and maintaining data pipelines, optimizing performance of database environments and automating data processes. Responsibilities Develop and deliver data solutions that comply with development standards. Maintain a relational database schema, defining tables, relationships and constraints to ensure data integrity. Build automated processes to Extract, Transform and Load data from various sources into a centralized data warehouse. Optimize complex SQL queries, indexing strategies and execution plans to handle large datasets efficiently. Effectively assist in day-to-day tasks / activities in coordination with a team of developers to meet deliverables and schedules within a larger application project. Lend support to various business and technology teams during design, development and delivery to ensure solid, scalable, robust data solutions. Support and maintain data and database systems to meet business delivery specifications and needs. Exceptional oral and written communication skills, facilitating effective cross‑functional collaboration. Qualifications 5+ years proven experience in: A data‑centric role within a collaborative data and technology team Writing and optimizing complex SQL queries to extract large datasets Using data transformation tools like SSIS Advanced SQL knowledge and proficiency with relational databases Hands‑on experience with data warehouse solutions. Proficiency with the SQL query language, preferably Microsoft T‑SQL. Strong understanding of data modeling and best practices in data governance. Excellent problem‑solving skills and ability to work independently as well as collaboratively to resolve data‑related issues. In lieu of education, the following equivalent experience will be accepted: development life cycle of projects lasting longer than two years, requirements gathering, business and technical designs, development, quality assurance, deployment, support and documentation. Must be flexible, action‑oriented, self‑starting, have strong analytical skills, and be comfortable with a Microsoft SQL business intelligence environment. Familiarity with financial and/or mortgage servicing data but not mandatory. Experience in Azure Data Factory is a plus. Experience in Active Batch scheduling software is a plus. Benefits Medical / Dental / Vision Insurance Life / Disability Insurance 401(k) with company matching Generous Vacation / Paid Time Off (accrual based) Targeted Compensation: $95,000-$120,000 Physical Demands & Working Conditions The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this position. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. While performing the duties of this job: The employee is regularly required to talk or hear. The employee is required to sit for extended periods of time and is occasionally required to stand and walk. The employee must regularly use hands to finger, handle, or feel objects and is regularly required to reach with hands and arms; the employee may occasionally climb or balance, and stoop, kneel, crouch, or crawl. The employee must frequently lift and/or move up to 10 pounds and occasionally lift and/or move up to 25 pounds. Specific vision abilities required by this job include close vision, distance vision, color vision, and ability to adjust focus. The noise level in the work environment is usually quiet to moderate, and no extreme conditions are present. Location Fort Mill, SC St Louis Park, MN Dallas, TX Employee Status Regular Travel No #J-18808-Ljbffr