Lead Software Engineer-Data Architect

About the position

The Lead Software Engineer-Data Architect at L3Harris is responsible for designing and implementing data architecture, including data models, databases, data warehouses, and data lakes. This role involves orchestrating data ETL/ELT pipelines, ensuring data quality and compliance, and collaborating with various stakeholders to provide actionable insights through data solutions. The position supports the segment's modern data platform and requires a strong focus on data governance and optimization.

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 Graduate Degree and a minimum of 7 years of prior related experience, or in lieu of a degree, minimum of 13 years of prior related experience.
• 3 years of experience with cloud-based data warehousing platform 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

• Medical with a High Deductible and traditional PPO plan options, as well as vision and a full array of supplemental health benefits.
• 4 weeks of paid parental leave for moms and dads.
• Fertility treatment support.
• Subsidized backup childcare and eldercare.
• Adoption assistance - $5,000 per adoption/$15,000 per employee.
• Pet insurance.
• No cap to your PTO time (for exempt employees).
• Legal plan for you, your family, and parents.
• Discount platform.