Senior Data Analyst - Health Equity BI

Impaq International, Llc Columbia , MD 21044

Posted 2 months ago


IMPAQ International, a growing and dynamic social science research firm, provides high-quality research and impact evaluation services, policy analysis, survey research, technology solutions, organizational development, technical assistance and consulting services to U.S. and international government agencies, foundations, and the private sector. IMPAQ's mission is to bring together exceptional people to develop innovative and rigorous approaches to evaluate the real-world impact of social policies and programs. IMPAQ has a diverse and collegial work environment and is an Equal Opportunity/Affirmative Action Employer (M/F/Disability/Veterans).

IMPAQ is seeking a self-motivated Business Intelligence (BI) Specialist to join our exceptional team of experts who work to improve the health and well-being of millions of people. The BI Specialist will be a member of IMPAQ Health and support health-focused projects with a focus on supporting Centers for Medicare & Medicaid Services (CMS) and National Institutes of Health (NIH) projects related to COVID-19, social determinants of health, health equity, and government funded programs affecting vulnerable populations.

The ideal candidate will demonstrate strong problem-solving skills and experience in the design and support of BI reporting through off-the-shelf data visualization solutions (Power BI and potentially Tableau), and data warehouse environments.

This role will work across teams and help gather, document, and select business and database requirements for an interactive user interface that allows ad hoc data analysis and exporting. The BI specialist should have knowledge of data structure design for flexible BI solutions, including implementation of data visualizations. In addition to possessing solid fundamental research skills, this position requires the ability to work with customers, users, and other contractors to develop interactive dashboards and other graphical representations of data to further research and policy decisions.

Applicants must be currently authorized to work in the U.S. on a full-time basis. Employment-based visa sponsorship (including H-1B sponsorship) is not available for this position


  • Gather, document, and select business and database requirements for dashboard user interfaces

  • Provide requirements and documentation for the construction, cleaning, merging, and manipulation of datasets for both internal and project-related use

  • Provide data warehouse and cloud computing requirements for hosting a BI user interface (e.g. for Azure, AWS, etc.)

  • Design and develop data visualizations, including static charts for reports and dynamic dashboards

  • Conduct user research and usability testing and collaborate with the human centered design efforts

  • Write, compile, and edit assigned portions of project reports

  • Develop quality assurance protocols for BI solution

  • Review work products to ensure quality and consistency of content


Education, Knowledge, and Experience

  • BA/BS or Master's Degree in Information Systems, Data Science, Statistics, Public Policy, Computer Science, or related field; or equivalent years of experience

  • 2+ years of experience implementing enterprise-scale reporting systems using PowerBI

  • Hands-on experience using Power BI

  • Knowledge of data analysis and data management techniques

  • Experience managing data using Azure cloud computing services


  • Experience with developing requirements for data warehouse implementations

  • Hands-on experience using other data visualization tools, such as Tableau, JavaScript, or MicroStrategy

  • Experience in graphic design

  • Data manipulation experience using Python, SQL, or other similar tools

  • Experience managing data using AWS cloud computing services


  • BI, data visualization, and design methodology

  • Data architecture

  • User interface design

  • Qualitative and quantitative research methods

  • Strong organizational, planning, oral, and written communication skills

  • Ability to take initiative, learn quickly, work independently and in a team environment

  • Creative, professional, and strong attention to detail

  • Exposure to project management and technical assistance

All qualified applicants will receive consideration for employment without discrimination on the basis of race, color, religion, sex, gender, gender identity/expression, sexual orientation, national origin, protected veteran status, or disability.

IMPAQ International adheres to strict child safeguarding principles. All selected candidates will be expected to adhere to these standards and principles and will therefore undergo rigorous reference and background checks.

Please note, each section of the application is required in order for you to be considered for this opportunity. If you do not complete the required screening questions, or if you close your browser before completing each section of the application, your application will not be submitted for this position.

IMPAQ International is an equal employment opportunity/affirmative action employer committed to excellence through diversity. Minorities, women, individuals with disabilities and veterans are encouraged to apply.

IMPAQ International's commitment to Diversity goes beyond legal compliance to its full integration in our strategy, operations and work environment. Diversity is valued and Inclusion is reflected in all efforts to recruit, develop, and engage the diverse staff needed to accomplish our mission.

ACCESSIBILITY NOTICE: If you need a reasonable accommodation for any part of the employment process due to a physical or mental disability, please send an email to Morena Martinez at or call 443.259.5207.

icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Forensic Data Analyst


Posted 2 weeks ago

VIEW JOBS 1/8/2021 12:00:00 AM 2021-04-08T00:00 Resp & Qualifications PURPOSE: The Forensic Data Analysis position will be solely dedicated to the CareFirst Special Investigations Unit (SIU). This role will play a pivotal part in helping the SIU consume, standardize, and interpret data and information to meet evolving operational and client needs. The position requires preparation of statistical/financial analysis reports and graphic presentation for notification of findings. The role of the Forensic Data Analyst will entail being a power user of the assigned data software in detecting and investigating provider and member leads for investigation of potentially fraudulent or abusive billing, claims patterns, and/or other outliers requiring further analysis by SIU, Management and Investigators. PRINCIPAL ACCOUNTABILITIES: Under the direction of the SI Manager, functions include but are not limited to: Perform data analytics to identify fraud, waste or abuse in claims data. Proactively identify instances of potential fraud, waste and abuse through data analysis using company systems and tools. Utilize knowledge of healthcare coding conventions, fraud schemes, general areas of vulnerability, reimbursement methodologies and relevant laws to find suspicious patterns in claims data and other sources. Develop and maintain general knowledge healthcare reimbursement policies and state and federal regulations related to healthcare fraud and abuse. Provide comparative analysis of data and apply it to external audit methodology and operational/business needs. Collaborates with departmental staff, management and other internal departments to collect and analyze corporate records as directed by management. Assist Investigators and staff in preparing cases for referral to OPM-OIG for potential criminal or civil litigation when appropriate. Work with BCBSA Consultant in supporting that cases are referred to the OPM-OIG in accordance with Contract CS 1039 and the FEHBP Carrier Letters. Extract complex formulated data from corporate systems and produce operational ad-hoc reports for use in conducting audit examinations of providers. Communicate results of reports in both verbal and written form to all levels of the company as well as to external entities when required and appropriate. Gathers and conducts forensic analysis of corporate records and related billing data to build profiles of individuals or groups potentially participating in fraud, waste or abuse against CareFirst. Performs complex data retrieval and analysis relating to professional, facility, pharmacy and vendor billing histories. Researches and prepares summaries of medical and payment polices for use by Investigators. Compiles findings, recommendations and conclusions into financial investigative reports. On occasion will accompanying Investigators on interviews of subjects and key witnesses. Performs other duties as necessary or appropriate to position. QUALIFICATIONS: Required: Bachelor's degree in Business, Healthcare Analytics, Mathematics, Statistics or related field, with at least 4 years of experience in data analysis and report design or the equivalent combination of education and experience. Abilities/Skills: * Demonstrated experience with Microsoft Office products and strong Excel skills * Excellent oral/written communication and interpersonal skills * Provides consulting and analytic services to leadership * Perform analytic tasks for internal or customer specific projects * Experience with report writing and business correspondence * Ability to coordinate activities with varying levels of management, staff, external agencies, and medical professionals through strong verbal and written communications * Evaluate and preprocess raw information * Ability to plan, organize, and manage projects with minimal supervision * Ability to deliver results within agreed upon timeframes * Highly motivated, with strong drive, team spirit, and organizational skills * Ability to work effectively both independently and as a team-member * Proven judgment, analytical, decision making, and problem-solving ability * Dependable with the highest level of integrity * Demonstrate ability to comprehend Federal/State law and desire to further knowledge with additional education * Ability to handle highly confidential and sensitive information while ensuring compliance with the Company's privacy policies * Ability to travel as required, including occasional overnight stays. Must have transportation. Preferred: Certified Health Data Analyst (CHDA®), Credentials as Certified Fraud Examiner (CFE), Accredited Health Fraud Investigator (AHFI), or Certified Professional Coder (CPC). In depth knowledge of corporate and divisional policies and procedures, claims processing, underwriting, medical policies, enrollment and billing and/or other related systems and procedures to determine the integrity of claims' payments and business operations within CareFirst or previous experience in the healthcare industry. Equal Employment Opportunity CareFirst BlueCross BlueShield is an Equal Opportunity (EEO) employer. It is the policy of the Company to provide equal employment opportunities to all qualified applicants without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, protected veteran or disabled status, or genetic information. Hire Range Disclaimer Actual salary will be based on relevant job experience and work history. Where To Apply Please visit our website to apply: Closing Date Please apply before: 1.6.21 Federal Disc/Physical Demand Note: The incumbent is required to immediately disclose any debarment, exclusion, or other event that makes him/her ineligible to perform work directly or indirectly on Federal health care programs. PHYSICAL DEMANDS: The associate is primarily seated while performing the duties of the position. Occasional walking or standing is required. The hands are regularly used to write, type, key and handle or feel small controls and objects. The associate must frequently talk and hear. Weights up to 25 pounds are occasionally lifted. Sponsorship in US Must be eligible to work in the U.S. without Sponsorship Carefirst Columbia MD

Senior Data Analyst - Health Equity BI

Impaq International, Llc