What are the responsibilities and job description for the Sr. Fullstack Data Engineer | New York, NY – Hybrid Role | Fulltime position at Next Gen Software Solutions LLC?
Role: Sr. Fullstack Data Engineer
Location: New York, NY – Hybrid Role
Duration: Long term
Employment Type: Fulltime
Position Summary:
We’re hiring a Senior Full Stack Developer focused on Data Engineering to help build and scale a modern enterprise data platform supporting Portfolio Management, Trading, Risk, Compliance, Middle Office Operations, and Finance. This is a new headcount on a globally distributed Data Platform Engineering team (NYC Mumbai) operating in a high delivery agile environment.
This role is hands-on and centered on building robust, scalable pipelines, designing multi-layered database structures with increasing refinement, and delivering curated, semantic data products that power reporting, analytics, and API-driven consumption — including enabling AI/agent workflows on top of trusted datasets.
What You’ll Do
- Design and build scalable ingestion and transformation pipelines to acquire new critical data sources (near real-time where needed).
- Build and optimize database structures across three layers of refinement (raw →refined → curated) to support complex reporting and analytics.
- Develop curated data products and semantic models/metric definitions to enable broad self-serve BI and consistent consumption across teams.
- Deliver data via APIs (REST and GraphQL) to enable end-user application data exchange and internal tooling.
- Analyze and improve existing datasets and pipelines for:
- data quality
- pipeline performance
- brittle integrations
- query performance and concurrency
- Operate in a controlled SDLC environment with code reviews, approvals, change management, validation, and documentation.
Participate in production support / on-call rotation.
Key Responsibilities
What we’re looking for (Must-haves):
- Senior-level, hands-on expertise building end-to-end data pipelines database structures semantic data products.
- Strong Python and/or Java engineering skills in production environments.
- Deep experience with cloud data platforms (Azure preferred) and modern warehousing (Snowflake strongly preferred).
- Strong understanding of data flow architecture: ingestion → transformation → storage layers → semantic layer → consumption (BI APIs).
- Front end experience (React
- Proven performance tuning skills across pipelines and warehouses:
- query optimization, clustering/partitioning strategies, warehouse sizing, Spark optimization, caching patterns, etc.
- Experience supporting near real-time data needs at scale (millions of rows daily).
- Strong communication skills and ability to collaborate in a globally distributed, agile team.
- Comfort operating in a high-expectation, fast-paced environment with production ownership/on-call.
- Asset management / financial data experience (front office operational/master/reference data exposure).
Nice-to-haves:
- Strong experience building and deploying services using Kubernetes and Docker
- Private Equity data experience.
- BI enablement experience (semantic modeling for Tableau/Power BI/Sigma/Pyramid) or analytics engineering background.
- Experience designing event-driven patterns and data products to support AI/agent workflows.
About Next Gen Software Solutions LLC:
Next Gen Software Solutions is a trusted provider of IT Staffing and consulting services dedicated to empowering businesses with cutting-edge technology solutions and exceptional talent. We specialize in delivering tailored IT consulting services, innovative software solutions, and connecting businesses with highly skilled IT professionals. Founded and led by a dedicated U.S. Army solider, Next Gen Software Solutions is deeply rooted in the core values of integrity, discipline, commitment, and experience-principles that guide every aspect of our operations.
Equal Employment Opportunity Statement:
Next Gen Software Solutions LLC is an Equal Opportunity Employer. We are committed to fostering an inclusive and diverse workplace where all employees and applicants are treated respect and dignity. We do not discriminate based on race, colour, religion, sex (including pregnancy, sexual orientation, or gender identity), national origin, age, genetic information, veteran status, or any other legally protected characteristic under applicable federal, state, or local laws.
About Next Gen Software Solutions LLC:
Salary : $140,000 - $145,000