SGS-Data Analyst IILocation: Bethesda, MD/HybridDuration: Fulltime

Description:The Data Analyst II enhances value to customers by leveraging advanced analytics (descriptive, diagnostic, predictive and prescriptive) and strong presentation skills to communicate program value and actionable insights.The Data Analyst II supports internal and external customers by utilizing both in-house and third-party data sources, as well as optimizing reporting processes and communication between the various stakeholders.Additionally, the Data Analyst II supports high-profile projects in order to develop and implement new analytical tools or methodologies. Through successful execution of duties and responsibilities, as supported by knowledge and skills, the Data Analyst II acts as a subject matter expert (SME) on data, trends, and outcomes associated with healthcare and MCA programs and clients for both internal and external customers.

Duties and Responsibilities:Analyze, document and present trends in customer program performance, internal operational and/or financial performance:Work collaboratively with internal account teams to demonstrate program outcomes and develop and articulate strategic recommendations to address client challenges.Supports internal and external customers by synthesizing both in-house and third-party data sources, as well as industry benchmarks and best practices, into actionable information that leads to insights and impactful changes;Work under consultative or self-initiated direction (i.e. undirected analysis) to assess and produce standard or custom information (reports, charts, graphs, and tables) from structured data sources by querying data repositories and generating the associated information;Present standard and ad hoc reports including trends and analyses to internal and external customers, with a specific focus on being able to use Client terminology to communicate actionable insights and results to a broad audience;Take the lead on ad hoc analytics deep dives in order to identify and communicate additional insights and trends to both internal and external customers;Produce, distribute and disseminate recurring and ad hoc reports and analyses through proper review and distribution channels according to department and company policies and procedures;Leverage analytical software, database reporting software, database user interface, query software, and data mining software, in support of both report production/development and data validation;Leverage industry-standard data visualization tools and/or BI tools to develop and improve dashboards incorporating both statistics and visualizations;

Supports data integrity, ensures reporting accuracy, and enables the optimization of reporting processes:Production/development of reports measuring data accuracy;Supports report development with a goal to optimizing processes, limiting possible errors, and better identifying possible inaccuracies;Accountable for all work reviewed;Participates in and supports the organizations quality programs and the underlying tools/protocols that support it.Supports high-profile and cross-department analytics projects for internal stakeholders and MCA clients:Design, develop and collaborate on new analytical tools, templates, coding or methodologies, with an emphasis on optimizing performance, in response to needs/requests from stakeholders or self-identified needs;Work closely with clients, account/project managers, data analysts, and other MCA stakeholders to translate data into critical information and knowledge that enables decision-making;Test prototype software and participate in the approval and release process for new software;Collaborate with technical staff to standardize and mechanize routine reports, dashboards, and metrics;Work with key stakeholders to develop and maintain data standards and common data elements for data collection;

Supports the Analytics group:Supports the documentation of processes in the form of Work Instructions or SOPs;Answer technical and procedural questions for less experienced team members;Provide peer-review and quality reviews of analytic tools & reporting created or modified by other members of the Analytics group.Ability to work independently, multitask, and adjust prioritiesClear and conceptual thinking ability; excellent judgment, troubleshooting, problem-solving, analysis, and discretion; ability to handle work-related stress; ability to handle multiple priorities simultaneously; and ability to meet deadlinesProactively seeks opportunities to increase knowledge, skills and abilitiesExcellent written or communication skills to report findings and methodologies in a clear, structured mannerAssumes responsibility for related duties as required or assigned

EducationBA or BS degree required:Preferred: Bachelors of Science in Related Field (i.e. Statistics, Mathematics, Engineering, Computer Science, or similar).Preferred: Master's degree in a data or healthcare related field from an accredited college or university.

Experience:Minimum of 3 years of relevant analytics experienceMinimum of 3 years of healthcare management including but not limited to, Health Plans, Insurance Industry, Medical Case Management and Pharmacy Benefit Management (PBM)Preferred: Experience in Workers' CompensationMinimum of 1 year of experience in communicating, summarizing, and/or presenting complex analytics findings to stakeholders.In-depth knowledge and experience using and applying analytical software, database reporting software, database user interface, query software, and data mining software, in support of both report production/development and data validationExperience using industry-standard data visualization tools, BI tools, and dashboards incorporating both statistics and visualizationsExperience working with both in-house and third-party dataExperience working with project management and agile methodologiesExpertise using all MS Office Suite tools

Communication Skills:Excellent written and verbal communication skills. Strong organizational and analytical skills. Ability to provide efficient, timely, reliable, and courteous service to customers.Strong English language skills, including but not limited to Speaking, writing, spelling, and grammatical skills. Must write succinctly and clearly and explain complex situations in plain English to technical and non-technical audiences.Excellent ability to effectively present information. Especially facilitating discussion of analytical subjects between technical and non-technical team members.Analytical AbilityAbility to apply logical or scientific thinking to a wide range of intellectual and practical problems.Able to deal with very difficult concepts and complex variables. Ability to comprehend, analyze, and interpret documents.Ability to solve problems involving several options in situations.Requires intermediate analytical and quantitative skills. Able to perform basic statistical calculations including frequency distributions, reliability, and validity of tests, normal curve, analysis of variance, correlation techniques.Scope of ResponsibilityDecisions are made with an understanding of procedures and company policies to achieve set results and deadlines.Responsible for setting own project deadlines. Errors in judgment may cause an impact on coworkers and supervisors and the company.

Other Skills and Abilities, Qualifications:Required Software Expertise:Advanced: MS ExcelIntermediate: MS Access, MS PowerPoint, MS WordIntermediate: SQLAdvanced Beginner: Micro Strategy, Tableau, Power BI nice to have SAS, or RPreferred Software Expertise:Extra: MS VBA, IBM SPSS

Conditions of Employment:Work EnvironmentThe work environment characteristics are representative of those an employee encounters while performing the essential functions of this job.Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.Persons holding office positions are generally subject to inside environmental conditions having the lighting, temperature, and noise of an open-floor-plan office environment.#J-18808-Ljbffr