Data Analyst - SQL, Excel, Tableau/Power BI, with Salesforce

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 customer on data needs and key deadlines
• Researches and identifies 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

• 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 data; Uses intuition and experience to complement data; 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
• Initiative - Volunteers readily; Undertakes self-development activities; Seeks increased responsibilities; Takes independent actions and calculated risks; Looks for and takes opportunities; Asks for and offers help when needed
• 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
• 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 environment. The work is performed in a traditional commercial office setting with standard office lighting and white noise.