Data Analyst II (Hybrid - Aguadilla, PR)
About The Position
This position will sit at our Aguadilla, PR location. You must be residing in Puerto Rico at the time of starting employment. Relocation is not offered. This role is categorized as hybrid, with 3 days onsite and 2 days remote following the schedule assigned by the Manager. At RTX, the world largest aerospace and defense company, 185,000 great minds are united by purpose and inspired to make a difference solving the world’s most complex problems. With our three market leading businesses, world-class operations and investments in research and development, we offer capabilities and opportunity no one else can. Together, we push the boundaries of known science and find new ways to connect and protect our world. Collins Aerospace is a leader in technologically advanced, intelligent solutions that help redefine the aerospace and defense industry. With a comprehensive portfolio and deep technical expertise, we help customers meet the demands of the global market. Join us and help shape the future of aerospace and defense.
Requirements
- Typically requires a degree in Science, Technology, Engineering or Mathematics (STEM) and 2 years prior relevant experience or an Advanced Degree in a related field.
- Demonstrated professional experience communicating in English (verbal and written).
- U.S. citizenship is required, as only U.S. citizens are authorized to access information under this program/contract.
Nice To Haves
- Bachelor’s degree in Data Science, Computer Science, Mathematics, or a related field.
- Hands-on experience with Python for data analysis (e.g., NumPy, Pandas, PySpark).
- Proficiency in extracting, transforming, and loading (ETL) data from various sources.
- Intermediate experience with SQL and relational databases for querying and data manipulation.
- Experience in aerospace, defense, or related industry.
- Experience working in Agile teams and familiarity with Agile methodologies.
- Expertise in building data pipelines and automating analytics processes.
- Proficiency with data visualization tools such as Tableau or similar software.
- Familiarity with ontology-based modeling of business domains and enterprise data architecture.
- Knowledge of statistical methods and machine learning techniques.
Responsibilities
- Perform end-to-end data processes, including data collection, curation, analysis, and visualization.
- Develop, automate, and optimize data pipelines to transform raw data into actionable insights.
- Perform data quality checks to ensure accuracy and reliability of the data.
- Write and maintain scripts/macros in Python to support data analytics processes.
- Generate and execute database DDL (Data Definition Language) and DML (Data Manipulation Language) operations.
- Conduct statistical analyses to identify data patterns, outliers or inconsistencies across the data set.
- Collaborate with cross-functional teams to gather insights, refine requirements, and align product goals with team efforts.
- Participate in Agile sprints, owning user stories, backlog items, and deliverables.
- Support investigations and continuous improvement initiatives by leveraging digital thread and enterprise data resources.
- Prepare technical documentation, presentations, and reports to effectively communicate insights and recommendations to both technical and non-technical audiences.
- May require occasionally travel domestically and/or internationally to support project requirements.
- Perform other duties as required.
Benefits
- Medical, dental, and vision insurance
- Three weeks of vacation for newly hired employees
- Generous 401(k) plan that includes employer matching funds
- Participation in the Employee Scholar Program (ESP)
- Life insurance and disability coverage
- Employee Assistance Plan, including up to 8 free counseling sessions.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
