Note: The job is a remote job and is open to candidates in USA. ECRI is an independent, nonprofit healthcare safety organization advancing evidence-based, effective healthcare globally. The Data Analyst, MDM supports data analysis, data quality, enterprise business intelligence, Master Data Management operations, Power BI reporting, analytics engineering, and data governance. The role partners with IT and business stakeholders to deliver actionable insights and maintain reliable enterprise data assets.
Responsibilities
- Support ongoing MDM platform configuration, build activities, and release deployments in collaboration with senior team members using standard development tools (e.g., code editors, version control)
- Assist with data stewardship workflows, including reviewing match and merge candidates, resolving survivorship exceptions, and validating master records
- Develop and maintain basic ETL scripts and data transformation logic to support source system ingestion and master data processing
- Monitor and troubleshoot MDM data integration pipelines, escalating issues and coordinating resolution with IT
- Document MDM business rules, data mappings, and configuration changes to sustain an accurate and current data dictionary
- Support onboarding of additional source systems into the master domain as ECRI’s integration footprint evolves
- Develop and maintain metrics and usage analytics for ECRI’s content assets using command-line interface (CLI) tooling and scripting to extract, transform, and report on content data
- Profile and validate content metadata to support taxonomy migration initiatives and related content classification efforts
- Automate routine content data extraction and reporting tasks through CLI-based workflows, reducing manual effort and improving consistency
- Participate in Power BI report development, assisting with the design, build, and maintenance of dashboards and reports across business domains
- Support the Power BI Enterprise Hub by contributing to workspace organization, dataset management, and report lifecycle activities
- Assist with data modeling, DAX measure development, and semantic layer construction for new reporting requirements
- Fulfill ad hoc data pull and analysis requests from business leaders that do not yet warrant a formal reporting engagement
- Conduct data quality assessments in Google BigQuery and connected source systems, identifying anomalies, gaps, and integrity violations
- Develop and maintain reusable BigQuery views and/or SQL-based data models that serve as the foundation for Power BI reporting and self-service analytics
- Own and expand the data validation test suite for key reporting datasets, including row count checks, null analysis, referential integrity, and business logic verification
- Support data integration, migration, and transformation activities as part of enterprise data and ongoing application modernization and/or transformation initiatives
- Prepare and validate structured datasets for analytical, AI/ML, and evaluation use cases
- Provide subject matter expertise on data sources, data flows, and reporting best practices to stakeholders and team members
- Proactively identify opportunities to enhance data processes, reporting capabilities, and data literacy across the organization
- Stay current with industry trends and best practices in data analytics, BI, data quality, and MDM
- Other duties, as assigned
Skills
- 2–4 years of experience in data analysis, business intelligence, data quality, or a related field
- Hands-on experience with SQL and a cloud data warehouse (e.g., BigQuery or equivalent) for data extraction, profiling, and validation
- Demonstrated experience with Power BI, including report development, basic data modeling, and workspace interaction
- Experience with data quality assessment, data cleansing, and remediation techniques
- Experience using Jira or similar issue tracking tools to manage tasks and releases
- Bachelor's degree in Business Administration, Computer Science, Information Systems or related field or equivalent work experience
- Proficient with SQL
- Proficient with Microsoft Power BI for report development and dataset interaction
- Proficient with Visual Studio Code or a comparable code editor for script development and ETL authoring
- Familiarity with command-line interface (CLI) tooling and shell scripting (e.g., Bash, Python) for data extraction and automation tasks
- Proficient with Atlassian Jira and Confluence or comparable tools
- Proficient with Microsoft Office 365 Suite (Word, Excel, PowerPoint)
- Exposure to Master Data Management (MDM) platforms or comparable data management systems is highly desirable
- Experience working with CLI-based tooling or scripting environments for data extraction, automation, or reporting tasks preferred
- Beginner-to-intermediate familiarity with ETL concepts and lightweight data transformation scripting preferred
- Experience working in healthcare, life sciences, or a regulated industry preferred
- Familiarity with data governance principles, data cataloging, or metadata management is a plus
- Experience with Google BigQuery
- Working knowledge of Semarchy SDP or a comparable MDM platform
- Familiarity with Contentful or a comparable headless CMS and its CLI tooling
- Exposure to basic ETL concepts and lightweight data pipeline development
- Microsoft Certified: Power BI Data Analyst Associate (preferred)
- Certified Health Data Analyst (CHDA) (optional)
Benefits
- Comprehensive healthcare coverage: Medical, dental, vision, life insurance, disability coverage, critical illness insurance, and more.
- Employer-matching Retirement Savings Plan.
- Participate in employee groups to learn from, grow with, and support colleagues in our collective success.
- 16 paid hours annually through ECRI Cares to volunteer with preapproved charities.
- Health and welfare benefits.
- 403(B) retirement savings.
- Paid time off (PTO).
- Fully remote work arrangement
Company Overview
Company H1B Sponsorship