Remote Senior Software Development Engineer (ETL/AWS)

Description:

• Design, develop, and implement ETL processes for data extraction, transformation, and loading from multiple data sources to both on-premises and cloud-based data warehouses.
• Develop scalable and efficient full-stack applications, including both front-end and back-end components.
• Develop and maintain APIs to facilitate data acquisition, integration, and communication between systems.
• Perform data analysis, reduce data errors and inconsistencies to find relevant insights, and support business decision-making.
• Collaborate with business analysts, data architects, and other team members to analyze source data, improve data accuracy and integrity, implement data reporting, and understand data and application requirements to create effective solutions.
• Improve and automate ETL processes, applications, and APIs for performance and scalability in both on-premises and cloud environments.
• Provide production support, including monitoring, troubleshooting, and resolving issues related to ETL processes, data integrity, APIs, and full-stack applications.
• Develop documentation for overall processes, data mappings, data flows, APIs, application code, and support procedures.
• Effectively able to perform impact analysis and explain technical processes to many audiences.
• Ensure data and application security and compliance with relevant data protection regulations.
• Participate in code reviews and provide constructive feedback to peers.
• Stay current with the latest industry trends and best practices in ETL development, full-stack development, API development, data analysis, and cloud technologies.

Requirements:

• Bachelor's degree in computer science, Information Technology, or a related field.
• 8+ years of overall experience in ETL development, data warehousing, API, and cloud services.
• Proficient in DataStage ETL tool with an understanding of data integration, transformation, and loading processes.
• Proficient in scripting languages such as Shell scripting, Perl, and Python.
• Experience with API development and frameworks such as REST and SOAP.
• Experience with the AWS cloud platform and its services, such as AWS Glue, Redshift, S3, EC2, and Lambda.
• SQL proficiency with relational databases (e.g., DB2 on AIX) and AWS databases (e.g., Amazon RDS, Amazon Aurora PostgreSQL).
• Front-end technologies like React, and Angular.
• Experience with version control systems like Git or Bitbucket.
• Experience in data analysis, including proficiency with tools such as Excel, Python, or Tableau.
• AWS certification.
• Familiarity with automotive business know-how, data warehousing concepts, and best practices.
• Experience with Agile development methodologies.

Benefits:

• Great compensation package and annual performance-based bonus target of 15%.
• You begin accruing 4 weeks of vacation per year starting on your first day.
• 401K with a 4% company match with immediate vesting.
• Comprehensive health, dental, and vision plans.
• 5 sick days each calendar year.
• 12 paid company holidays and 2 paid volunteer days.