Job Description
Insight Global is seeking a Sr. Data Engineer to partner with our client's Lead Data Architect in designing, scaling, and managing a modern enterprise analytical data warehouse. This role is ideal for a hands-on professional who can bridge business requirements with technical solutions, helping to build a cloud-native, high-performance data platform supporting BI, analytics, and emerging AI use cases. Key Responsibilities include:
Data Architecture & Engineering
-Design and implement dimensional data models (Kimball/star schema) to support enterprise reporting and analytics
-Build and optimize ETL/ELT pipelines using modern cloud platforms (Azure Synapse, Microsoft Fabric, Data Factory, etc.)
-Contribute to Lakehouse and medallion architectures (Bronze/Silver/Gold) for scalable data processing
-Improve performance, scalability, and reliability across large datasets and analytic workloads
-Support development of semantic data layers (Power BI / SSAS) and enterprise reporting frameworks
Platform Governance & Integration
-Apply and maintain data governance, lineage, and security standards (e.g., RBAC, PII protection, auditability)
-Integrate data from multiple enterprise sources (databases, APIs, cloud storage, external systems)
-Contribute to establishing architecture standards, reusable patterns, and best practices
Collaboration & Delivery
-Partner with the Lead Data Architect and stakeholders to translate business needs into scalable solutions
-Work closely with data engineers, BI developers, and analysts to deliver end-to-end analytics solutions
-Participate in architecture design sessions, code reviews, and solution validation
-Promote engineering best practices, documentation, and knowledge sharing within the team
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
-8+ years of experience in data engineering
-Experience contributing to data design/architecture
-Data Warehousing experience
-Strong experience with data modeling (dimensional/Kimball) and enterprise data warehouse design
-Hands-on experience with Azure data ecosystem (Synapse, Data Factory, Data Lake, SQL)
-Experience building and maintaining ETL/ELT pipelines and data integration workflows
-Proficiency in SQL and data transformation tools
-Experience with BI tools such as Power BI or SSAS
-Exposure to AI/ML-enabled data platforms or advanced analytics workflows
-Strong ability to translate business requirements into scalable data solutions
-Hands-on builder experience with an ownership mindset and attention to detail
-Collaborative team player who thrives in a cross-functional, fast-paced environment
Nice to Have Skills & Experience
-Experience with Microsoft Fabric or modern Lakehouse architectures
-Familiarity with DevOps practices (CI/CD, version control)
-Understanding of data governance tools and frameworks (e.g., lineage, cataloging)
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.