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

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

DUTIES AND 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
• Applying 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).
• Communicates 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.
• Configures 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.

Requirements

• SUPERVISORY RESPONSIBILITIES:
• This job has no supervisory responsibilities.
• 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 researches 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 advantage of 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.
• 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...