Mid Level Data Analyst

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.