Data Analyst
Job Description
Lead data governance remediation for a large backlog by prioritizing critical tables and producing governance artifacts that make data understandable, trusted, and reusable.
- Lead end-to-end remediation planning for a large data governance backlog, covering intake, prioritization, sequencing, status tracking, risk identification, and deliverable follow-through.
- Identify and prioritize key tables needing governance artifacts using criteria such as usage, business value, data sensitivity, reporting dependencies, and readiness for broader enterprise consumption.
- Create, validate, and maintain governance artifacts including data dictionaries, source-to-target mappings (STTM), CDE documentation, metadata, lineage context, and related documentation.
- Use SQL for data profiling and validation to investigate and document tables, fields, transformations, joins, business rules, and data quality considerations.
- Partner with data governance teams to align deliverables to enterprise standards, metadata expectations, cataloging requirements, CDE practices, and artifact approval workflows.
- Collaborate with internal analysts and subject matter experts to gather knowledge of business processes, table usage, definitions, and reporting dependencies.
- Communicate progress and findings to stakeholders via progress summaries, blockers, decisions needed, risks, dependencies, and recommended next steps.
- Support democratization of governed data so other business units can understand, discover, and appropriately use internally warehoused data.
- Develop and maintain reporting/dashboard views, preferably in Power BI, to visualize remediation progress, backlog burn-down, artifact completeness, data readiness, and adoption opportunities.
- Recommend process improvements for documentation templates, governance intake, quality checks, and repeatable workflows to improve efficiency and reduce rework.
- Ensure documentation usability for analysts, data stewards, governance partners, and leadership audiences, balancing business-friendliness with technical accuracy.
- Contribute to analytics and BI work as remediation matures, including dashboard requirements, data modeling support, visualization design, and storytelling with governed data.
- Perform other duties as assigned.
Requirements
- Significant experience researching, compiling, documenting, and validating data, business processes, data flows, and analytical workflows.
- Advanced SQL to query large datasets, assess table structures, validate field logic, investigate data quality issues, and interpret joins or transformations.
- Demonstrated ability to manage complex workstreams with multiple stakeholders, dependencies, deadlines, deliverables, and quality expectations.
- Experience creating or maintaining data governance artifacts such as data dictionaries, metadata documentation, source-to-target mappings, data lineage notes, business definitions, or similar deliverables.
- Working knowledge of data governance, including metadata management, CDEs, data stewardship, data ownership, data quality, and governed data access.
- Working knowledge of data warehousing, including database structures, ETL/ELT processes, and analytical data pipelines.
- Strong communication skills to summarize technical findings, explain documentation needs, escalate blockers, and communicate progress to both technical and business audiences.
- Advanced ability to identify business requirements, clarify data definitions, resolve ambiguity, and recommend practical solutions.
- Ability to partner with governance teams, analysts, data owners, engineers, and business stakeholders to collect, validate, and publish high-quality documentation.
- Advanced skill interpreting data models, tables, reports, and documentation and translating them into formats that support enterprise decision-making and reuse.
- Experience with project tracking, issue management, status reporting, and documentation quality control.
- Advanced Microsoft Excel skills and familiarity with collaboration tools used to manage inventories, deliverables, status updates, and documentation review cycles.
- Bachelor’s degree in Information Systems, Computer Science, Engineering, Business Analytics, Data Analytics, or a related field, or the equivalent combination of training, education, and experience.
Technologies
- SQL
- Power BI
- Microsoft Excel
- Microsoft Purview
Desired Qualifications
- Power BI experience, including the ability to create dashboards that communicate plan, progress, risk, backlog burn-down, artifact completion, and adoption readiness.
- Experience applying data storytelling principles to turn governed data into leadership-ready insights, decisions, and recommendations.
- Experience with Microsoft Purview or similar data catalog, metadata management, or governance platforms.
- Experience supporting enterprise-wide or cross-business unit data governance, reporting, analytics, or documentation initiatives.
- Familiarity with semantic models, curated datasets, certified data products, self-service BI enablement, or analyst adoption programs.
- PMP certification, Agile certification, or commensurate experience managing cross-functional projects or enterprise workstreams.
- Advanced degree in Information Systems, Computer Science, Engineering, Business Analytics, Data Analytics, or a related field.
Success Profile
- A prioritized inventory of key tables requiring governance remediation is established and actively managed.
- Governance artifacts are completed with clear definitions, accurate mappings, defensible validation, and stakeholder sign-off.
- Backlog progress, blockers, and risks are visible through reliable reporting and, where possible, Power BI dashboards.
- Governed tables become easier for internal teams and business units to discover, understand, and responsibly reuse.
- The analyst demonstrates SQL, Power BI, and storytelling capabilities needed to support a potential shift toward a broader BI role.
Location and Pay
- Work location: Vienna, VA (onsite)
- Pay: $65.00 - $68.00 per hour