Mid Level Data Analyst

Data Analyst
12 Month+ Contract
Hybrid – 3 Days/wk on-site in either Vienna, VA/Winchester, VA/ or Pensacola, FL 
Hourly Rate: $60/hr. range, W2. Benefits available
On-Site Interview Expected

System One IT has a 12-month+ contract opening for a Data Analyst to support a leading financial services customer.

Must have:

• SQL - needed to pull tables and associated data elements/columns.
• Organization/project management/reporting - needed to provide stakeholders updates on progress and ensure full inventory is reviewed and captured.
• Knowledge of data governance practices (creating data dictionaries, sttms, cdes)
• Working in teams - this project cannot be done in a silo and will require peer and stakeholder support.

Nice to have:

• Power BI experience
• Executive presentations
• Translating data trends into insights

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 capabilities 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, escalate blockers, and communicate progress to both technical and business audiences.
• Advanced skill in 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 in 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, 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.

System One, and its subsidiaries including Joulé and Mountain Ltd., are leaders in delivering outsourced services and workforce solutions across North America. We help clients get work done more efficiently and economically, without compromising quality. System One not only serves as a valued partner for our clients, but we offer eligible employees health and welfare benefits coverage options including medical, dental, vision, spending accounts, life insurance, voluntary plans, as well as participation in a 401(k) plan.

System One is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, age, national origin, disability, family care or medical leave status, genetic information, veteran status, marital status, or any other characteristic protected by applicable federal, state, or local law.

#M-MM1
#LI-MM1

Ref: #851-Rockville-S1