Data Engineer

Description

Midwest Loan Services (a division of University Bank) is seeking a .NET Data Engineer with strong expertise in C#, .NET, SQL Server, SSIS, and SSRS, who also has an interest or experience in cloud-based data solutions. This position is ideal for someone with a strong background in SQL Server-based data engineering and .NET development, who is eager to expand their expertise into Azure Data Services, Databricks, and cloud-based API solutions.

General Job Summary

The Data Engineer will focus on developing, maintaining, and optimizing data integration processes, batch jobs, and API development while supporting our transition to an Azure-based data ecosystem. The Data Engineer will work closely with cross-functional teams, contributing to the design, development, and migration of data platforms and APIs, ensuring scalability, reliability, and performance.

Summary of Essential Job Functions

• SQL Server Development & Optimization – Develop, optimize, and maintain SQL Server stored procedures, functions, views, and indexing strategies to ensure high-performance data processing.
• ETL & Data Integration – Design and manage ETL/ELT processes using SQL Server Integration Services (SSIS) and SQL batch jobs to extract, transform, and load data efficiently.
• API Development – Develop, maintain, and optimize .NET-based RESTful APIs for seamless data integration and exchange between applications.
• SSRS & Reporting – Support and enhance SSRS reports and Power BI dashboards to provide critical business insights.
• Data Quality & Governance – Ensure data integrity, consistency, and governance through best practices in data modeling and validation.
• Performance Monitoring & Optimization – Monitor, troubleshoot, and optimize SQL Server databases, APIs, and data pipelines for scalability and reliability.
• Azure Cloud Adoption (Future Roadmap) – Assist in the transition to cloud-based data platforms by supporting Azure Data Factory, Azure Databricks, and Azure Functions initiatives.
• Security & Compliance – Implement data security, authentication, and access control best practices across data and API solutions.
• Collaboration & Stakeholder Engagement – Work closely with business teams, analysts, and developers to translate requirements into scalable data solutions.
• Documentation & Best Practices – Maintain clear documentation for data flows, processes, and API specifications to ensure maintainability and knowledge sharing.
• Operational Support & Troubleshooting – Provide production support for SQL Server-based applications and APIs, addressing performance issues and resolving data discrepancies.
• Process Automation & DevOps – Leverage Azure DevOps CI/CD pipelines for database scripts, API deployments, and process automation.
• Continuous Learning & Innovation – Stay updated on emerging technologies in Azure, .NET, and data engineering, recommending improvements where applicable.

Core Development Stack

• Languages & Frameworks: C#, .NET Core, SQL, T-SQL
• Database & ETL: SQL Server, SSIS, SSRS, Power BI
• API Development: ASP.NET Core Web API, RESTful APIs
• Cloud & Data Services (Future Roadmap): Azure Data Factory, Azure Functions, Azure Databricks, Azure SQL Database, Azure Data Lake
• Streaming & Big Data (Future Roadmap): Delta Lake, Databricks, Kafka (preferred but not required)
• DevOps & Automation: Azure DevOps, CI/CD Pipelines, Git, Infrastructure as Code (IaC)
• Data Governance & Security: Data integrity, performance optimization, access control, compliance best practices
• Project & Collaboration Tools: Jira, Confluence, LucidChart, Smartsheet

Requirements

Education, Training and Work Experience

• Bachelor’s degree in Computer Science, Information Technology, or a related field (or equivalent practical experience).
• 3 years of experience in .NET (C#), SQL Server, SSIS, and API development in a data-driven environment.
• Strong hands-on experience with SQL-based data integration, ETL/ELT processes, and batch job automation.
• Proficiency in designing and developing RESTful APIs using .NET Core for seamless data exchange.
• Experience in performance tuning, query optimization, indexing strategies, and database administration in SQL Server.
• Familiarity with Azure cloud services (Azure Data Factory, Azure Functions, Azure Databricks) is a plus.
• Exposure to DevOps practices, including version control (Git), CI/CD pipelines, and infrastructure automation.
• Strong analytical and troubleshooting skills, with the ability to optimize data pipelines and API performance.
• Experience working in Agile development environments, collaborating with cross-functional teams to deliver scalable solutions.
• Experience in the mortgage servicing or mortgage lending industry is a plus.

Knowledge, Skills, and Abilities

• .NET & API Development – Strong experience in C#, .NET Core, and building RESTful APIs.
• SQL Server & Database Management – Expertise in T-SQL, stored procedures, indexing, performance tuning, and query optimization.
• ETL & Data Integration – Hands-on experience with SSIS, SQL batch jobs, and ETL/ELT processes.
• Reporting & Business Intelligence – Experience with SSRS and Power BI for data visualization and reporting.
• Azure Cloud Services (Nice to Have) – Exposure to Azure Data Factory, Azure Functions, Databricks, and Azure SQL Database.
• Cloud Migration & Modernization – Understanding of moving on-premise data workloads to cloud-based solutions.
• Data Governance & Security – Familiarity with data quality, security, and compliance best practices.
• DevOps & Automation – Experience with Azure DevOps, CI/CD pipelines, and version control (Git).
• Performance Optimization – Ability to monitor, troubleshoot, and fine-tune APIs, ETL pipelines, and databases.
• Agile & Collaboration – Strong ability to work in Agile environments, collaborate with cross-functional teams, and communicate effectively.

Working Environment

Primary working environment is within an indoor climate-controlled office space and/or a private home office or some combination which will be at managements sole discretion. Employee may be subject to florescent lighting, dust, and other normal indoor allergens. Employee may work in close proximity of coworkers and occasionally independently in quiet environments.

Physical Requirements

• Able to lift up to 20 pounds
• May be exposed to extended periods of interaction with others (listening/talking/taking notes)
• Extended periods of sitting (at computer desk)
• Complete repetitive tasks (including operation of computer mouse/keyboard)

Disclaimer

The above statements are intended to describe the general nature and level of work being performed by people assigned to this classification. They are not to be construed as an exhaustive list of all responsibilities, duties, and skills required of personnel so classified. All personnel may be required to perform duties outside of their normal responsibilities from time to time, as needed.

The salary range for this role takes into consideration a wide range of factors including but not limited to the duties of the role, experience, location, and certificates and/or education. The target pay range for this position is between $105,000-$135,000 per year.

**University Bank is an Equal Opportunity / Affirmative Action Employer**

Salary : $105,000 - $135,000