Database Engineer

Bayview Asset Management, LLC; New York (NY); Hybrid; USD 140,000 - 160,000; Full time

Benefits offered by this job

Incentive bonus

Hybrid work locations

Job summary

Bayview Asset Management, LLC is seeking a Database Engineer to design, develop, and maintain data-driven solutions. You will build ETL pipelines, collaborate with analysts to translate requirements into technical specs, and implement data quality and governance practices.

You will design data models, maintain schemas, and optimize SQL performance while ensuring security and compliance across data platforms. Hybrid role with multiple office locations in the US.

Qualifications

• This role requires experience in data integration, ETL, and database development.
• Familiarity with data management principles and DB technologies is essential.
• Strong knowledge of SQL, data modeling, and data quality practices.

Responsibilities

• Design, build, and maintain data integration and ETL pipelines.
• Collaborate with analysts and data scientists to translate requirements into specs.
• Develop data models, schemas, and dictionaries for efficient storage.
• Implement data quality checks and data governance practices.
• Write efficient SQL queries, procedures, and functions for ETL workflows.
• Optimize performance via indexing and query tuning.
• Ensure data security and compliance with access controls.

Skills

ETL Tools

SQL

Python

Informatica

SSIS

Talend

JSON

Data Modeling

Education

Bachelor's degree in CS/IS

Tools

SQL Server

Oracle

PostgreSQL

Job description

Overview

The Database Engineer will be responsible for designing, developing, and maintaining data-driven solutions that support our organization's data management and analytics initiatives. Your expertise in data integration, ETL processes, and database technologies will play a key role in delivering high-quality data solutions and driving data-driven decision-making across the organization.

Responsibilities

• Design and develop data-driven solutions, including data integration processes, ETL workflows, and data transformation pipelines.
• Collaborate with business analysts, data scientists, and other stakeholders to understand data requirements and translate them into technical specifications.
• Develop and maintain data models, database schemas, and data dictionaries to ensure accurate and efficient data storage and retrieval.
• Implement data quality checks and validation processes to ensure data integrity and accuracy.
• Design and implement data integration processes to extract data from various sources, transform it into a consistent format, and load it into target systems.
• Develop and maintain ETL workflows and scripts using industry-standard tools and frameworks.
• Optimize data integration processes for performance, scalability, and reliability.
• Monitor and troubleshoot data integration jobs, identifying and resolving issues and performance bottlenecks.
• Design, develop, and maintain database structures and schemas to support data storage and retrieval needs.
• Write efficient SQL queries, stored procedures, and functions to extract, transform, and load data.
• Optimize database performance through indexing, query optimization, and performance tuning techniques.
• Ensure data security and compliance by implementing appropriate access controls and data protection measures.
• Contribute to data governance initiatives by defining and enforcing data standards, policies, and procedures.
• Document data integration processes, ETL workflows, and database structures to facilitate knowledge sharing and maintain system documentation.
• Collaborate with data stewards and data owners to ensure data quality, consistency, and compliance with regulatory requirements.
• Collaborate with cross-functional teams, including data analysts, business intelligence developers, and data scientists, to understand their data requirements and support their analytics needs.
• Stay updated on emerging trends and technologies in data management, ETL, and database technologies.
• Identify opportunities for process improvement, automation, and innovation, and contribute to the continuous improvement of data services within the organization.

Qualifications

• Bachelor’s degree in Computer Science, Information Systems, or a related field (or equivalent work experience).
• Proven experience as a Developer III or a similar role, demonstrating strong expertise in data integration, ETL processes, and database development.
• In-depth knowledge of data management principles, data integration best practices, and database technologies (e.g., SQL Server, Oracle, PostgreSQL).

Skills

• Experience with ETL tools and frameworks (e.g., Python, Informatica, SSIS, Talend, JSON) and data integration patterns and methodologies. Proficiency in writing complex SQL queries, stored procedures, and functions.
• Strong understanding of data modeling concepts and techniques.
• Familiarity with data governance frameworks and data quality management practices.
• Excellent problem-solving and analytical skills, with the ability to analyze complex data requirements and design optimal solutions.
• Strong attention to detail and the ability to work with large datasets effectively.
• Excellent communication and interpersonal skills, with the ability to collaborate effectively with cross-functional teams and stakeholders at all levels.

LOCATION AND COMPENSATION

• This role will be hybrid and can be based in Bayview’s either Coral Gables, Fort Lauderdale, Denver or NYC Office.
• The compensation offered for this will be between $140,000 - $160,000 and will depend on experience.
• There is also a incentive based bonus available.
• Salary may vary based on work experience, market conditions, location, and qualifications/training.*

PHYSICAL DEMANDS AND WORK ENVIRONMENT

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

While performing the duties of this job, the employee is regularly required to sit and use hands to handle, touch or feel objects, tools, or controls. The employee frequently is required to talk and hear. The noise level in the work environment is usually moderate. The employee is occasionally required to stand; walk; reach with hands and arms. The employee is rarely required to stoop, kneel, crouch, or crawl. The employee must regularly lift and/or move up to 10 pounds. Specific vision abilities required by this job include close vision, color vision, and the ability to adjust focus.

EEOC

Bayview is an Equal Employment Opportunity employer. All aspects of consideration for employment and employment with the Company are governed on the basis of merit, competence and qualifications without regard to race, color, religion, sex, national origin, age, disability, veteran status, sexual orientation, or any other category protected by federal, state, or local law.