ETL Database Developer

The ETL/Database Developer will play a crucial role in the continued effort of designing, implementing, and optimizing our company infrastructure while collaborating with cross-functional teams to deliver meaningful data solutions. They will have strong experience with SQL and Python, and a deep understanding of data warehousing concepts, ETL frameworks, data modeling, and API-based data integration. This role will report to the Information Systems Manager.

Responsibilities

• Design, develop, and maintain scalable data pipelines and ETL processes using SQL and Python.
• Integrate data from external systems using RESTful APIs.
• Design and implement database structures for new applications and enhancements.
• Extract, transform, and load (ETL) data from various sources into data warehouses or data marts, ensuring data accuracy and consistency.
• Optimize and fine-tune SQL queries and data models for optimal performance & responsiveness.
• Monitor database performance and apply necessary changes, patches, and updates.
• Create complex functions, stored procedures, and triggers to support application development.
• Develop and maintain data pipelines, data integration processes, and data cleansing procedures.
• Implement data governance practices, ensuring data quality, security, and compliance with relevant regulations.
• Perform regular maintenance tasks such as backups, restores, and data purging.
• Implement and manage data security measures including access controls and firewalls.
• Troubleshoot and resolve database functionality issues and user-reported problems.
• Participate in data architecture and modeling discussions to ensure the scalability and flexibility of BI solutions.
• Document ETL workflows, data mappings, and system architecture.
• Collaborate with business stakeholders to gather requirements and translate them into effective BI solutions that address data analysis and reporting needs.
• Implement automation of various functions in Acumatica and various other supporting 3rd party systems related to departmental needs.
• Stay current with industry trends and best practices in BI and data analytics, bringing innovative ideas to enhance the organization's data capabilities.
• Collaborate with third-party IT support vendors as needed and ensure they are informed when projects affect them or the services they provide or manage.
• Assist with data capture, planning, and implementation of new software releases and cross-functional assignments.