Data Analyst II

About the role

The Kansas City National Security Campus (KCNSC), managed and operated by Honeywell Federal Manufacturing & Technologies, is a premier advanced manufacturing facility supporting the safety, security, reliability, and effectiveness of the U.S. nuclear deterrent. Located in Kansas City, Missouri, and Albuquerque, New Mexico, KCNSC employs nearly 7,000 employees and is dedicated to producing trusted national security products and services for the U.S. Department of Energy's National Nuclear Security Administration.

Responsibilities

• Utilize analytical and technical skills for translating and analyzing business needs into requirements and support the design and implementation of one or more complex analytics solutions (reports, dashboards, data mining) and/or governance solutions (cataloging, data quality, access management).
• Work with project work streams, business stakeholders to design, implement and maintain best practice analytics and data governance information products and processes to support the business.
• Perform data analysis by querying data sets in databases, spreadsheets, semi-structured data, and flat file formats to identify and document master data, reference data, transaction data, business rules, data integration rules, data mapping and transformations.
• Document internal processes and audit procedures to ensure data integrity of solutions.
• Research and resolve unexpected results or internal process flaws.
• Effectively prioritize and deploy solutions that can replace manual processes.
• Support and prototype solutions in analytical tools such as Microstrategy, Tableau, PowerBI.
• Support development of master data, data cataloging and data quality processes in data management tools.
• Gather data from multiple sources and perform moderate level analysis, generating reports supportive of organizational metrics and client services.
• Support information management projects utilizing data analysis, data mining and data optimization techniques.
• Develop and follow standard operating procedures for regularly occurring processes.
• Cross train and provide back-up coverage to other team members when needed.

Requirements

• 2 years of experience required.
• Must have a Bachelor's degree or Certification or 2 additional years of experience.
• Ability to travel up to 10% of the time.
• Ability to work remote, hybrid, or on-site as directed by management and is determined by the needs of the business.
• Regular and reliable attendance is an essential function of this job.
• United States Citizenship.
• Ability to obtain and maintain, a U.S. Department of Energy (DOE) security clearance (some positions require additional DOE designations).

Qualifications

• 1-2 years of proficiency in SQL, PL/SQL, T/SQL programming, and database objects such as stored procedures, materialized views, functions etc.
• 1-2 years of experience on analytics tools (Microstrategy, Tableau, PowerBI, Spotfire), PeopleSoft or data management tools (cataloging, data quality, master data management).
• Knowledge of MS Excel.
• Experience with additional database and analytics programming languages is a plus (NoSQL, R, Python, Java, Scala).
• Strong data analysis skills, experience in source data analysis to identify and document master data, reference data, transaction data, business rules, data integration rules, data mapping and transformations.
• Good understanding of data virtualization concepts and experience developing unified sematic model.
• Experience working with Data management platforms.
• Experience working with data models, data warehouse, data management and data movement.
• Demonstrated ability to manage through ambiguity and competing priorities.
• Excellent oral and written communication and analytical skills.
• Strong interpersonal and collaborative work style.
• Ability to work with and manage confidential information in a professional manner.
• Strong organizational and time management skills.
• Ability to lead/drive priorities.
• Experience implementing impactful Analytics.
• Experience working on large scale business process improvement with results.
• Strong MS Excel skills preferred.
• Proactive analytical and collaborative problem-solving skills with business acumen.
• Ability to clearly document business process & system requirements.
• Ability to communicate effectively with both senior managerial and technical teams.
• Ability to drive action, deliver results, with agile approach.
• Convey information with clarity and directness, ensuring the message is understood across diverse, global teams.

Skills

• SQL, PL/SQL, T/SQL programming.
• Data analysis and data mining tools (Microstrategy, Tableau, PowerBI).
• Data management tools (cataloging, data quality, master data management).
• MS Excel.
• NoSQL, R, Python, Java, Scala.
• Data virtualization concepts.
• Data modeling and data warehouse.
• Business process improvement.
• Business process modeling tools.
• Business process documentation.

Benefits

We offer a comprehensive benefits package including medical, dental and vision insurance, a Health Savings Account (HSA), industry-leading 401(k) matching, generous paid time off, flexible work schedules, tuition reimbursement, professional certification and license programs, a mission-driven culture, and opportunities for professional growth and development.

Pay

This position offers a competitive salary based on experience and qualifications.

Schedule

The role is available on-site, with the option for remote or hybrid work arrangements as directed by management and determined by the needs of the business.