Lead Data Architect
Summary
Rocketdyne seeks a Lead Data Architect/Engineer to build and maintain data warehouses, pipelines, models, and Power BI dashboards using Snowflake, SQL, and Python. The role leads analytics projects, establishes data quality and governance, mentors team members, and presents insights to executives; requires eligibility for a U.S. security clearance.
Job Description
Rocketdyne is seeking a Lead Data Architect and Engineer to develop data solutions that support business operations and leadership decision-making. This role combines data architecture, engineering, analytics, and project leadership.
The selected candidate will build and maintain data warehouses, pipelines, models, and dashboards using Snowflake, Power BI, SQL, and Python. They will work with business and technical teams to turn requirements into reliable solutions while ensuring data quality, security, and governance.
Essential Functions
- Design and maintain data warehouses, pipelines, and data models.
- Develop Power BI dashboards, reports, and performance metrics.
- Extract, transform, validate, and analyze data to deliver actionable insights.
- Establish data quality, security, access control, and governance practices.
- Lead analytics projects and coordinate with business, IT, and data engineering teams.
- Identify opportunities to improve business processes and reporting.
- Support self-service analytics and maintain technical and user documentation.
- Mentor team members and communicate findings to executives and stakeholders.
Required Qualifications
- Bachelor’s degree with 9 years of relevant experience; graduate degree with 7 years; or 13 years of relevant experience in lieu of a degree.
- Ability to obtain a U.S. security clearance.
- At least 3 years of experience with relational databases or enterprise systems such as Oracle or Deltek Costpoint.
- At least 3 years of experience with Power BI, Qlik, or similar visualization tools.
- At least 2 years of experience with ETL/ELT, data storage, and data modeling using enterprise integration tools and/or Python.
- Strong SQL skills and experience supporting enterprise data warehouses.
- Knowledge of data security, role-based access control, and data governance.
- Strong problem-solving, communication, and collaboration skills.
Preferred Skills
- Experience with Snowflake, cloud platforms, and data warehousing best practices.
- Experience with semantic models, data ontologies, and self-service analytics.
- Familiarity with Python and version-controlled code repositories.
- Experience leading projects and presenting insights to executives.
- Experience in Aerospace & Defense, Manufacturing, or Supply Chain industries