Data Engineer: ETL & BI Pipeline Expert

AAA National; Town of Florida (NY); On-site; USD 90,000 - 115,000; Full time

Benefits offered by this job

Annual Incentive Plan

Competitive compensation

Job summary

AAA, Inc. in New York State seeks an experienced Data Engineer to design, build, and optimize data solutions that enable business decisions. You will manage ETL processes, SQL queries, and BI platforms to ensure high-quality data for analysis, reporting, and growth.

You will collaborate with partners and other data engineers to support data warehouse operations, troubleshoot applications, and enhance data integration across multiple systems, including cloud warehouses.

Qualifications

• Bachelor's degree in a related field.
• 4 to 7 years of professional experience in data engineering, data integration, BI, or related fields.
• Strong experience with ETL development, data integration, and data quality processes.
• Hands-on experience supporting and troubleshooting BI and digital marketing applications.
• Proficiency with BI and digital marketing platforms such as Hive, Tableau, and Salesforce.
• Experience with ETL tools such as Redpoint, Informatica, or similar technologies.
• Advanced knowledge of Microsoft SQL Server, including DDL and DML operations.
• Experience using cloud-based data warehousing platforms such as Snowflake and migrating data from legacy systems is highly desired
• Strong troubleshooting skills related to relational databases and data integration processes.
• Experience using workflow automation tools.
• Ability to analyze, configure, integrate, and support complex data-driven applications.

Responsibilities

• Design, execute, and support data engineering solutions using ETL technologies, SQL, and BI platforms.
• Load, manage, validate, and perform quality assurance on data from AAA clubs and third-party sources.
• Maintain and enhance data pipelines that support the organization's data warehouse environment.
• Analyze, troubleshoot, and optimize BI and digital marketing applications to ensure data accuracy and system performance.
• Collaborate with a team of data engineers to support business initiatives and data-driven decision-making.
• Configure, integrate, and maintain business intelligence and digital marketing platforms.
• Create, execute, troubleshoot, and improve ETL processes using data from multiple sources.
• Utilize Microsoft SQL Server to manage, manipulate, and optimize data storage and retrieval activities.
• Investigate and resolve relational database issues using SQL and graphical administration tools.
• Support workflow automation initiatives that improve operational efficiency and data processing.
• Contribute to system administration activities that support the stability and performance of the data environment.

Skills

ETL development

Data integration

Data quality

SQL

Workflow automation

Education

Bachelor's degree in related field

Tools

Hive

Tableau

Salesforce

Redpoint

Informatica

Microsoft SQL Server

Snowflake

Job description

AAA, Inc. in New York State seeks an experienced Data Engineer to design, build, and optimize data solutions that enable business decisions. You will manage ETL processes, SQL queries, and BI platforms to ensure high-quality data for analysis, reporting, and growth.

You will collaborate with partners and other data engineers to support data warehouse operations, troubleshoot applications, and enhance data integration across multiple systems, including cloud warehouses.