Data Insight Analyst SQL, Client Facing

About the role

The Data Insight Analyst is responsible for acquiring, managing, and analyzing data that will be presented to internal teams, clients, and partners.

Responsibilities

• Developing reports and analytics using data from data warehouse and Salesforce using Excel, SQL, Tableau, and other reporting/analytics tools
• Provide consultative insights:
  • Analyze data to identify patterns and trends over time
  • Compare data from different categories to identify relationships or correlations
  • Apply statistical analysis to identify patterns and relationships in the data
  • Provide context and explanations for the data by using visualizations and narrative descriptions
  • Identify outliers or anomalies in the data and investigate their causes
  • Review and QA data/report before it is provided to the client (internal/external)
  • Communicate directly with customers on data needs and key deadlines
  • Research and identify data quality issues
  • Manage ongoing, incoming partner requests and questions regarding data specifications
  • Configure mapping tools to support translation from source data to desired format. Includes testing of tool and providing clear documentation to internal resources and customer
  • Act as resident expert for data requirements/specifications internally and for the client as needed
  • Remain informed and up to speed with ongoing changes and evolution of assigned program data specs
  • Lead client/partner web-based trainings regarding data specifications and requirements
• Communicate with customers on data needs and key deadlines
• Research and identify data quality issues
• Manage ongoing, incoming partner requests and questions regarding data specifications
• Configure mapping tools to support translation from source data to desired format. Includes testing of tool and providing clear documentation to internal resources and customer
• Act as resident expert for data requirements/specifications internally and for the client as needed
• Remain informed and up to speed with ongoing changes and evolution of assigned program data specs
• Lead client/partner web-based trainings regarding data specifications and requirements

Qualifications

• This job has no supervisory responsibilities
• Self-starter, an individual who is not fully dependent on direction to fulfill the functions of the role
• Thrives in an entrepreneurial-like environment
• Experience with Tableau and Salesforce reporting preferred
• Experience with healthcare and/or pharmacy data preferred
• Experience with Microsoft Excel and SQL is a must
• Previous client-facing experience is a must
• Must be extremely responsive, able to work under pressure in crisis with a strong sense of urgency

Competencies

• Diversity - Demonstrates knowledge of EEO policy; Shows respect and sensitivity for cultural differences; Educates others on the value of diversity; Promotes a harassment-free environment; Builds a diverse workforce
• Ethics - Treats people with respect; Keeps commitments; Inspires the trust of others; Works with integrity and ethically; Upholds organizational values
• Adaptability - Adapts to changes in the work environment; Manages competing demands; Changes approach or method to best fit the situation; Able to deal with frequent change, delays, or unexpected events
• Analytical - Synthesizes complex or diverse information; Collects and analyzes information skillfully; Designs workflows and procedures
• Business Acumen - Understands business implications of decisions; Displays orientation to profitability; Demonstrates knowledge of market and competition; Aligns work with strategic goals
• Change Management - Develops workable implementation plans; Communicates changes effectively; Builds commitment and overcomes resistance; Prepares and supports those affected by change; Monitors transition and evaluates results
• Customer Service - Manages difficult or emotional customer situations; Responds promptly to customer needs; Solicits customer feedback to improve service; Responds to requests for service and assistance; Meets commitments
• Dependability - Follows instructions, responds to management direction; Takes responsibility for own actions; Keeps commitments; Commits to long hours of work when necessary to reach goals; Completes tasks on time or notifies appropriate person with an alternate plan
• Design - Generates creative solutions; Translates concepts and information into images; Uses feedback to modify designs; Applies design principles; Demonstrates attention to detail
• Innovation - Displays original thinking and creativity; Meets challenges with resourcefulness; Generates suggestions for improving work; Develops innovative approaches and ideas; Presents ideas and information in a manner that gets others' attention
• Interpersonal Skills - Focuses on solving conflict, not blaming; Maintains confidentiality; Listens to others without interrupting; Keeps emotions under control; Remains open to others' ideas and tries new things
• Oral Communication - Speaks clearly and persuasively in positive or negative situations; Listens and gets clarification; Responds well to questions; Demonstrates group presentation skills; Participates in meetings
• Planning/Organizing - Prioritizes and plans work activities; Uses time efficiently; Plans for additional resources; Sets goals and objectives; Organizes or schedules other people and their tasks; Develops realistic action plans
• Problem Solving - Identifies and resolves problems in a timely manner; Gathers and analyzes information skillfully; Develops alternative solutions; Works well in group problem solving situations; Uses reason even when dealing with emotional topics
• Professionalism - Approaches others in a tactful manner; Reacts well under pressure; Treats others with respect and consideration regardless of their status or position; Accepts responsibility for own actions; Follows through on commitments
• Quality - Demonstrates accuracy and thoroughness; Looks for ways to improve and promote quality; Applies feedback to improve performance; Monitors own work to ensure quality
• Teamwork - Balances team and individual responsibilities; Exhibits objectivity and openness to others' views; Gives and welcomes feedback; Contributes to building a positive team spirit; Puts success of team above own interests; Able to build morale and group commitments to goals and objectives; Supports everyone's efforts to succeed

Physical Demands and Work Environment

• Occasionally required to stand
• Occasionally required to walk
• Continually required to sit
• Continually required to utilize hand and finger dexterity
• Continually required to talk or hear
• While performing the duties of this job, the noise level in the work environment is usually moderate
• Additional remarks regarding work environment: This job operates in a professional office setting with standard office lighting and white noise