Mid Level Data Analyst

Edge Services; Vienna (VA); On-site; USD 85,000 - 115,000; Full time

Job summary

Edge Services is seeking a mid-level Data Analyst to lead remediation of a large data governance backlog. You will identify priority tables and develop governance artifacts to make data understandable, trusted, and reusable across the enterprise.

You will build data dictionaries, STTM, CDE documentation, and lineage notes while coordinating with governance partners and data owners. Strong SQL and Power BI skills will be essential as you enable broader data usability.

Qualifications

• Significant experience researching, compiling, documenting, and validating data, business processes, data flows, and analytical workflows.
• Advanced SQL skills to profile, validate, and document tables, transformations, and data quality.
• Experience managing complex workstreams with multiple stakeholders, deadlines, and deliverables.
• Experience creating data dictionaries, metadata docs, STTM, and lineage notes.
• Knowledge of metadata management, data governance concepts, and data quality practices.
• Familiarity with data warehousing concepts, ETL/ELT, and analytical pipelines.
• Strong written and verbal communication to summarize findings for technical and business audiences.
• Ability to collaborate with governance teams, data owners, engineers and analysts to publish high-quality docs.

Responsibilities

• Lead remediation plan for a large data governance backlog from intake to delivery.
• Identify and prioritize core tables requiring governance artifacts.
• Create and maintain data dictionaries, STTM, CDE docs, metadata and lineage notes.
• Profile and document tables using SQL, including business rules and data quality checks.
• Align deliverables with enterprise standards and governance workflows.
• Collaborate with analysts and subject matter experts to capture process knowledge.
• Translate technical findings into concise stakeholder updates, risks, and next steps.
• Support democratization of governed tables for enterprise use.
• Develop Power BI dashboards to visualize remediation progress and readiness.
• Propose improvements to templates, processes, and quality controls.
• Ensure documentation is clear for analysts, data stewards, and leadership.
• Contribute to analytics work as backlog matures, including BI requirements and storytelling.
• Perform other duties as assigned.

Skills

SQL

Excel

Data storytelling

Communication

Education

Bachelor's degree

Advanced degree

Info Systems / CS / Eng / Analytics

Tools

Power BI

Microsoft Purview

Job description

This mid-level Data Analyst will lead the remediation of a large data governance backlog, with a primary focus on identifying priority tables and developing the governance artifacts needed to make those tables understandable, trusted, and reusable. The role will produce and coordinate artifacts such as data dictionaries, source-to-target mappings (STTM), critical data element (CDE) documentation, lineage context, and related metadata documentation. The analyst will work with governance partners, data owners, internal analyst teams, and subject matter experts to accelerate backlog clean-up while preserving quality, traceability, and business usability. The successful candidate will combine strong SQL and analytical skills with disciplined project management and clear stakeholder communication. They will help democratize clean and governed tables for broader enterprise use, enabling business units to confidently benefit from internally warehoused data. Power BI experience is strongly preferred, particularly the ability to visualize remediation plans, progress, risks, and outcomes. Upon successful completion of the governance backlog, there may be an opportunity for the role to evolve into a more business intelligence-oriented position, depending on demonstrated capability in Power BI, SQL, and data storytelling.

RESPONSIBILITIES

• Lead the end-to-end remediation plan for a large data governance backlog, including intake, prioritization, sequencing, status tracking, risk identification, and follow-through on deliverables.
• Identify and prioritize key tables that require governance artifacts based on usage, business value, data sensitivity, reporting dependency, and readiness for broader enterprise consumption.
• Create, validate, and maintain data dictionaries, source-to-target mappings (STTM), CDE documentation, metadata, lineage context, and related governance artifacts.
• Use SQL to profile, validate, investigate, and document tables, fields, transformations, joins, business rules, and data quality considerations.
• Partner with data governance teams to align deliverables with enterprise standards, metadata expectations, cataloging requirements, CDE practices, and artifact approval workflows.
• Collaborate with internal analyst teams and subject matter experts who possess unique knowledge of business processes, table usage, definitions, and reporting dependencies.
• Translate technical findings into clear, concise updates for stakeholders, including progress summaries, blockers, decisions needed, risks, dependencies, and recommended next steps.
• Support democratization of clean, governed, well‑documented tables so other business units can understand, discover, and use internally warehoused data appropriately.
• Develop and maintain reporting or dashboard views, preferably in Power BI, to visualize remediation progress, backlog burn‑down, artifact completeness, data readiness, and adoption opportunities.
• Recommend improvements to documentation templates, governance intake processes, quality checks, and repeatable workflows that increase efficiency and reduce manual rework.
• Ensure documentation is business‑friendly, technically accurate, and usable by analysts, data stewards, governance partners, and leadership audiences.
• Contribute to analytics and business intelligence work as backlog remediation matures, including dashboard requirements, data modeling support, visualization design, and storytelling with governed data.
• Perform other duties as assigned.

QUALIFICATIONS

• Significant experience researching, compiling, documenting, and validating data, business processes, data flows, and analytical workflows.
• Advanced SQL skills, including the ability 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 dictionaries, metadata documentation, source-to-target mappings, data lineage notes, business definitions, or similar governance artifacts.
• Working knowledge of data governance concepts, including metadata management, CDEs, data stewardship, data ownership, data quality, and governed data access.
• Working knowledge of data warehousing concepts, database structures, ETL/ELT processes, and analytical data pipelines.
• Strong communication skills with the ability to summarize technical findings, explain documentation needs, escalating blockers, and communicate progress to both technical and business audiences.
• Advanced skill identifying business requirements, clarifying data definitions, resolving ambiguity, and recommending practical solutions.
• Ability to partner effectively 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 decision‑making and enterprise 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.

DESIRED QUALIFICATIONS

• Power BI experience, including the ability to create dashboards that communicate plan, progress, risks, 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.