Business Analyst

Key Responsibilities

• Perform data and process analysis to identify errors, anomalies, and root causes while partnering with data owners to improve data collection, generation, and business processes.
• Analyze and identify new data sources for integration into Master Data Management (MDM) platforms, performing attribute-level profiling and documenting match-merge rules.
• Create Business Requirements Documents (BRDs), Technical Requirements Documents (TRDs), business process documentation, and technical metadata to support system enhancements and stakeholder communication.
• Support enterprise Master Data Management (MDM) initiatives using Informatica tools, including Informatica Data Quality (IDQ), for data profiling, cleansing, standardization, reconciliation, mapping, and transformation.
• Design logical and physical data models using SQL Developer and Snowflake to support enterprise data architecture and reporting initiatives.
• Identify, analyze, and resolve complex data quality issues across multiple environments using data modeling and dimensional modeling techniques.
• Collaborate with business stakeholders, HHS subject matter experts, and technical teams to document current-state and future-state business processes and data requirements.
• Develop data quality scorecards, source system trust metrics, and attribute profiling reports to support data governance initiatives.
• Write complex SQL queries to analyze large datasets, validate data integrity, and support business reporting and decision making.
• Build and maintain dashboards, reports, KPIs, and data quality metrics while ensuring the accuracy and integrity of enterprise reporting.
• Develop user documentation, training materials, and demonstrations to support adoption of new MDM capabilities and business processes.
• Support Agile project execution by utilizing JIRA for project tracking while partnering with development and reporting teams to deliver business solutions.

Day to Day Responsibilities

• Analyze healthcare and enterprise data, including ADT and CDA message formats, to support integration, interoperability, and reporting initiatives.
• Perform data profiling, validation, cleansing, reconciliation, and transformation activities across multiple data sources.
• Develop and execute SQL queries to analyze data, troubleshoot issues, and support business analysis requests.
• Create and maintain process documentation, metadata, reporting documentation, and technical specifications.
• Utilize Informatica, Snowflake, SQL Developer, Tableau, Excel, PowerPivot, SharePoint, Access, Word, and PowerPoint to support data management and reporting activities.
• Collaborate with cross-functional business and technical teams to gather requirements, validate solutions, and support project deliverables.
• Monitor data quality, investigate discrepancies, and implement corrective actions to improve data integrity.
• Maintain reporting dashboards and scorecards while supporting ongoing business intelligence and analytics initiatives.
• Participate in project meetings, status updates, and requirements sessions while supporting project managers and technical teams.
• Develop a deep understanding of enterprise data sources, collection methodologies, and data pipelines to support strategic reporting and analytics.

Preferred Experience and Attributes

• Experience as a Business Data Analyst, Data Analyst, Business Systems Analyst, or Project Manager supporting enterprise data initiatives.
• Strong experience with Master Data Management (MDM) concepts and implementations.
• Hands-on experience with Informatica, including Informatica Data Quality (IDQ), ETL processes, and data integration.
• Advanced SQL skills with experience querying and analyzing large relational databases.
• Experience with Snowflake, SQL Developer, Tableau, Excel, PowerPivot, SharePoint, Access, and Microsoft Office applications.
• Experience creating BRDs, TRDs, process flows, business documentation, and technical specifications.
• Knowledge of data modeling, dimensional modeling, metadata management, and data governance best practices.
• Experience supporting healthcare data environments, including ADT and CDA message standards, is highly preferred.
• Strong analytical, problem-solving, and root cause analysis skills.
• Excellent communication skills with the ability to collaborate across business and technical teams.
• Experience working in Agile environments utilizing JIRA or similar project management tools.
• Strong organizational skills with the ability to manage multiple priorities in a fast-paced, cross-functional environment.