Lead Data Engineer / Data Architect

Ness USA, Inc. is seeking an experienced Lead Data Engineer / Data Architect to lead the design, development, and implementation of its enterprise data platform. This role involves shaping the data engineering roadmap, ensuring scalability and performance, and driving innovation. The ideal candidate will possess deep technical expertise in data architecture, modeling, and pipeline development, particularly within the financial services data domain, and strong leadership skills to mentor teams and collaborate with stakeholders.

Must Have

• Lead data architecture and engineering strategy
• Design and implement data models, pipelines, and integration frameworks
• Partner with stakeholders to translate business requirements into scalable data solutions
• Optimize data pipelines for performance, scalability, and reliability in Snowflake
• Drive adoption of best practices in data engineering design patterns and cloud architectures
• Implement and monitor data validation for accuracy and consistency
• Collaborate with project managers, data architects, and business analysts
• Mentor and guide data engineering teams (onsite & offshore)
• Ensure compliance with data governance, security, and privacy standards
• Create and maintain detailed documentation of data pipelines and transformation logic
• Troubleshoot and resolve issues related to data pipelines
• Bachelor’s degree in Computer Science, Information Technology, or related field
• 8+ years of experience in data engineering with a strong focus on Data Architecture, Data Modelling, ELT processes and data pipeline development
• Hands-on experience with Snowflake cloud data platform
• Proficiency in SQL
• Familiarity with data integration and ETL/ELT tools
• Experience with AWS Technologies (Glue, EMR)
• Proficiency in Python for data engineering workflows
• Strong understanding of data engineering design patterns
• Strong problem-solving skills
• Excellent communication skills

Good to Have

• Certifications in Snowflake or relevant data technologies
• Experience in the financial services sector, especially asset management / alternative investments
• Familiarity with cloud platforms (e.g., AWS, Azure)
• Knowledge of data orchestration tools (e.g., Apache Airflow)
• Knowledge of data visualization tools (e.g., Tableau, Power BI)

Perks & Benefits

• Flexible remote options
• Diverse projects
• Access to development resources
• Inclusive workplace

Description

Position at Ness USA, Inc.

Job Title: Lead Data Engineer / Data Architect

Location: New York City, NY; Secondary location - Boston, MA (Onsite – 5 days/week)

About the Role:

We are seeking an experienced Lead Data Engineer / Data Architect to spearhead the design, development, and implementation of our enterprise data platform. This role will be instrumental in shaping and driving our data engineering roadmap, ensuring scalability, performance, and innovation. The ideal candidate combines deep technical expertise with strong leadership skills and a solid understanding of financial services data domains.

Key Responsibilities:

• Lead the data architecture and engineering strategy, ensuring alignment with business and technology roadmaps.
• Design and implement data models, pipelines, and data integration frameworks across multiple platforms.
• Partner with stakeholders to translate business requirements into scalable data solutions.
• Performance Optimization: Optimize data pipelines for performance, scalability, and reliability, including query tuning and resource management within Snowflake.
• Drive adoption of best practices in data engineering design patterns and modern cloud architectures.
• Data Quality Assurance: Implement and monitor data validation procedures to ensure data accuracy and consistency across systems.
• Collaboration and Communication: Work closely with project managers, data architects, and business analysts to align project milestones and deliverables with business goals.
• Mentor and guide data engineering teams (onsite & offshore) to deliver high-quality outcomes.
• Ensure compliance with data governance, security, and privacy standards.
• Documentation: Create and maintain detailed documentation of data pipelines, data flow diagrams, and transformation logic.
• Issue Resolution: Troubleshoot and resolve issues related to data pipelines, including job failures and performance bottlenecks.

Required Qualifications:

• Bachelor’s degree in Computer Science, Information Technology, or a related field.
• 8+ years of experience in data engineering with a strong focus on Data Architecture, Data Modelling (Conceptual, Logical, Physical), ELT processes and data pipeline development.
• Hands-on experience with Snowflake cloud data platform, including data sharing, secure views, and performance optimization.
• Proficiency in SQL and familiarity with data integration and ETL/ELT tools.
• AWS Technologies (Glue, EMR)
• Python for data engineering workflows
• Strong understanding of data engineering design patterns
• Strong problem-solving skills and the ability to work independently to meet deadlines.
• Excellent communication skills for effectively interacting with technical and non-technical stakeholders.

Preferred Qualifications:

• Certifications in Snowflake or relevant data technologies.
• Experience in the financial services sector, especially asset management / alternative investments, with an understanding of data security and compliance requirements.
• Familiarity with cloud platforms (e.g., AWS, Azure) and data orchestration tools (e.g., Apache Airflow).
• Knowledge of data visualization tools (e.g., Tableau, Power BI).

Why Join Us:

At Ness, you will work with diverse, talented professionals who are dedicated to making an impact through technology. We encourage applicants of all backgrounds to apply—even if you don’t meet every requirement, we’d love to connect with you if this role excites you. We’re committed to creating an inclusive workplace that celebrates each team member’s unique talents.

With flexible remote options, diverse projects, and access to development resources, joining Ness means building a career that’s meaningful and impactful.

Ready to Start Your Journey?