Senior Data ETL Engineer: SSIS, SQL Server, Analytics

Accelera; Thomasville (GA); On-site; USD 90,000 - 120,000; Full time

Job summary

Accelera is seeking a Data ETL Engineer to architect and manage robust data pipelines that transform raw information into actionable business intelligence. You will leverage expertise in Microsoft SQL Server technologies to ensure data integrity and drive strategic decision-making across the enterprise.

The role emphasizes designing and implementing scalable ETL workflows, optimizing T-SQL, and developing SSAS models to support advanced analytics.

Qualifications

• Bachelor’s degree in Computer Science or a related field.
• 5+ years of hands-on ETL development with SSIS.
• Advanced proficiency in SQL Server development and T-SQL.
• Demonstrated expertise in data warehousing principles and ETL design methodologies.
• Proven ability to develop and support SSAS tabular or multidimensional models.

Responsibilities

• Design and implement scalable ETL workflows using SSIS.
• Optimize database performance and query efficiency by refining T-SQL code and stored procedures.
• Develop and maintain complex SSAS multidimensional and tabular models to support advanced analytics.
• Automate data integration processes to enhance reliability and reduce manual intervention.
• Collaborate with cross-functional stakeholders to translate business requirements into high-impact data solutions.
• Maintain comprehensive technical documentation, including data mapping, schemas, and flow diagrams.
• Ensure the accuracy and consistency of data across all reporting platforms and warehouse structures.

Skills

SSIS

SQL Server

T-SQL

Data Warehousing

SSAS Models

Analytical Thinking

Education

Bachelor's degree in CS/IS or related field

Tools

Power BI

SSRS

Git

Oracle

Job description

Accelera is seeking a Data ETL Engineer to architect and manage robust data pipelines that transform raw information into actionable business intelligence. You will leverage expertise in Microsoft SQL Server technologies to ensure data integrity and drive strategic decision-making across the enterprise.

The role emphasizes designing and implementing scalable ETL workflows, optimizing T-SQL, and developing SSAS models to support advanced analytics.