Overview - Data Analyst IIRemote Data Analyst IIOpen to Nationwide ApplicantsSalary Range: $70,000 - $85,000 depending on experience and qualifications.Are you ready to seize an opportunity to provide our high-profile customer dataand analytics to help guide important decisions? Are you a problem solver whoenjoys helping customers achieve their business goals? If so, this is aphenomenal opportunity for you. MCA is looking for a Data Analyst II who enjoyspresenting data to clients, creating meaningful and effective reports and datavisualizations, and partnering with customers to answer key business questions.As a Data Analyst II located in Bethesda, you will enhance value to customers byleveraging advanced analytics (descriptive, diagnostic, predictive, andprescriptive) and strong presentation skills to communicate program value andactionable insights. The Data Analyst II supports internal and externalcustomers by utilizing both in-house and third-party data sources, as well... asoptimizing reporting processes and communication between the variousstakeholders. Additionally, Data Analyst II supports high-profile projects inorder to develop and implement new analytical tools or methodologies. Throughsuccessful execution of duties and responsibilities, as supported by knowledgeand 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 forboth internal and external customers.Duties and Responsibilities Produce, document, and present ad-hoc or standard (weekly, monthly, quarterly) reports with accompanying visualizations and analyses to internal and external customers, with an ability to use lay terminology to communicate performance results and trends. Create reports (standard, ad-hoc, etc.) and visualizations from various data sources by querying database repositories/software and leveraging analytical tools: SSMS/VBA, Power BI, Excel, Access, and database user interface. Leverage Power BI to develop and improve dashboards/reports incorporating both statistics and visualizations. Support internal and external customers by combining both in-house and third-party data sources, as well as industry benchmarks and best practices, into actionable insights. Collaborate with clients, account/project managers, data analysts, and other MCA stakeholders to demonstrate program outcomes and articulate strategic recommendations to address client challenges. Supports data integrity, ensures reporting accuracy, and enables the optimization of reporting processes. Participates in and supports the organization s quality programs and the underlying tools/protocols that support them. Test prototype software and participate in the approval and release process for new software. Collaborate with technical staff to optimize/standardize data ingest, database tools, and reporting software. Work with key stakeholders to develop and maintain data standards and common data elements for data collection. 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.QualificationsEducation BA or BS degree required: Preferred:Bachelor of Science in a 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 experience Minimum 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' Compensation Minimum 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 validation Experience using industry-standard data visualization tools, BI tools, and dashboards incorporating both statistics and visualizations Experience working with both in-house and third-party data Experience working with project management and agile methodologies Expertise using all MS Office Suite toolsOther Skills and Abilities, QualificationsRequired Software Expertise: Preferred Advanced: MS Excel Intermediate: SQL, MS PowerPoint, MS Word Beginner (Preferred Intermediate): PowerBI, MS AccessAdditional Software Expertise: Beginner: MS VBA, Tableau, SSMS, R, Python US Citizen The ability to obtain and maintain a security clearanceFor a career path that is both challenging and rewarding, join Sedgwi