Data Architect / Data Engineer

L3Harris is dedicated to recruiting and developing high-performing talent who are passionate about what they do. Our employees are unified in a shared dedication to our customers' mission and quest for professional growth. L3Harris provides an inclusive, engaging environment designed to empower employees and promote work-life success. Fundamental to our culture is an unwavering focus on values, dedication to our communities, and commitment to excellence in everything we do.

L3Harris Technologies is the Trusted Disruptor in the defense industry. With customers' mission-critical needs always in mind, our employees deliver end-to-end technology solutions connecting the space, air, land, sea and cyber domains in the interest of national security.

Job Title: Data Architect / Data Engineer

Job Code: 23631

Job Location: Can be located in - Fort Wayne, IN OR Melbourne, FL OR Fort Worth, TX OR Alpharetta, GA OR Bristol, PA OR Clifton, NJ OR Rochester, NY OR San Diego, CA OR Chantilly, VA OR Van Nuys, CA OR Herndon, VA OR Colorado Springs, CO

Job Description:

The Space and Airborne Systems (SAS) Business Intelligence team is seeking a data architect and engineer who will be responsible for supporting the design and structure of our Segment's primary data warehouse. This role will require evaluating two legacy warehouses, supporting the development of the migration plan and data models, and creating ETL packages to move data into a consolidated data warehouse. This individual will identify our internal and external data sources, collaborate with internal teams to determine data storage needs, and use this information to create and maintain data architecture ongoing. This role will also be responsible for data warehouse governance practices, including data management, data quality, data security, and provisioning access.

Essential Functions:

Evaluate current database architecture and determine requirements for the new database
Develop and present database design reports to gain confluence from database admins
Integrate technical functionality, ensuring data accessibility, accuracy, and security
Audit databases regularly to maintain performance and quality
Document data models (Conceptual, Logical, and Physical) to facilitate efficient and effective use of data
Maintain solutions for data modeling and metadata management
Design, build, and manage data pipelines for data structures encompassing data transformation mapping, data flow diagrams, logical and physical data models, and metadata collection
Work with both IT and business in developing, managing, and integrating business intelligence reporting, analytics, and data science output into business processes and workflows
Translate data strategies into data integration frameworks and reporting to enable business analytics
Utilize a standard common business vocabulary, outline high-level integrated designs to meet requirements, and align with enterprise strategy and related business architectures
Lead planning sessions with customers to improve business processes and prioritize investments in data and infrastructure
Proactively analyze existing data structures and reporting to identify weaknesses and develop opportunities for improvements
Utilize best practices for naming, governing, managing, modeling, cleansing, transforming, moving, storing, and searching all data
Ensure changes to the data environment are compliant with architectural standards
Lead design and data model reviews, providing constructive feedback to Application Developers
Collaborate with IT and other data providers as required to design/develop ETL packages to extract data from a variety of data sources, including databases, Excel files, and SharePoint sites, and troubleshoot and resolve ETL issues
Coordinate cross-functionally with IT and Data Analytics teams to ensure resource optimization, synchronization of initiatives, and to prevent duplication of work across the enterprise
Maintain database documentation, including data standards, procedures, and definitions for the data dictionary

Qualifications:

Bachelor's Degree and a minimum of 6 years of prior relevant experience; Or, Graduate Degree and a minimum of 4 years of prior related experience; Or, in lieu of a degree, a minimum of 10 years of prior related experience

Preferred Additional Skills:

4+ years of experience developing data solutions for business users, including all aspects of the data lifecycle
4+ years of experience working with relational databases (Microsoft SQL Server, Oracle, Snowflake) and developing SQL queries on large data sets
3+ years of experience with data extract, transform, and load (ETL & ELT patterns), data storage, data models, etc., using Azure Data Factory, SQL, DAX, and Python
2+ years of experience with Power BI data visualization software
Strong attention to detail and a high degree of accuracy with minimal oversight
Successful history of manipulating, processing, and extracting value from large, disconnected datasets
Ability to handle complex problems and take initiative to research issues, engage in self-learning, problem-solve, and implement solutions
Ability to translate data-related requirements into innovative user solutions, drawing on prior education and experience, standard procedures, and basic analysis
Experience completing assignments with minimal supervision and setting objectives to meet the goals of assignments
Ability to establish rapport, communicate effectively, and collaborate with users, data providers, and management at all levels within an organization
Advanced organizational skills with the ability to work on multiple projects simultaneously and to comfortably adjust as priorities change
Able to operate in a fast-paced environment yet remain focused on long-term organizational goals
Excellent communication skills, commitment to quality, customer focus, adaptability, and interpersonal skills

In compliance with pay transparency requirements, the salary range for this role in Colorado State, Hawaii, Illinois, Maryland, Minnesota, Vermont and New York State is $93,500-$173,500. For California, Seattle, Washington D.C., Maryland Greater Washington D.C. area, the city of Denver, Washington State and New York City, the salary range for this role is $107,500-$199,500. This is not a guarantee of compensation or salary, as final offer amount may vary based on factors including but not limited to experience and geographic location. L3Harris also offers a variety of benefits, including health and disability insurance, 401(k) match, flexible spending accounts, EAP, education assistance, parental leave, paid time off, and company-paid holidays. The specific programs and options available to an employee may vary depending on date of hire, schedule type, and the applicability of collective bargaining agreements.

#LI-CG1

L3Harris Technologies is proud to be an Equal Opportunity Employer. L3Harris is committed to treating all employees and applicants for employment with respect and dignity and maintaining a workplace that is free from unlawful discrimination. All applicants will be considered for employment without regard to race, color, religion, age, national origin, ancestry, ethnicity, gender (including pregnancy, childbirth, breastfeeding or other related medical conditions), gender identity, gender expression, sexual orientation, marital status, veteran status, disability, genetic information, citizenship status, characteristic or membership in any other group protected by federal, state or local laws. L3Harris maintains a drug-free workplace and performs pre-employment substance abuse testing and background checks, where permitted by law.

Please be aware many of our positions require the ability to obtain a security clearance. In addition, applicants who accept a conditional offer of employment may be subject to government security investigation(s) and must meet eligibility requirements for access to classified information.

By submitting your resume for this position, you understand and agree that L3Harris Technologies may share your resume, as well as any other related personal information or documentation you provide, with its subsidiaries and affiliated companies for the purpose of considering you for other available positions.

L3Harris Technologies is an E-Verify Employer. Please click here for the E-Verify Poster in English or Spanish . For information regarding your Right To Work, please click here for English or Spanish .