Data Analyst II

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

We create innovative solutions to complex national security challenges, and lead with accountability, collaboration and an unwavering dedication to our mission and core values.

Are you ready to do work that matters?

Summary

The Data Analyst II will provide support and analysis for KCNSC enterprise data projects, define processes, and adhere to them. The role is responsible for performing data analysis, data integration, data mapping, and data quality for Data Analytics and Data Governance activities as determined by KCNSC Data Office management.

Duties and 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 process
• 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.
• Gathers data from multiple sources and performs 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
• Working at the Analyst II level, duties/responsibilities should be carried out with a level of proficiency commensurate with the experience level required for the position and should require only general oversight from departmental leadership.

You Must Have

• 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)

We Value

• 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 year 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
• Ability to translate business requirements into effective process management solutions
• Strong MS Excel skills preferred
• Proactive analytical and collaborative problem-solving skills with business acumen
• Experience modelling processes and business rules utilizing BPM tools
• 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

This job description/job posting is not all inclusive and other duties may be assigned.

What We Offer

We are focused on attracting, hiring and retaining talented people who power our mission. Our robust total rewards package recognizes performance, fuels development and supports flexibility. Key features include:

• Medical, dental and vision insurance
• Health Savings Account (HSA)
• Industry leading 401(k) match
• Generous paid time off
• Flexible work schedule
• Tuition Reimbursement
• Professional Certification & License Programs
• Mission driven culture

Click

Additional Information

Connect with us on social media:

• Job ID: 5023
• Category: Information Technology
• Posting Location: KCNSC West 6700 W 115th St Overland Park, KS, 66221
• Remote Eligibility: On-Site
• Travel Required: 0-10%
• Approved Work States: KS; MO
• Hourly/Salary: Salary
• Division: W00
• Department: W2A