Data Reporting and Analytics Consultant IV, Programming

Document Management Shared Service (DMSS) is responsible for the composition, fulfilment, archival, and online presentment of over 200 million documents a year. Our Technical Consulting team is responsible for analyzing and developing business requirements solutions for strategic initiatives working across functional areas of the organization to enable a consistent document touch point experience across a variety of distribution channels. This Consultant IV position will be responsible for assessing the business needs, play a key lead role in solidifying business requirements, executing, and implementing letter development solutions. You will work closely with KP-IT and other key stakeholders to ensure the business and system requirements are captured accurately and loaded in the KP requirements tracking tool such as Jira.  Additionally, this role will function as the Subject Matter Expert/Business Liaison for providing clarifications on business needs to develop, test, and deploy solutions. 

In addition to the responsibilities listed below, this position is also responsible for overseeing all phases of letter deliverables; lead role in solutions, development, unit testing, peer reviews, analyzing, data integration, and quality control needs on multi-programmer projects; and troubleshooting complicated software processes, products, and business requirements.
This position is also responsible for designing complicated automated batch and ad-hoc letter development and data loading solutions; testing data integration and data integrity from a wide variety of sources across platforms; developing complicated macros for various applications, research, and reporting purposes; designing comprehensive quality checking and validation process; and developing and evaluate complicated data linkage process. This position may supervise or lead the work of lower level team members serving on the same project.

Essential Responsibilities:

• Practices self-development and promotes learning in others by proactively providing information, resources, advice, and expertise with coworkers and customers; building relationships with cross-functional stakeholders; influencing others through technical explanations and examples; adapting to competing demands and new responsibilities; listening and responding to, seeking, and addressing performance feedback; providing feedback to others; creating and executing plans to capitalize on strengths and develop weaknesses; supporting team collaboration; and adapting to and learning from change, difficulties, and feedback.


• Completes work assignments and supports business-specific projects by applying expertise in subject area; supporting the development of work plans to meet business priorities and deadlines; ensuring team follows all procedures and policies; coordinating resources to accomplish priorities and deadlines; collaborating cross-functionally to make effective business decisions; solving complex problems; escalating high priority issues or risks as appropriate; and recognizing and capitalizing on improvement opportunities.


• Executes creative data analytic approaches leading to actionable outcomes by defining and calculating metrics to be analyzed; defining, calculating, and validating algorithms; and conducting analyses, including descriptive, correlational, inferential, and/or predictive statistics.


• Interprets data analyses by applying findings to contextual settings; and developing insights, reports, and presentations telling a compelling story to stakeholders to enable and influence decision making; and providing context related to data interpretations and/or limitations as appropriate.


• Drives strategic data-informed decisions by consulting with clients to identify and clarify key business needs; developing outcomes and process measures; translating business requirements; determining data/information needs and data collection methods; developing analysis plans; measuring the impact of business decisions on clients, customers, and/or members; working with clients and staff to identify opportunities and methods to improve efficiencies with analysis; supporting and training end-users; and documenting processes and deliverables.


• Gathers data and information on targeted variables in an established systematic fashion by validating data sources; querying, merging, and extracting data across sources; completing routine data refresh and update; developing and/or delivering tools for electronic data collection; and providing user training, support, and documentation.


• Develops analytical and/or statistical models enabling informed business decisions by determining data and analytical requirements; creating models leading to actionable insights; and testing, refining, and validating models.


• Prepares data for analytic efforts by integrating and consolidating data; ensuring data quality and accuracy; profiling data inaccuracies and recommending process improvements or system changes to enhance overall quality of the data; and cleaning and creating final data set(s) for analysis.