Date Posted: 2024-02-08 Country: United States of America Location: UTCT1: Corp – CT – Remote Remote Location, Remote City, CT, 06101 USA Position Role Type: Remote RTX Corporation is an Aerospace and Defense company that provides advanced systems and services for commercial, military and government customers worldwide. It comprises three industry-leading businesses – Collins Aerospace Systems, Pratt & Whitney, and Raytheon. Its 185,000 employees enable the company to operate at the edge of known science as they imagine and deliver solutions that push the boundaries in quantum physics, electric propulsion, directed energy, hypersonics , avionics and cybersecurity. The company, formed in 2020 through the combination of Raytheon Company and the United Technologies Corporation aerospace businesses, is headquartered in Arlington, VA. To realize our full potential, RTX is committed to creating a company where all employees are respected, valued and supported in the pursuit of their goals. We know companies that embrace diversity in all its forms not only deliver stronger business results, but also become a force for good, fueling stronger business performance and greater opportunity for employees, partners, investors and communities to succeed. The following position is to join our RTX Corporate, Enterprise Services, Research Center or BBN team: Role Summary: In this role you will develop and deliver a comprehensive IAM data, analytics, metrics, and reporting strategy. You will implement long-term and short-term strategies for data aggregation and reporting solutions. You will utilize governance to drive IAM analytical deliverables – ideation, data mining and complex data analysis, and present a business story with your recommended actions to key stakeholders including IAM management and Compliance teams. You will also proactively build relationships and interact with peers and leaders to ensure business needs are heard and understood. Individual will need to familiarize themselves with Information Security Policies, Standards, and Controls and offer guidance as needed to ensure personnel are complying. They will be required to identify risks and strategize possible solutions with the customer, inform management as necessary, while handling tasks assigned to them with little or no supervision. They are expected to identify task inefficiencies and provide ideas for solutions, including the ability to assist with the automation of manual and semi-manual processes. Responsibilities:
- Streamline and automate processes to ensure data lineage, consistency, integrity, and transparency
- Lead all aspects of requirements analysis, traceability, and testing for enhancements and projects that are small, medium, or large in size and/or complexity, while supporting those functions for large cross-functional or enterprise-wide initiatives
- Perform day-to-day operational support; may mentor other analysts
- Participate in the design and delivery of solutions that support the fundamental data and governance process
- Handle multiple simultaneous data and reporting projects
- Understand and translate business needs into data models supporting long-term solutions
- Work with application developers to implement data strategies, build data flows, and develop conceptual data models
- Create logical and physical data models using best practices to ensure high data quality and reduced redundancy
- Optimize and update logical and physical data models to support new and existing projects
- Maintain conceptual, logical, and physical data models along with corresponding metadata
- Develop best practices for standard naming conventions and coding practices to ensure consistency of data models
- Recommend opportunities for reuse of data models in new environments
- Perform reverse engineering of physical data models from databases and SQL scripts
- Evaluate data models and physical databases for variances and discrepancies
- Validate business data objects for accuracy and completeness
- Analyze data-related system integration challenges and propose appropriate solutions
- Develop data models according to company standards
- Advise colleagues and stakeholders on project limitations and capabilities, performance requirements, and interfaces
- Review modifications to existing software to improve efficiency and performance
- Examine new application design and recommend corrections if required
Basic Qualifications:
- Good understanding of the Identity Access Management lifecycle and governance
- Undergraduate degree or equivalent experience
- 5-8 years’ work experience doing quantitative analysis
- 5-8 years’ experience in business intelligence, data modeling, data analytics or related discipline
Preferred Qualifications:
- Ability to champion process improvements
- Expert knowledge in all business processes across an entire line of business, as well expertise in other lines of business and technology disciplines
- Experience working with high-performing teams in complex program execution
- Strong project management experience within technology organization
- Hands on project and program management experience; track record of project go live implementations
- Extensive knowledge of data model theory, database design, structured query language (SQL), and related data warehousing practices
- Use of other data modeling tools will be considered with the core skill set: advanced SQL, Python (descriptive / predictive models), Qlikview and/or Tableau Viz
- Experience in Cyber Security analytics and with Identity & Access Management
Education: Typically requires a university degree or equivalent experience and minimum 8 years prior relevant experience or an advanced degree in a related field and minimum 5 years experience Location: REMOTE Required Immigration Status: US Citizen or US Person required. The salary range for this role is 96,000 USD – 200,000 USD. The salary range provided is a good faith estimate representative of all experience levels. RTX considers several factors when extending an offer, including but not limited to, the role, function and associated responsibilities, a candidate’s work experience, location, education/training, and key skills. Hired applicants may be eligible for benefits, including but not limited to, medical, dental, vision, life insurance, short-term disability, long-term disability, 401(k) match, flexible spending accounts, flexible work schedules, employee assistance program, Employee Scholar Program, parental leave, paid time off, and holidays. Specific benefits are dependent upon the specific business unit as well as whether or not the position is covered by a collective-bargaining agreement. Hired applicants may be eligible for annual short-term and/or long-term incentive compensation programs depending on the level of the position and whether or not it is covered by a collective-bargaining agreement. Payments under these annual programs are not guaranteed and are dependent upon a variety of factors including, but not limited to, individual performance, business unit performance, and/or the company’s performance. This role is a U.S.-based role. If the successful candidate resides in a U.S. territory, the appropriate pay structure and benefits will apply. RTX anticipates the application window closing approximately 40 days from the date the notice was posted. However, factors such as candidate flow and business necessity may require RTX to shorten or extend the application window. RTX is An Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or veteran status, age or any other federally protected class. Privacy Policy and Terms: Click on this link ( to read the Policy and Terms Raytheon Technologies is An Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or veteran status, age or any other federally protected class.
QlikView remote work data-modeling Tableau SQL metrics data-warehouse Python Analytics Cybersecurity Engineering amazon-iam