Data Reporting and Analytics Consultant V, Programming - Oracle SQL development

In addition to the responsibilities listed below, this position is also responsible for working collaboratively with statisticians and researchers to provide programming in analytical programming languages (may include SAS, SQL, SPSS, R, Python, etc.), data management, and quality control support for a wide variety of projects; maintaining a high level of programming proficiency; providing innovative developments and/or programs; and providing expert guidance on analytical programming issues.

This position is also responsible for overseeing all phases of data management, quality control and reporting for multiple research projects; troubleshooting complicated software processes and products; designing and evaluating complex macros for various research and reporting purposes; and providing strategies on various complicated data linkage solutions.

• Practices self-leadership and promotes learning in others by building relationships with cross-functional stakeholders; communicating information and providing advice to drive projects forward; influencing team members within assigned unit; listening and responding to, seeking, and addressing performance feedback; adapting to competing demands and new responsibilities; providing feedback to others, including upward feedback to leadership and mentoring junior team members; creating and executing plans to capitalize on strengths and develop weaknesses; and adapting to and learning from change, difficulties, and feedback.


• Conducts or oversees business-specific projects by applying deep expertise in subject area; promoting adherence to all procedures and policies; developing work plans to meet business priorities and deadlines; determining and carrying out processes and methodologies; coordinating and delegating resources to accomplish organizational goals; partnering internally and externally to make effective business decisions; solving complex problems; escalating issues or risks as appropriate; monitoring progress and results; recognizing and capitalizing on improvement opportunities; and evaluating recommendations made by others.


• Interprets complex 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; participating in peer reviews; and providing context related to data interpretations and/or limitations as appropriate.
  


• Leads the development of advanced analytical and/or statistical models enabling informed business decisions by determining data and analytical requirements; translating models and gaining stakeholder buy-in for implementation; creating complex models leading to actionable insights; and testing, refining, and validating models.


• Designs, implements, and automates business and reporting solutions by partnering with stakeholders to advise in their design, planning, and implementation while ensuring consistency and coherency; evaluating and summarizing data and results; creating summary statistics; designing data reports, visualizations, and/or interactive Business Intelligence (BI) reports; reporting to stakeholders on key findings; identifying needs for the development and implementation of additional reporting solutions; and preparing documentation as appropriate.


• Drives the execution of creative data analytic approaches leading to actionable outcomes across functional areas, business and/or clinical lines by defining and calculating complex metrics to be analyzed; defining, calculating, and validating algorithms; and conducting complex analyses, including descriptive, correlational, inferential, and/or predictive statistics.


• 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; collaborating with stakeholders and source system owners to resolve data quality issues as appropriate; and cleaning and creating final data set(s) for analysis.
  
  
  


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


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

Qualifications:

• Minimum six (6) years experience programming with SAS, SQL, R or other similar analytical programming language.


• Minimum five (5) years data management experience with SAS, SQL, R or other similar analytical programming language.


• Minimum three (3) years experience in a leadership role with or without direct reports.


• Bachelors degree in Mathematics, Statistics, Engineering, Social/Physical/Life Science, Business, or related field and Minimum eight (8) years experience in data analytics or a directly related field. Additional equivalent work experience in a directly related field may be substituted for the degree requirement.

• Knowledge, Skills, and Abilities (KSAs): Data Integration; SAS Tools; SQL/SAS; Web Report Studio; Negotiation; Business Planning; Written Communication; Data Extraction; Data Mining; Data Visualization Tools; Statistical Programming Language; Relational Database Management; Vendor Management; Project Management