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 HR@insightglobal.com.To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/.
Required Skills & Experience
- 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
Nice to Have Skills & Experience
- 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.
Benefit packages for this role will start on the 1st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.