Lead Data Engineer

Encino, CA

We are currently looking for an experienced and detail-oriented candidate to join our team in for one of our Financial Services Client based out of Encino, CA as Lead Data Engineer. We are looking for this position as a self-motivated contributor working closely with software development teams.

Client wants DATAVAULT AUTOMATION TOOLS EXP as well and this is an onsite opportunity

Location : Local to Greater Los Angelese (LA) area with ability to travel to Encino, CA at least 4 times a week,

Responsibilities:

• Define software feasibility, run data reviews, assess current databases to identify areas in need of improvement, and oversee data development teams.
• Build and maintain Enterprise Data Model including Canonical Data Model to meet the company’s needs
• Understand the Industry latest trends on data strategy and create Innovative solutions.
• Provide updates to stakeholders on product development processes.
• Drive innovation and data strategy by building and improving the data modeling and database design and best practices around Data Modeling/Architecture
• Lead the data committee, gather requirements, and define data models and data solutions.
• Collaborate with stakeholders to understand the organization's data requirements, business objectives, and long-term goals.
• Develop a data strategy that aligns with the overall business strategy and ensures data-driven decision-making.
• Design and develop data models that cater to the specific needs of the organization.
• Establish efficient and robust data integration processes to extract, transform, and load (ETL) data from various sources into the Azure environment. Ensure data quality, consistency, and accuracy during the integration process.
• Experience working on Near Realtime & Realtime (Change Data Capture -CDC , Streaming Data) solutions using tools such as Kafka, Golden Gate etc.
• Experience implementing Medallion Architecture customized for the Client’s needs.
• Experience building ODS and Datawarehouse / Data Lakehouse Solutions
• Design and implement data warehousing solutions using Azure Analytics and Data Platform services such as Databricks, Synapse and MS Fabric to enable scalable storage and efficient data retrieval for analytical processing.
• Establish data governance policies and procedures for data access, usage, and retention.
• Design data visualization solutions for reporting and business intelligence purposes.
• Work closely with cross-functional teams, including developers, data engineers, business analysts, and project managers, to ensure successful implementation of data solutions.

Required Skills and Experiences.

• Experience with MS Fabric, Synapse Analytics, Azure Data Factory, Synapse Data Engineering, Azure Lake, Databricks, Microsoft Purview, Azure Stream Analytics, Azure Dev Ops, and standard Microsoft development environments.
• Experience working with SQL, PL/SQL, Python, PySpark programming Languages and DBT (Nice to have)
• Familiarity of the SDLC and common data warehousing development practices including understanding / Experience in Agile Development
• Experience with Data Quality, Scheduling and SLA management.
• Lead must have done data models with Kimball and data vault type structures as lake houses.

Saurabh Singha

Senior Technical Recruiter

Orion Innovation

333 Thornall Street, Suite 703, Edison, NJ, 08837

M 1-732-384-6135

orioninc.com