Sr Data Analyst

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

• Utilize analytical and technical skills for translating and analyzing business needs into requirements and lead the design and implementation of multiple 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 format 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.
• Design and support data models optimized to support analytical tools such as Microstrategy, Tableau, PowerBI and create BI reports.
• Support development of master data, data cataloging and data quality processes in data management tools.
• Gathers data from multiple sources and performs moderate to complex analysis, generating reports supportive of organizational metrics and client services.
• Support a variety of information management projects of a highly varied nature including data analysis, data mining and data optimization.
• Develop and follow standard operating procedures for regularly occurring processes.
• Mentor, Cross-train and provide back-up coverage to other team members when needed.
• Operating at the Sr Analyst level, duties/responsibilities should be carried out with autonomy and require minimal direct supervision of day-to-day tasks and only high-level direction from departmental leadership. Should have the ability to support and coach others while maintaining productivity on directly assigned work.

• Bachelors Degree or 6 years equivalent experience.
• 5 years of demonstrated data management/technical experience, including the ability to merge, clean and analyze large amounts of data.
• US Citizenship is required in order to obtain a security clearance.

• 3-5 years of technical experience utilizing database technologies and/or data process analysis experience within information architectures / digital ecosystems.
• Technical experience should include SQL, PL/SQL, T/SQL, NoSQL programming, and database objects such as stored procedures, materialized views, functions etc. or analytics tools (Microstrategy, Tableau, PowerBI).
• Data Process Analysis experience should include documentation and analysis techniques such as data flow diagrams (DFD) and analyzing system level information flow and decomposing data process dependencies within a digital ecosystem.
• 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.
• Experience implementing impactful Analytics.
• Proactive analytical and collaborative problem-solving skills with business acumen.
• Ability to communicate effectively with both senior managerial and technical teams.
• Ability to drive action, deliver results, with agile approach.

.

FMT2021