<p>We are looking for an experienced Database Architect to oversee the management, optimization, and security of our database platforms. This role involves administering both on-premises Microsoft SQL Server and cloud-based systems such as Azure SQL, Microsoft Fabric, and Snowflake. You will ensure the performance, availability, and compliance of enterprise data assets while collaborating with cross-functional teams to support data-driven initiatives across the organization.</p><p><br></p><p>Responsibilities:</p><p>• Manage and maintain database systems, including Microsoft SQL Server and cloud environments such as Azure SQL and Snowflake.</p><p>• Develop and implement backup, restore, and disaster recovery protocols, ensuring alignment with recovery objectives and conducting regular tests.</p><p>• Design high-availability configurations and capacity plans to support organizational data needs.</p><p>• Optimize database performance by monitoring query execution, addressing bottlenecks, and improving resource utilization.</p><p>• Build and maintain data pipelines for ingestion and integration into Snowflake, utilizing tools like Microsoft Data Gateway and secure file transfers.</p><p>• Strengthen database security through role-based access control, encryption, and adherence to data retention policies.</p><p>• Automate routine database tasks using scripts and tools such as PowerShell and Azure SQL.</p><p>• Monitor database platforms using alerts, dashboards, and automated tools to ensure system health and reliability.</p><p>• Support audits and regulatory examinations by providing evidence of database configurations and resolving findings.</p><p>• Collaborate with analytics, infrastructure, and security teams to ensure seamless data connectivity, modeling, and secure vendor integrations.</p>
<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 Data Engineer to join our team in New York, New York. In this role, you will design, build, and maintain data infrastructure to support business intelligence and analytics needs. The ideal candidate will have a strong technical background, a passion for working with complex datasets, and expertise in cloud-based data platforms.<br><br>Responsibilities:<br>• Develop, implement, and optimize ETL pipelines to ensure efficient data processing and integration.<br>• Design and maintain scalable data solutions, including data warehouses and data lakes.<br>• Collaborate with cross-functional teams to identify data requirements and deliver actionable insights.<br>• Utilize Snowflake, AWS, and other cloud-based platforms to manage data infrastructure and ensure performance optimization.<br>• Leverage Python and SQL to build robust data workflows and automate processes.<br>• Employ orchestration tools like Airflow and dbt to streamline data operations.<br>• Support data analytics and visualization efforts by enabling the creation of impactful dashboards using tools such as Tableau.<br>• Work with marketing and product data sources, including platforms like Google Analytics, to extract and integrate valuable insights.<br>• Implement CI/CD pipelines and DevOps practices to enhance data engineering processes.<br>• Ensure data security and compliance across all systems and tools.
We are looking for an experienced Data Analyst to join our team on a long-term contract basis in New York City, New York. This role involves leveraging data to identify patterns, detect anomalies, and provide actionable insights to enhance decision-making processes. The ideal candidate will have strong analytical skills and expertise in fraud investigation and prevention.<br><br>Responsibilities:<br>• Analyze large datasets to uncover trends, anomalies, and patterns that indicate potential fraud.<br>• Develop and implement fraud detection strategies using advanced analytics and tools.<br>• Collaborate with cross-functional teams to enhance fraud prevention mechanisms and policies.<br>• Conduct thorough investigations into suspected fraudulent activities and provide detailed reports.<br>• Create visual representations of data findings to effectively communicate insights to stakeholders.<br>• Utilize anti-fraud techniques to mitigate risks and safeguard organizational assets.<br>• Maintain accurate and organized records of investigations and analytical processes.<br>• Monitor and evaluate the effectiveness of fraud prevention strategies and recommend improvements.<br>• Stay updated on industry trends and emerging technologies related to fraud analytics.<br>• Provide training and support to team members on fraud detection tools and methodologies.
<p>We are looking for a Network Administrator who can support multiple locations remotely and onsite. This position has the potential to travel to local and national sites. You will be handling tier 1 support to basic networking experience, handling tickets and walk-ins. You must be able to prioritize different tickets and tasks based off priorities.</p><p><br></p><p>In this position you will be responsible for break and fix tasks, setting up users in Active Directory, and following SOPs and knowledge based articles to troubleshoot issues.</p><p><br></p>