Sr. Data Engineer

Akaasa Technologies; United States; Sur place; USD 120 000 - 180 000; Plein temps

Résumé du poste

Collins Aerospace is seeking a seasoned Data Engineer to design, develop, and maintain data pipelines and a modern data platform. You will leverage Snowflake, Matillion, and Tableau to deliver robust analytics capabilities and trusted data assets.

Strong SQL, data modeling, and data quality practices are essential. The role involves collaboration with cross-functional teams to translate data requirements into scalable solutions, and the ability to communicate insights clearly in a fast-paced

Qualifications

• U.S. Citizen required.
• Bachelor's degree in computer science, computer engineering, information systems, or a technical field with 5+ years of relevant experience; or 10+ years of data engineering experience.
• 10+ years of experience in Data Engineering focusing on designing, implementing, and optimizing data pipelines.
• Proven experience with Snowflake, Matillion, Alteryx, and Tableau or comparable ETL/RDBMS technologies.
• Strong SQL skills with complex queries, joins, and aggregations; experience with data modeling and data quality.
• Experience developing dashboards and visuals using Tableau; ability to translate data requirements to business insights.
• Excellent written and verbal communication for cross-functional collaboration.

Responsabilités

• Design, develop, and maintain robust data pipelines and ETL processes.
• Work with Snowflake for data warehousing including modeling, schema design, and optimization.
• Implement ETL using Matillion to ingest data into Snowflake.
• Write and optimize complex SQL queries for data retrieval and reporting.
• Ensure data quality and integrity through validation and cleansing procedures.
• Collaborate with data engineers, analysts, and business teams to meet data needs.
• Troubleshoot data issues and performance bottlenecks; document data processes and architecture.

Connaissances

SQL

Analytical thinking

Strong communication

Formation

Bachelor's degree in CS/Engineering/IS or technical field

Outils

Snowflake

Matillion

Alteryx

Tableau

Description du poste

VERY IMPORTANT: Must possess EXCELLENT English communication skills and be able to communicate clearly, concisely, and professionally with diverse audiences
Must be a U.S Citizen
Typically requires a degree in Technology, Engineering or Data Science unless prohibited by local laws/regulations and minimum 2 years of prior relevant experience or an Advanced Degree in a related field or in absence of a degree, 6 years of relevant experience.

Role Summary:

We are seeking a skilled and highly motivated Data Engineer to join our Data & Analytics team in Collins Aerospace. In this role, you will be responsible for designing, developing, and maintaining robust data pipelines and infrastructure using latest technologies. You will work closely with cross-functional teams to support and contribute to the evolution of our data platform and capabilities.

Responsibilities:

• Data Engineering: Design, develop, and maintain data pipelines and ETL processes to support data analytics and reporting needs.
• Snowflake: Utilize Snowflake to manage data warehousing, including data modeling, schema design, and optimization.
• Matillion: Implement ETL processes using Matillion to integrate, transform, and load data from various sources into Snowflake.
• SQL: Write complex SQL queries for data retrieval, analysis, and reporting. Optimize queries for performance and efficiency.
• Data Quality: Ensure data quality and integrity by developing and implementing data validation and cleansing procedures.
• Collaboration: Work closely with data engineers, analysts, and business teams to understand data requirements and deliver solutions.
• Troubleshooting and Debugging: Investigate and resolve data issues, performance bottlenecks, and other technical challenges.
• Documentation: Create and maintain documentation for data processes, workflows, and architecture.

Experience / Qualifications:

• Must be a U.S Citizen
• Bachelor's degree in computer science, computer engineering, information systems, or technical field with 5 years of relevant experience.
• About 10+ years of experience in Data Engineering role, with proficiency in designing, implementing, and optimizing data pipelines and ETL processes.
• Proven experience as a Data Engineer with a background in Snowflake, Matillion, Alteryx, and Tableau or relevant ETL and RDBMS technologies.
• Strong SQL skills, including experience with complex queries, joins, and aggregations.
• Experience developing dashboards and visualizations using Tableau.
• Strong understanding of ETL processes and best practices, with hands-on experience using Matillion or relevant tools.
• Strong analytical and problem-solving skills, with the ability to troubleshoot and resolve data-related issues.
• Excellent written and verbal communication skills, with the ability to work effectively with cross-functional teams.
• Strong organizational and time-management skills, with the ability to prioritize tasks and meet deadlines.
• Comfortable working in a fast-paced, dynamic environment with changing priorities.

Nice to haves:

• Knowledge of SAP S4 and SAP Business Data Cloud