Lead Data Architect

At Staffworxs, we don't just connect talent — we power transformation. Headquartered in Frisco, TX, with teams in Bengaluru and Hyderabad, we combine global reach with deep expertise. Our Digital & Data Analytics practice drives growth and innovation for some of the world's top Client brands, who continue to retain us as their trusted partner. If you're ready to make an impact, you're in the right place. Job Details Title: Lead Data Engineer / Data Architect Location: New York City, NY (Hybrid– 3 days/week) Duration: Long term Contract Industry: Financial Services / Asset Management / Alternative Investments Skills Required: Data Architecture | Data Modelling | SQL | Python | AWS (Glue, EMR) | Snowflake | Data Engineering Design Patterns | Data Governance | Financial Data Domain Job Description We are seeking an experienced Lead Data Engineer / Data Architect to lead the design, development, and implementation of an enterprise-grade data platform for our financial services client. This role will be key in defining and driving the organization's data engineering strategy, ensuring scalability, performance, and innovation. The ideal candidate brings deep technical expertise, proven leadership skills, and a strong understanding of financial data domains. Key Responsibilities: • Lead data architecture and engineering strategy, aligning with overall business and technology roadmaps. • Design and implement data models, pipelines, and integration frameworks across multiple platforms. • Partner with stakeholders to translate business requirements into scalable, high-performance data solutions. • Optimize data pipelines for performance, scalability, and reliability, including query tuning and resource management within Snowflake. • Drive adoption of data engineering best practices and modern cloud architectures. • Implement and monitor data validation and quality procedures to ensure data accuracy and consistency. • Collaborate closely with project managers, data architects, and business analysts to align milestones and deliverables. • Mentor and guide onsite and offshore data engineering teams to deliver high-quality solutions. • Ensure adherence to data governance, security, and privacy standards. • Maintain comprehensive documentation of data pipelines, data flows, and transformation logic. • Troubleshoot and resolve pipeline issues, 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, and pipeline development. • Hands-on experience with the Snowflake platform, including data sharing, secure views, and performance optimization. • Proficiency in SQL and familiarity with ETL/ELT tools and AWS technologies (Glue, EMR). • Strong working knowledge of Python for data engineering workflows. • Solid understanding of data engineering design patterns and cloud data ecosystems. • Excellent analytical and problem-solving skills with the ability to work independently. • Strong communication and collaboration skills for engaging both technical and non-technical stakeholders. Preferred Qualifications: • Snowflake or other relevant data engineering certifications. • Prior experience in asset management or alternative investments, with exposure to data security and compliance requirements. • Familiarity with data orchestration tools (e.g., Apache Airflow) and data visualization platforms (e.g., Tableau, Power BI). Staffworxs is an Equal Opportunity Employer. We celebrate diversity and are committed to creating an inclusive workplace for all employees, regardless of race, color, religion, gender, sexual orientation, national origin, age, disability, or veteran status.