Orion Innovation is a premier, award-winning, global business and technology services firm. Orion delivers game-changing business transformation and product development rooted in digital strategy, experience design, and engineering, with a unique combination of agility, scale, and maturity. We work with a wide range of clients across many industries including financial services, professional services, telecommunications and media, consumer products, automotive, industrial automation, professional sports and entertainment, life sciences, ecommerce, and education.
Job Title: Lead Data Engineer
Location: Chennai (5 days Work from Office)
Experience Level: 4 PM IST to 10 PM IST
Shift Timings: Second shift
Role Overview: As a Lead Data Engineer, you will play a crucial role in designing, developing, and maintaining our data infrastructure. You will lead a team of data engineers to ensure the successful delivery of projects and contribute to the overall data strategy. The ideal candidate will have extensive experience in cloud-based data technologies, particularly in Azure, and a proven track record of implementing scalable and efficient data solutions.
Responsibilities:
- The Lead Data Engineer is responsible for overseeing the data warehouse implementation, ensuring that data practices align with the strategic goals of wealth and asset management services.
- The role involves managing data analytics and data warehousing projects, developing, and implementing data models, and leading a team of data Analysts.
- Design and implement comprehensive data strategies that enhance decision-making capabilities across wealth and asset management portfolios.
- Lead the development and maintenance of scalable data models and databases within a modern EDW.
- Ensure data integrity, quality, and compliance with industry regulations.
- Create high-level conceptual data models that define the essential entities and their relationships, capturing the broad scope of the organization’s data landscape.
- Translate conceptual models into logical data models that detail the structure of the data without being tied to any specific database technology. These models include attributes, keys, and the relationships between entities.
- Implement logical data models into physical schemas optimized for the specific technologies used within the EDW, considering performance and storage requirements.
- Utilize dimensional modelling techniques, such as star schemas and snowflake schemas, which are particularly effective for data warehousing in financial reporting and analytics.
- Design fact tables and dimension tables to support the organization’s business intelligence tools and data warehousing needs.
- Develop and enforce data modelling standards and practices to ensure consistency and quality across the data warehouse.
- Work with data governance teams to ensure that data handling meets compliance requirements and industry standards for data privacy and security.
- Translate complex data findings into actionable insights and strategic recommendations.
Skills required:
- Bachelor’s or master’s degree in computer science, Engineering, or a related field.
- 12+ years of experience in data engineering, with a focus on Microsoft technologies.
- Proficiency in Azure data services, including Azure Databricks, Azure Synapse Analytics, and Azure Data Factory.
- Hands-on experience with Microsoft SQL Server Integration Services (SSIS).
- Strong understanding of data modelling concepts and database design principles.
- Excellent communication and leadership skills, with the ability to effectively collaborate with stakeholders at all levels.
- Experience working in an Agile development environment is preferred.
- Certifications in relevant technologies (e.g., Microsoft Certified: Azure Data Engineer Associate) is a plus.
- Prior experience of working on Data strategy in Wealth Management industry will be a big +
Must have :
demonstrable data modeling experience with Kimball and DataVault architectures
- demonstrable data transformation experience
- demonstrable data quality experience
Orion is an equal opportunity employer, and all qualified applicants will receive consideration for employment without regard to race, color, creed, religion, sex, sexual orientation, gender identity or expression, pregnancy, age, national origin, citizenship status, disability status, genetic information, protected veteran status, or any other characteristic protected by law.
Candidate Privacy Policy
Orion Systems Integrators, LLC and its subsidiaries and its affiliates (collectively, “Orion,” “we” or “us”) are committed to protecting your privacy. This Candidate Privacy Policy (orioninc.com) (“Notice”) explains:
- What information we collect during our application and recruitment process and why we collect it;
- How we handle that information; and
- How to access and update that information.
Your use of Orion services is governed by any applicable terms in this notice and our general Privacy Policy.
Top Skills
What We Do
Orion is a leading digital transformation and product development services firm. Headquartered in Edison, NJ, we have a global team of 6,200+ associates, with engineers in 14 major delivery centers across North America, Europe, Asia Pacific and Latin America.
For over 25 years, Orion has been solving complex business problems for our clients. Our transformative business solutions are rooted in digital strategy, experience design, and engineering, empowering our clients to operate with agility at scale.
Our mission is to serve as an agile and trusted partner for business transformation initiatives, providing deep emerging technology, experience design, and domain expertise.
Our business has more than tripled over the last three years.
We have grown aggressively both organically and inorganically, adding new clients, complementary skills, domain expertise, and strengthening our global footprint.
