SQL Data Engineer — ETL & Data Warehouse Specialist

Collaborate Solutions, Inc; Columbia (TN); On-site; USD 80,000 - 110,000; Full time

Job summary

Collaborate Solutions, Inc. in Columbia, TN is seeking a SQL Data Developer (SSIS or SSRS) to build and maintain data acquisition, transformation, and integration solutions for operational, reporting, and analytical uses.

The role focuses on loading data into the data warehouse, optimizing SQL, and collaborating with business and IT teams to define data extracts and processes, while adhering to governance standards.

Qualifications

• Experience building high‑performing data flows and ETL processes.
• Strong SQL development skills with complex queries and procedures.
• Ability to work with stakeholders to define data and analytics needs.
• Knowledge of relational and dimensional data structures.
• Experience with ETL tools such as SSIS, Informatica, Talend, Data Migrator is preferred.
• Familiarity with data warehousing patterns (Kimball, Inman, Data Vault) is preferred.
• Experience with Agile Scrum or Kanban is preferred.
• Awareness of data privacy practices and laws is preferred.

Responsibilities

• Develop and support ETL processes to extract, transform, and load data into the data warehouse.
• Assist operation of the Data Warehouse during business hours and on-call rotations.
• Define data extracts and scheduling with business and IT stakeholders.
• Adhere to architecture standards and best practices defined by the Data Architect.
• Optimize SQL code and database structures for performance.
• Document data processes and data structures for maintainability.
• Provide back-end data integration support to other teams.
• Investigate and document current data flow across corporate systems.

Skills

SQL development

Tools

SSIS

Data Migrator

Informatica

Talend

Job description

Collaborate Solutions, Inc. in Columbia, TN is seeking a SQL Data Developer (SSIS or SSRS) to build and maintain data acquisition, transformation, and integration solutions for operational, reporting, and analytical uses.

The role focuses on loading data into the data warehouse, optimizing SQL, and collaborating with business and IT teams to define data extracts and processes, while adhering to governance standards.