Senior Database Architect & Data Platform Engineer

Compunnel Inc.; New York (NY); Presencial; USD 140.000 - 190.000; Jornada completa

Descripción de la vacante

Compunnel, Inc. is seeking an senior Database Architect / DBA / Data Engineer in New York, NY. The role focuses on designing scalable databases, managing diverse data pipelines, and supporting data warehouses and lakes for enterprise analytics.

You will lead data modeling, governance, and performance tuning across transactional and analytical systems while collaborating with cross-functional teams and cybersecurity stakeholders.

Formación

• 10+ years of experience in database administration or database design.
• Strong experience with enterprise data integration and analytics.
• Advanced proficiency in Microsoft SQL Server.
• Experience with data lakes, data warehouses, and ETL.
• Experience with Power BI, PowerShell, and Python scripting.
• Ability to lead technical initiatives and manage multiple priorities.
• Strong verbal and written communication skills.

Responsabilidades

• Design and maintain enterprise database architectures supporting transactional, analytical, and operational systems.
• Develop conceptual, logical, and physical data models based on business and technical requirements.
• Establish database standards, governance, and data management best practices.
• Design high-availability, disaster recovery, replication, and data resiliency solutions.
• Administer Microsoft SQL Server and other enterprise database platforms.
• Monitor database health, performance, capacity, and availability.
• Perform database tuning, indexing, query optimization, and performance analysis.
• Implement database backup, recovery, replication, and access controls.
• Troubleshoot production database issues and perform root cause analysis.
• Design, develop, and maintain data transformation and load processes and pipelines.
• Support data warehousing, data lake, and lakehouse architectures.
• Develop data cleansing, transformation, validation, and reconciliation processes.
• Support analytics, business intelligence, and reporting initiatives.
• Automate data movement and operational tasks using modern engineering practices.
• Adhere to data governance, metadata management, and master data management standards.
• Ensure data quality, integrity, consistency, and lineage.
• Collaborate with cybersecurity and compliance teams to safeguard data assets.
• Establish role-based access controls and database auditing standards.
• Support regulatory, audit, SOX, and data retention requirements.
• Partner with stakeholders, development teams, infrastructure teams, and contractors.
• Document database administration activities and current projects.

Descripción del empleo

New York, New York

09/18/2026

Contract

Active

Job Description:

Job Summary
The Database Architect / Database Administrator / Data Engineer is a senior technical role responsible for database architecture, administration, optimization, integration, and data engineering. The role will design and maintain scalable, secure, and highly available database solutions while developing and supporting enterprise data pipelines, integrations, data warehouses, data lakes, and reporting platforms. The position requires a balance of hands-on technical expertise, operational support, planning, data governance, and cross-functional collaboration.

Key Responsibilities
• Design and maintain enterprise database architectures supporting transactional, analytical, and operational systems
• Develop conceptual, logical, and physical data models based on business and technical requirements
• Establish database standards, architecture principles, governance frameworks, and data management best practices
• Design high-availability, disaster recovery, replication, and data resiliency solutions
• Administer Microsoft SQL Server and other enterprise database platforms
• Monitor database health, performance, capacity, and availability
• Perform database tuning, indexing, query optimization, and performance analysis
• Implement database backup, recovery, replication, and access controls
• Troubleshoot production database issues and perform root cause analysis
• Design, develop, and maintain organization-level data transformation and load processes and data pipelines
• Support data warehousing, data lake, and lakehouse architectures
• Develop data cleansing, transformation, validation, and reconciliation processes
• Support analytics, business intelligence, and reporting initiatives
• Automate data movement and operational support processes using modern engineering practices
• Adhere to enterprise data governance, metadata management, and master data management standards
• Ensure data quality, integrity, consistency, and lineage across systems
• Collaborate with cybersecurity and compliance teams to safeguard enterprise data assets
• Establish role-based access controls and database auditing standards
• Support regulatory, audit, SOX, and data retention requirements
• Partner with business stakeholders, application development teams, infrastructure teams, and contractors
• Document database administration activities, development environments, current projects, and operational tasks
• Facilitate database architecture reviews and technical design sessions
• Develop and maintain technical documentation, database standards, and operational procedures for current and future environments

Required Qualifications
• 10+ years of experience in database administration or database design
• 5+ years of experience supporting enterprise organizations or large-scale environments
• Demonstrated experience with enterprise data integration and analytics
• Advanced proficiency in Microsoft SQL Server
• Advanced SQL skills, including the ability to develop stored procedures
• Strong database architecture and data modeling expertise
• Deep understanding of relational databases and data integration patterns
• Experience writing SQL scripts for database development and administration
• Experience with data lakes, data warehouses, and data warehouse ETL
• Experience with SSIS and ETL development
• Experience with Power BI
• Experience with PowerShell and Python scripting
• Strong troubleshooting and analytical skills
• Strong understanding of data governance and cybersecurity principles
• Ability to lead technical initiatives and manage multiple priorities
• Strong verbal and written communication skills, with the ability to communicate technical concepts to technical audiences

Preferred Qualifications
• Experience with VBA
• Experience with T-SQL
• Experience with shell scripting
• Experience with lakehouse architectures
• Experience with database performance tuning
• Experience with disaster recovery and backup/recovery solutions
• Experience with database security and access controls
• Experience with capacity planning
• Experience with database automation and monitoring tools
• Experience supporting analytics, business intelligence, and reporting platforms