Senior Database Architect & Data Platform Engineer

Compunnel, Inc.; Northern, New York (KY, NY); On-site; USD 140,000 - 190,000; Full time

Job summary

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.

Qualifications

• 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.

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, 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.

Job description

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.