Data Analyst

Progressive Technology Solutions; Vienna (VA); On-site; USD 87,000 - 94,000; Full time

Job summary

Progressive Technology Solutions in Vienna, VA seeks a data governance lead to drive remediation of a large backlog, prioritizing critical tables and producing governance artifacts that ensure data is understandable, trusted, and reusable.

You will collaborate with governance teams, apply advanced SQL for profiling, build dashboards in Power BI to visualize progress, and establish repeatable workflows for documentation, metadata, and data lineage.

Qualifications

• 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.
• Experience creating or maintaining data governance artifacts such as data dictionaries, metadata documentation, source-to-target mappings, data lineage notes, 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, elevate 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.

Responsibilities

• 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.

Skills

Advanced SQL

Power BI

Data governance

Data profiling

Stakeholder management

Data warehousing

SQL querying

Education

Bachelor's degree in Information Systems/CS/Engineering/Business Analytics or related field

Tools

Microsoft Purview

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, elevate 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