Data Engineer

Federal Soft Systems - Buffalo, NY

Full-time

Buffalo, NY

Professional, Scientific, and Technical Services

About the position

The Data Analyst/Engineer role involves designing, developing, and maintaining ETL processes and frameworks to facilitate efficient data management. This position requires collaboration with cross-functional teams to understand data needs and deliver insights, while also implementing cloud-based solutions to ensure data security and scalability.

Responsibilities

• Design, develop, and maintain ETL processes and ETL frameworks to ensure efficient data extraction, transformation, and loading.
• Write and optimize complex SQL queries and stored procedures to support data analysis and reporting needs.
• Utilize Python for data manipulation, analysis, and automation tasks.
• Collaborate with cross-functional teams to understand data requirements and deliver actionable insights.
• Implement and manage cloud-based data solutions, ensuring data security and scalability.
• Monitor and troubleshoot data pipelines to ensure data integrity and availability.
• Develop and maintain documentation for data processes, systems, and workflows.

Requirements

• Proven experience in ETL processes and ETL frameworks.
• Strong proficiency in SQL, including writing complex queries and stored procedures.
• Proficiency in Python for data analysis and automation.
• Experience with cloud platforms such as AWS, Azure, or Google Cloud.
• Excellent problem-solving skills and attention to detail.
• Strong communication and collaboration skills.