Lead Data Engineer
Job Location: Atlanta, GA (Onsite)
Job Type: Contract (W2) This is W2 role. Job Description:
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. Must have strong 12+ years of experience.
(W2 Role and H1 Transfer are highly preferrable). 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.
- 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.
- 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 modeling concepts and database design principles.
- Excellent communication and leadership skills, with the ability to effectively collaborate with stakeholders at all levels.
- 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 +
- Demonstrable data modeling experience with Kimball and DataVault architectures
- Demonstrable data transformation experience
- Demonstrable data quality experience
Recommended Jobs
Medical Director, Value Based Care (Atlanta)
Join to apply for the Medical Director, Value Based Care role at Upperline Health 4 days ago Be among the first 25 applicants Join to apply for the Medical Director, Value Based Care role at …
Communications & Development Intern CGHE
Job Description Job Description Salary: CGHE is looking for an intern to support communication and development activities, including generating content for CGHE's social media and newslette…
1st Shift Production Operator
Job Description Job Description United Talent Staffing is immediately hiring 1st Shift Production Operator Associates in the Villa Rica area! Job Duties: Moving material/products throughout …
Bookkeeper with QuickBooks
Bookkeeper with QuickBooks Who: A financial professional with experience in bookkeeping. What: Handle all bookkeeping tasks using QuickBooks, preferably the Desktop version. When: Position …
Emergency Medicine Physician in Jasper, GA
The Blue Ridge Mountains are calling. Are you a dedicated emergency medicine (EM) physician with New Year's resolutions that include: a change in scenery, a re-focus on your health, family, fitness a…
ARRT Technologist
Job Description Job Description ARRT Technologist POSITION SUMMARY The ARRT Technologist performs a variety of imaging procedures and is responsible for patient safety protocols. Func…
Experience Georgian Charm as an ICU Travel Nurse!
Registered Nurse - Intensive Care - ICU - Travel - (ICU RN) Become an ICU Travel Nurse in beautiful Austell, Georgia, where Southern charm meets city excitement! This is your chance to thrive in a re…
Horticulturist/Landscape Manager at Country Club
Centered in the heart of Johns Creek, Georgia, St Ives Country Club has maintained a standard of private club excellence since 1989. We are seeking an experienced full-time Horticulturist/Landscape M…
Children"s House Lead Guide
Are you a passionate, Montessori trained teacher at the 3-6-year-old level? If so, then join us on our mission to dramatically increase the accessibility of authentic Montessori education to children …
Accounts Receivable
Job Description Job Description Assist A/R Manager with daily operations, billing clients in alignment with company procedure and client requirements and working with all personnel. Responsibili…