ETL Developer DBA

BinTech Group; Nashville (TN); Hybrid; USD 95,000 - 125,000; Full time

Job summary

BinTech Group is seeking a data engineer to join the Data Services team in Nashville. You will design, build, and maintain scalable ETL pipelines to move data from diverse sources into our data platforms, ensuring quality and accessibility.

You will model and optimize data architectures with architects, integrate data across databases and APIs, manage data warehouses or lakes, improve performance, and document pipelines and data dictionaries for governance.

Qualifications

• Experience with data modeling, schema design, and data warehousing concepts.
• Strong knowledge of ETL tools and data integration techniques.
• Database administration or tuning background preferred.
• Familiarity with data visualization tools (Tableau, Power BI) is a plus.

Responsibilities

• Data Pipeline Development: Design, build, and maintain scalable ETL pipelines to extract, transform, and load data from various sources into data systems.
• Data Modeling and Architecture: Collaborate with data architects to design data models and optimize database structures.
• Data Integration: Integrate data from databases, APIs, streaming platforms, and external providers.
• Data Warehouse Management and Administration: Manage storage/retrieval in data warehouses or data lakes, with partitioning and indexing strategies.
• Performance Optimization: Identify bottlenecks and optimize workflows, queries, and indexing to reduce latency.
• Collaboration and Documentation: Work with cross-functional teams and document pipelines, data dictionaries, and specs.

Skills

Data modeling

Schema design

Data warehousing concepts

ETL tools

Data integration techniques

SQL

Problem solving

Communication

Tools

Tableau

Power BI

Airflow

SQL Server

Job description

In this role you'll be a key asset to the Data Services team s by performing a variety of functions including:
Data Pipeline Development: Design, build, and maintain scalable and efficient data pipelines to extract, transform, and load (ETL) data from various sources into the organization's data systems. This includes sourcing, cleansing, and transforming raw data to ensure data quality and integrity.
Data Modeling and Architecture: Collaborate with data architects to design and implement data models that align with business requirements. Optimize database structures and schemas to support efficient data retrieval, processing, and analysis.
Data Integration: Integrate data from different sources and systems, including databases, APIs, streaming platforms, and external data providers. Ensure seamless data integration across various platforms and applications.
Data Warehouse Management and Adminstration: Manage and optimize data storage and retrieval processes in data warehouses or data lakes. Implement and maintain appropriate data partitioning, indexing, and compression strategies to enhance data accessibility and performance.
Performance Optimization: Identify and resolve performance bottlenecks in data processing and storage. Optimize data workflows, queries, and indexing strategies to improve system efficiency and reduce latency.
Collaboration and Documentation: Collaborate with cross-functional teams, including data scientists, analysts, and software engineers, to understand data requirements and provide data engineering support. Document data pipelines, data dictionaries, and technical specifications to facilitate knowledge sharing and maintain data lineage.
Data Security and Compliance: Implement data security measures, including access controls, encryption, and anonymization techniques, to protect sensitive data. Ensure compliance with data privacy regulations and industry standards.
What's my work style?
Excellent written and verbal communication skills
Relationship builder
Flexible, collaborative approach to meet changing priorities and business needs
What experience do I need?
Experience with data modeling, schema design, and data warehousing concepts.
Strong knowledge of ETL tools and data integration techniques.
Database administration or tuning background is preferred.
Familiarity with data visualization tools (e.g., Tableau, Power BI) is a plus.
Strong problem-solving and analytical skills.
Excellent communication and collaboration ability

Requirements

Candidate has to be local to Nashville, TN

Experience with data modeling, schema design, and data warehousing concepts.

Strong knowledge of ETL tools and data integration techniques.

Database administration or tuning background is preferred.

Familiarity with data visualization tools (e.g., Tableau, Power BI) is a plus.