Data Engineer

Job Description

As a Data Engineer II, you will provide expertise in data engineering tools and platforms within a defined domain. You will identify development and support needs, take on design responsibilities for data pipelines and transformations, and support operational readiness. This role facilitates collaboration across teams to ensure data solutions align with business goals and downstream consumers.

• Design, develop, and maintain robust, scalable, and secure data pipelines using Azure Data Factory.

• Build and maintain curated data models in SQL Server to support analytics, reporting, and operational workloads.

• Develop and optimize complex SQL queries, views, and stored procedures for performance and reliability.

• Implement data ingestion, transformation, and loading patterns across multiple source systems.

• Collaborate with cross‑functional teams to translate business requirements into technical data solutions.

• Write clean, efficient, well‑documented, and maintainable pipeline and transformation code.

• Participate in code reviews and contribute to shared data engineering standards and best practices.

• Ensure data pipeline performance, scalability, reliability, and security, including appropriate access controls.

• Design and maintain data quality, pipeline health, and monitoring metrics; support alerting and operational runbooks.

• Develop and maintain technical documentation in compliance with IT policies and standards.

• Troubleshoot and resolve complex data and pipeline issues; participate in root cause analysis.

• Mentor and guide junior engineers through reviews and knowledge sharing.

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to View email address on click.appcast.io learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy:

Skills and Requirements

• Bachelor’s degree in computer science, engineering, or a related field (or equivalent practical experience).

• 5+ years of experience in data engineering or related roles.

• Strong expertise in SQL Server, including performance tuning and data modeling

Hands‑on experience building and supporting pipelines with Azure Data Factory.

• Experience working with .NET C# and Azure

Solid experience with data migration and transformation

• Experience with source control in Git and Azure DevOps.

• Familiarity with Agile development methodologies (Scrum, Kanban)

• Strong problem‑solving skills, attention to detail, and effective communication skills - Experience with Azure data platform components Azure SQL and Azure Storage

• Experience implementing data quality, governance, or lineage practices

• Knowledge of Financial Services or Banking data domains.

• Prior experience leading data initiatives or mentoring engineers.