Orion Innovation · 3 days ago
Lead Data Engineer
Wonder how qualified you are to the job?
Insider Connection @Orion Innovation
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.
Qualification
Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.
Required
Bachelor’s or master’s degree in computer science, Engineering, or a related field.
8 to 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.
Preferred
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 +
Company
Orion Innovation
Orion Innovation is an IT services and solutions provider helping organizations with Digital Transformation services.
H1B Sponsorship
Orion Innovation has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Trends of Total Sponsorships
2023 (72)
2022 (124)
2021 (165)
2020 (220)
Funding
Current Stage
Late StageTotal Funding
unknown2018-10-22Acquired· by One Equity Partners
2015-01-07Undisclosed· Undisclosed
Recent News
2024-05-29
2024-05-27
Company data provided by crunchbase