Senior Data Warehouse Architect

AWS and Snowflake

We are assisting one of our esteemed enterprise clients, a global retail leader, in their search for a highly skilled and experienced Senior Data Warehouse Architect. This critical role will play a pivotal part in driving the company's data warehousing transformation and modernizing their data infrastructure.

Responsibilities:

• Lead the design, development, and implementation of enterprise-grade data solutions leveraging cloud technologies, primarily AWS, with a strong focus on Snowflake.
• Architect and implement data pipelines, data lakes, and data warehouses to support business intelligence, data science, and machine learning initiatives.
• Develop and maintain data models, schemas, and metadata repositories.
• Ensure data quality, security, and compliance with industry best practices and regulatory requirements.
• Collaborate closely with data engineers, data scientists, business analysts, and other stakeholders to understand business requirements and translate them into technical solutions.
• Mentor junior team members and provide guidance on best practices in data architecture and engineering.
• Stay abreast of the latest advancements in data technologies and industry trends.
• Effectively communicate technical concepts to both technical and non-technical audiences.
• Work collaboratively with team members across different cultures and time zones.

Qualifications:

• Bachelor's degree in Computer Science, Engineering, or a related field.
• 8+ years of experience as a Data Architect or a similar role.
• Proven expertise in designing and implementing data warehousing solutions on AWS, with a strong emphasis on Snowflake.
• Deep understanding of data modeling techniques (dimensional modeling, data vault) and data warehousing best practices.
• Strong experience with SQL, Python, and other scripting languages.
• Experience with data integration tools and technologies (ETL/ELT tools, data pipelines).
• Experience with data governance and data quality initiatives.
• Excellent communication, interpersonal, and presentation skills.
• Ability to work independently and as part of a team.
• Strong analytical and problem-solving skills.
• Experience working in an agile environment is a plus.
• Experience with cloud-native technologies (AWS services like S3, Redshift, EMR) is a plus.

Benefits:

• Competitive salary and benefits package.
• Opportunity to work on challenging and impactful projects.
• Collaborative and supportive work environment.
• Opportunity to learn and grow within a global organization.

Sesheng is an equal opportunity employer and value diversity at our company. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status.

Validation and IT Systems Specialist

West Windsor, NJ (Hybrid: 3 days in office)

We are seeking a highly motivated and experienced Validation and IT Systems Specialist to join our dynamic team. This role combines expertise in validation and computer system validation (CSV) with IT administrative support for regulated systems and applications. You will play a critical role in ensuring the compliance of our IT systems with 21 CFR requirements and supporting the smooth operation of our regulated business processes.

Key Responsibilities:

Validation Expertise

• Ensure compliance with 21 CFR requirements for FDA-regulated systems.
• Conduct and manage GMP assessments for instruments and categorize them appropriately.
• Develop and execute validation strategies, protocols, and reports to meet regulatory and business requirements.
• Collaborate with cross-functional teams to manage the validation lifecycle for new and existing systems.

IT Administrative Support

• Provide administrative support for IT systems and applications, ensuring smooth operations in a regulated environment.
• Manage system configurations, troubleshooting, and maintenance in collaboration with IT teams.
• Support the software development lifecycle, ensuring alignment with validation and compliance standards.

Technical Understanding

• Maintain a foundational understanding of IT infrastructure, including networking, connectivity, and application configurations.
• Work effectively with technical teams to support system implementation, upgrades, and issue resolution.

Adaptability and Problem Solving

• Proactively address challenges in a fast-paced, deadline-driven environment.
• Prioritize tasks effectively and ensure timely completion of projects.
• Demonstrate sound judgment and common sense in navigating complex scenarios.

Hardware Qualifications

• Servers: Physical and virtual servers hosting regulated applications.
• Storage Systems: Network-attached storage (NAS) or storage area networks (SAN).
• Workstations: User endpoints interacting with validated systems.
• Peripherals: Printers, scanners, and other auxiliary devices used in regulated processes.

Networking

• Switches and Routers: Ensure proper installation and configuration of network devices.
• Firewalls: Validate security configurations and data flow integrity.
• Connectivity: Test and document network performance, including latency and bandwidth.

Operating Systems (OS)

• Installation and configuration of operating systems supporting validated applications.
• Patch management and periodic updates to ensure compliance and security.

Database Systems

• Qualification of database servers and configurations ( Oracle, SQL Server) hosting regulated data.
• Backup and recovery processes.

Virtualization Platforms

• Virtual machines and hypervisors (VMware, Hyper-V).
• Ensure proper allocation of resources and isolation of environments.

Security and Access Control

• User authentication (Active Directory, LDAP).
• Role-based access controls (RBAC) and segregation of duties.

Disaster Recovery and Backup

• Backup systems, procedures, and recovery testing.
• Validation of data integrity during recovery processes.

Environmental Controls

• Physical security of data centers (access control, fire suppression).
• Environmental conditions (temperature and humidity monitoring).

IT Infrastructure Qualification Process

• System Risk Assessment: Evaluate the impact of the infrastructure on regulated systems. Categorize components based on risk and regulatory significance.
• Documentation:
• IQ Protocol: Define the installation and configuration steps.
• Test Scripts: Include checks for hardware, network, OS, and database configurations.
• Validation Summary Report: Summarize testing results and confirm compliance.
• Installation Qualification (IQ): Verify hardware and software components are installed per manufacturer specifications.
• Operational Qualification (OQ): Test the functionality of infrastructure components under normal and stress conditions.
• Performance Qualification (PQ): Validate the infrastructure's ability to support operational requirements over time.
• Change Control: Implement and document processes for infrastructure updates, patches, and changes.

Qualifications

• Education: Bachelor’s degree in a relevant field such as Computer Science, Life Sciences, or Engineering.
• Experience: Minimum 8 years of experience in validation and/or IT systems support, preferably in FDA-regulated environments. Proven expertise in computer system validation (CSV) and GMP compliance. Familiarity with IT infrastructure, including networking and application configuration.
• Skills: Strong understanding of FDA regulatory requirements and 21 CFR compliance. Excellent problem-solving and prioritization abilities. Strong interpersonal and communication skills for cross-functional collaboration.

We are an Equal Opportunity Employer and value diversity in our company. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status. We are committed to building a diverse and inclusive workforce where everyone feels valued, respected, and empowered to succeed.

.NET API Developer with Python Experience

We are seeking a skilled and experienced .NET API Developer with Python expertise to join our team. This role will focus on building and maintaining data pipelines, creating reports, and developing integrations with various systems. The ideal candidate will have a strong understanding of .NET API development, solid Python programming skills, and experience with data manipulation and reporting. Experience with PlainID is required.

Responsibilities:

• Design, develop, and maintain robust and scalable .NET APIs.
• Develop and implement data pipelines using Python.
• Create and automate reports using various data sources.
• Integrate systems using APIs and other integration methods.
• Collaborate with other developers and stakeholders to understand requirements and deliver solutions.
• Troubleshoot and resolve issues related to APIs, data pipelines, and integrations.
• Ensure code quality and adherence to best practices.
• Participate in code reviews and contribute to the team's knowledge sharing.
• Stay up-to-date with the latest technologies and trends in .NET and Python development.

Qualifications:

• 5-7 years of experience in .NET API development.
• Strong proficiency in Python programming.
• Experience with data pipeline development and ETL processes.
• Experience creating reports and visualizations.
• Experience with system integration using APIs.
• Experience with PlainID is required.
• Solid understanding of software development principles and best practices.
• Excellent problem-solving and analytical skills.
• Strong communication and collaboration skills.
• Bachelor's degree in Computer Science or a related field preferred.

Desired:

• Experience with cloud platforms (AWS, Azure, GCP).
• Experience with database technologies (SQL Server, MySQL, PostgreSQL).
• Experience with Agile development methodologies.

Sesheng Company is an equal opportunity employer and values diversity at our company. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, gender identity, gender expression, age, marital status, veteran status, or disability status. All qualified applicants will receive consideration for employment without regard to these characteristics. We are committed to creating an inclusive environment for all employees.

IT Help Desk Technician

Location: Hillsborough, NJ

Duration: 6 months

Hours: 40 hours per month

The IT Help Desk Technician assists in managing our ticketing system, MDM software, and AWS platform while overseeing the onboarding and offboarding IT activities associated with employee profiles.

Position Responsibilities:

• Research end-user issues independently, when needed, and document/develop solutions per company standards.
• Responsible for all onboarding and offboarding related IT activities, including system-wide access, purchasing and retrieving equipment, upgrades, asset tagging, etc.
• Create Exchange rules to address spam/phishing emails as needed.
• Collaborate with the IT Engineering team to drive systemic improvements to the email filtering system.
• Promptly respond to user requests via the ticketing system, phone calls, and IM.
• Assist users with access/system issues.
• Write and update documentation for user reference.

Required Qualifications:

• 6+ years of experience in a Help Desk role (preferably in a medium or larger company).
• A customer-oriented approach to problem resolution.
• Experience supporting Windows and Mac hardware/OSX in a Help Desk environment.
• Experience supporting remote users in a distributed environment.
• Experience with Jira Service Desk or a similar ticketing system.
• Experience with the Office 365 suite.

Sesheng Company is an equal opportunity employer. We are committed to creating an inclusive environment for all employees and believe that diverse teams lead to better innovation and results. We do not discriminate on the basis of race, religion, color, sex, national origin, age, disability, genetic information, or any other legally protected characteristic.