Position Overview: Next Gen Software Solutions LLC is seeking an experienced Data Architect with a minimum of 12+ years of expertise in Data Architecture, Data Modelling, and Data Pipeline Development for a long-term, W2 position. The ideal candidate will have hands-on experience with Data Cataloging (preferably using Alation), Python development, advanced SQL skills, and a deep understanding of finance-related data systems. Experience with Snowflake, ISO20022/BIAN standards, data lineage tools like Manta, and building robust data pipelines is essential. This position requires onsite presence in Berkeley Heights, NJ, for all 5 working days. The selected candidate will be employed through Next Gen Software Solutions LLC on W2. Key Responsibilities: • Data Architecture Design: Design, implement, and maintain enterprise-level data architectures to support business needs, with a focus on scalability, data governance, and high performance. • Data Cataloging: Use Alation or similar tools for data cataloging to ensure proper data documentation, accessibility, and traceability across the organization. • Data Pipeline Development: Develop and optimize data pipelines to efficiently ingest and transform data, particularly in cloud environments like Snowflake. • Data Modeling: Design and maintain both logical and physical data models, ensuring data consistency and efficiency across various systems and platforms. • SQL & Excel Expertise: Write complex, optimized SQL queries for data analysis, reporting and transformation. Extensive experience with Excel, including macros, to automate data processing and reporting. • Data Lineage & Governance: Utilize Manta or similar tools to track, document, and visualize data lineage, ensuring proper data flow and governance practices. • Compliance with Standards: Apply ISO20022 and BIAN financial standards to design and integrate data systems. • Collaboration & Mentorship: Work closely with both business and technical teams to ensure alignment with overall business goals. Provide guidance to junior team members. • Problem-Solving: Address complex data-related issues, ensuring high-quality data management and integrity across all systems. Required Skills & Qualifications: • Minimum 10+ years of experience in Data Architecture. • Minimum 12+ years of experience in Data Modeling. • Minimum 7+ years of experience in Data Analysis. • Experience with Data Cataloging tools, preferably Alation, Collibra, or similar platforms. • Strong Python development experience, particularly in ETL processes, data transformations, and automation (3+ years). • Expertise in building data pipelines for platforms like Snowflake or similar cloud-based data warehouses. • Advanced proficiency in SQL for complex querying, performance tuning and optimization (experience with MongoDB, Oracle, SQL Server). • Proficient in Excel, including the ability to write macros for data automation and reporting. • Experience in Data Lineage using tools like Manta to ensure data flow transparency and governance. • Card Industry experience (5+ years) – working with data systems specific to the card/payment industry. • Excellent verbal and written communication skills with the ability to collaborate with both technical and non-technical teams. • Strong interpersonal skills to work effectively within cross-functional teams. • Deep understanding of the finance domain, including familiarity with financial regulations, compliance, and data reporting. Preferred Qualifications: • Familiarity with cloud platforms (AWS, Azure, GCP) and big data technologies (Hadoop, Spark, etc.). • Experience working with Agile and Scrum methodologies. • Mainframe experience (a plus). • Knowledge of ISO20022 and BIAN standards for financial data systems (a plus). Education: • Bachelor’s or Master’s degree in Computer Science, Information Systems, or a related field. 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 on the basis of race, color, 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: 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 soldier, Next Gen Software Solutions is deeply rooted in the core values of integrity, discipline, commitment, and excellence—principles that guide every aspect of our operations.