Data ETL Engineer

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

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

About the Role

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

Responsibilities

• Design and implement scalable ETL workflows using SSIS to streamline data movement and transformation.
• 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.

Required Skills

• Bachelor’s degree in Computer Science, Information Systems, or a related technical field.
• 5+ years of hands-on experience building and maintaining ETL solutions 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.
• Strong analytical mindset with a focus on complex problem-solving.

Preferred Skills

• Experience working with Oracle database environments.
• Proficiency in Power BI and SSRS for data visualization and reporting.
• Familiarity with version control systems such as Git.
• Experience in enterprise-level data warehouse architecture and design.