<p>We are seeking a highly skilled Data Engineer to design, build, and manage our data infrastructure. The ideal candidate is an expert in writing complex SQL queries, designing efficient database schemas, and developing ETL/ELT pipelines. This role ensures data accuracy, accessibility, and performance optimization to support business intelligence, analytics, and reporting initiatives.</p><p><br></p><p><strong><em><u>Key Responsibilities</u></em></strong></p><p><br></p><p><strong>Database Design & Management</strong></p><ul><li>Design, develop, and maintain relational databases, including SQL Server, PostgreSQL, and Oracle, as well as cloud-based data warehouses.</li></ul><p><strong>Strategic SQL & Data Engineering</strong></p><ul><li>Develop advanced, optimized SQL queries, stored procedures, and functions to process and analyze large, complex datasets and deliver actionable business insights.</li></ul><p><strong>Data Pipeline Automation & Orchestration</strong></p><ul><li>Build, automate, and orchestrate ETL/ELT workflows using SQL, Python, and cloud-native tools to integrate and transform data from diverse, distributed sources.</li></ul><p><strong>Performance Optimization</strong></p><ul><li>Tune SQL queries and optimize database schemas through indexing, partitioning, and normalization to improve data retrieval and processing performance.</li></ul><p><strong>Data Integrity & Security</strong></p><ul><li>Ensure data quality, consistency, and integrity across systems.</li><li>Implement data masking, encryption, and role-based access control (RBAC).</li></ul><p><strong>Documentation</strong></p><ul><li>Maintain comprehensive technical documentation, including database schemas, data dictionaries, and ETL workflows.</li></ul>
We are looking for an experienced Systems Administrator to join our team in New York, New York. This role is vital to ensuring smooth IT operations, supporting end-users, and maintaining system functionality across various platforms. You will play a key role in providing technical support, managing systems, and collaborating with cross-functional teams to uphold operational excellence.<br><br>Responsibilities:<br>• Act as the primary point of contact for IT support, addressing desktop, hardware, mobile device, and application issues with advanced troubleshooting.<br>• Provide tailored IT assistance to senior leadership and executives, ensuring high levels of discretion and professionalism.<br>• Facilitate onboarding and offboarding processes, deliver user training, and offer guidance on IT systems and tools.<br>• Support and maintain audio/visual technologies for meetings and conference rooms, including platforms like Microsoft Teams and Zoom.<br>• Deploy, configure, and maintain end-user devices such as desktops, laptops, mobile devices, and printers, ensuring compliance with security standards.<br>• Administer user accounts, mailboxes, licenses, and permissions through Microsoft 365 and Entra ID.<br>• Manage shared folder permissions and file system access controls to ensure proper data governance.<br>• Monitor endpoint performance, apply patches, and address security compliance issues in line with organizational policies.<br>• Document system configurations, procedures, and operational standards to maintain accurate records.<br>• Collaborate with vendors and service providers for escalations, licensing, and hardware repairs.