Data Engineer

In this role, the Data Engineer supports and builds end-to-end data pipelines across both on-premise environments (roughly 65% of the time) and the Azure cloud (about 35%), working as part of a small, collaborative team that includes two other Data Engineers and a Data Scientist. On a daily basis, they are designing, developing, and maintaining ETL workflows using SSIS—extracting data from various sources, performing data cleansing and validation, and integrating it into downstream systems to ensure accuracy and reliability. They also serve as an administrator within SSAS, building and maintaining data models, supporting analytical structures, and ensuring data is optimized and accessible for reporting and business intelligence. In close collaboration with the other engineers, they help troubleshoot pipeline issues, optimize performance, and share best practices across the data ecosystem, while partnering with the Data Scientist to ensure datasets are properly structured and readily available for advanced analytics and modeling.

Additionally, they leverage Databricks to process and manage large-scale datasets, supporting more complex data transformations and analytics use cases. The role involves hands-on coding in Python and SQL to automate workflows, enhance pipeline efficiency, and manage operational tasks. While the majority of the work focuses on core data engineering responsibilities, there is also exposure to emerging tools like Microsoft Fabric and occasional work within Linux environments, contributing to a modern, evolving data platform.

$110,000 to $126,000 - Exact compensation may vary based on several factors, including skills, experience, and education.

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/.

• 3-5 years in a Data Engineering role
o Supporting and building data pipelines on prem (65% of the time) and Azure cloud (35% of the time)
• SSIS (SQL Server Integration Services) for ETL, data cleansing and validation, data integration
• SSAS (SQL Serve Analysis Services) - serving as an admin for data building data models
• Experience with Databricks for large scale data
• Coding experience with python and SQL

• Experience with Fabric
• Familiarity with Linux
• Experience building data pipelines in an GCP environment

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.