remote
Principal Specialist, Analytics & Ignition Developer - Collins Aerospace
Software Engineer
Lead advanced analytics and ignition development, designing data pipelines, modeling, and visualizations using SQL, Python, Power BI, and AWS services to drive business insights and operational excellence.
About the role
Key Responsibilities
- Architect and develop scalable data pipelines and ETL processes to ingest, transform, and load large datasets from diverse sources.
- Design and implement robust data models and schemas that support advanced analytics and reporting requirements.
- Build interactive dashboards and reports in Power BI, ensuring data accuracy, performance, and user-friendly design.
- Collaborate with cross‑functional teams to translate business needs into technical solutions and deliver actionable insights.
- Maintain and optimize data infrastructure on AWS, leveraging services such as S3, Redshift, and Glue for cost‑effective, high‑performance analytics.
- Document data flows, architecture decisions, and best practices to support knowledge sharing and future scalability.
Requirements
- Extensive experience with SQL, Python, and data modeling techniques.
- Proven track record in building ETL pipelines and data warehouses.
- Strong proficiency in Power BI for creating dynamic, enterprise‑grade dashboards.
- Hands‑on experience with AWS data services (S3, Redshift, Glue, Athena).
- Excellent problem‑solving skills, attention to detail, and ability to communicate complex concepts to non‑technical stakeholders.
Skills
sqlpythonpower biaws