Lead Software Engineer-Data Architect

L3Harris Technologies - Rochester, NY

Full-time - Senior

Rochester, NY

Computer and Electronic Product Manufacturing

About the position

The Lead Software Engineer-Data Architect position is a critical role within the Business Intelligence and Data Management department of the IMS Segment. This position focuses on orchestrating data ETL/ELT pipelines, ensuring adherence to data standards, and maintaining data frameworks. The selected individual will be responsible for building scalable data solutions and developing dashboards to provide actionable insights for the enterprise, ultimately empowering decision-makers with clean, reliable data.

Responsibilities

• Lead the design and implementation of data architecture, including data models, databases, data warehouses, and data lakes.
• Develop and maintain robust ETL/ELT pipelines to integrate data from various sources into our centralized data ecosystem.
• Collaborate with business stakeholders, data scientists, and analysts to understand data requirements and translate them into technical specifications.
• Implement data governance policies and ensure data quality, security, and compliance across all data systems.
• Optimize data storage and retrieval processes for enhanced performance and cost-effectiveness.
• Lead and mentor a team of data engineers, fostering a culture of innovation and continuous improvement.
• Evaluate and implement new data technologies and tools to improve our data capabilities.
• Develop and maintain data catalogs and metadata management systems.
• Create and maintain documentation for data processes, architectures, and systems.
• Work closely with the BI team to ensure data is accessible and optimized for reporting and analytics.
• Participate in cross-functional projects to drive data-driven decision making across the organization.
• Stay current with industry trends and best practices in data engineering and management.

Requirements

• Must be a US Citizen.
• Bachelor's Degree and minimum 9 years of prior relevant experience, or a Graduate Degree with a minimum of 7 years of prior related experience, or in lieu of a degree, a minimum of 13 years of prior related experience.
• 3 years of experience with cloud-based data warehousing platforms such as Snowflake.
• 1 year experience with designing and developing data pipelines in PySpark, Spark SQL, or Code Build.
• 1 year experience with data visualization tools (e.g., Tableau, Power BI).
• Certifications in relevant technologies (e.g., Database Administrator (DBA), AWS Certified Data Analytics, Google Cloud Professional Data Engineer, Microsoft Certified Database Administrator (MCDBA)).

Nice-to-haves

• Active DoD security clearance.
• Strong understanding of Business Intelligence (BI) and Data Warehouse (DW) development methodologies.
• Experience with the Snowflake Cloud Data Platform, including data architecture, query optimization, and performance tuning.
• Proficiency in Python, Pandas, Databricks, JavaScript, or other scripting languages for data processing and automation.
• Experience with other ETL tools such as Azure Data Factory (ADF), SSIS, Informatica, or Talend is highly desirable.
• Familiarity with connecting and extracting data from various ERP applications, including Oracle EBS, SAP ECC/S4, Deltek Costpoint, and more.

Benefits

• Relocation assistance for those that qualify.