Data Reporting Analyst III

Job Summary

This individual contributor is primarily responsible for supporting data-informed decisions, gathering data and information on targeted variables in an established systematic fashion, and preparing data for analytic efforts. This position develops, implements, and automates business and reporting solutions and supports data analysis interpretation.

Essential/Key Responsibilities

• Pursues self-development and effective relationships with others by proactively providing resources, information, advice, and expertise with coworkers and customers; influencing others through technical explanations and examples; providing occasional mentoring to team members; listening and responding to, seeking, and addressing performance feedback; creating plans to capitalize on strengths and develop weaknesses; anticipating and responding to the needs of others; and adapting to and learning from change, difficulties, and feedback.
• Completes work assignments by applying up-to-date expertise in subject area to generate creative solutions; ensuring all procedures and policies are followed; leveraging an understanding of data, and resources to support projects or initiatives; collaborating cross-functionally to solve business problems; identifying and monitoring priorities, deadlines, and expectations; communicating progress and information; identifying, recommending, and implementing ways to address improvement opportunities; and escalating issues or risks as appropriate.
• 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.
• Prepares data for analytic efforts by consolidating data; reviewing data for quality and accuracy; profiling data inaccuracies; and cleaning and creating final data set(s) for analysis.
• Develops, implements, and automates business and reporting solutions by working with stakeholders in their design, planning, and implementation while ensuring consistency and coherency; summarizing data and results; creating summary statistics; organizing data reports, visualizations, and/or interactive Business Intelligence (BI) reports; identifying needs for the development and implementation of additional reporting solutions; and preparing documentation as appropriate.
• Supports data analysis interpretation by applying findings to contextual settings under the guidance of more senior employees; and developing reports and presentations telling a compelling story to stakeholders to enable and influence decision making.
• Supports 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.

Job Qualifications

Minimum Qualifications

• Bachelor’s degree in mathematics, Statistics, Computer Science, Engineering, Social/Physical/Life Science, Business, or related field and Minimum three (3) 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.

Technical Skills:

• ETL Tools: Experience in SAS programming and interaction with, ETL processes for data extraction, transformation, and loading.
• Data Modeling: Familiarity in writing formulas and understanding data modeling techniques
• SQL: Strong command of SQL for querying and data manipulation.
• Software (BI) Developer Mine and analyze data from company databases to drive optimization and improvement of product development, marketing techniques and business strategies.
• Experience querying databases and using statistical computer languages (SQL, DAX, R etc.) to manipulate data and draw insights from large data sets.
• Experience working with and creating data architectures (Power BI Data Models).
• Foundational knowledge of statistical techniques and concepts (regression, properties of distributions, statistical tests and proper usage, etc.) and experience with applications.

Analytical & Problem-Solving Skills:

• Experienced in analytical thinking to derive actionable insights from data and effective problem-solving skills for troubleshooting.

Communication & Collaboration:

• Strong communication skills to work effectively with technical teams and non-technical stakeholders.

Data Understanding:

• Solid understanding of database foundations, including relational and multidimensional design.

Preferred Qualifications

• DAX & Data Modeling: Familiarity in writing DAX formulas and understanding data modeling techniques
• Informatica PowerCenter/IICS
• Informatica Intelligent Cloud Services
• Linux, Python, Shell Scripts
• Jira and Agile methodologies
• Pharmacy Domin Knowledge
• Oracle PL/SQL
• Databricks
• Epic Clarity Database Understanding