Sign upLog in
Data Analysis Jobs in Washington, DC

Master Data Analyst

Macpower Digital Assets Edge Private Limited
  • Washington, DC
  • $100,000–$107,000 Per Year
  • Quick Apply
2 days ago

Job Description

Executive Summary:
  • We are seeking a highly experienced Master Data Analyst to understand functional and technical requirements, analyze data, develop and deploy complex reports, and create project documentation related to agency applications.
  • The ideal candidate is a DMV resident with 16 years of extensive experience in relational database technologies, SQL development, and data analysis, with expertise in authorized IT system approaches for database management.
  • The candidate will ensure the accuracy, consistency, and integrity of data across multiple systems, collaborate with cross-functional teams, and support continuous improvement in data quality and governance.
Position Responsibilities
  • Interface independently with high-level stakeholders via meetings, emails, and calls to manage data projects.
  • Gather and document requirements and collect sample data throughout all project phases to ensure data quality.
  • Work with agency resources to analyze, compile, verify, and query data for data warehousing and reporting purposes.
  • Develop complex SQL queries for reports, dashboards, and business intelligence tools.
  • Create and maintain metadata and data dictionaries.
  • Design and document methods to implement new database systems.
  • Develop and implement reports using SQL and other BI tools.
  • Develop and administer data standards, policies, and procedures; propose new standards and techniques.
  • Design solutions to meet processing requirements and solve complex problems.
  • Develop scripts to identify and correct data inconsistencies in incoming data.
  • Troubleshoot database and reporting issues, including input, retrieval, and modification of enterprise data.
  • Perform complex data analyses to validate, correct, and reconcile data inconsistencies.
  • Analyze requirements and specifications for enterprise systems and applications.
  • Plan for anticipated changes in data capacity requirements.
  • Evaluate the impact of technological changes and propose solutions to complex technical issues.
  • Operate and maintain Business Intelligence systems and ancillary analytics systems.
  • Coordinate activities with project managers throughout the full Software Development Life Cycle (SDLC), including design, development, and testing.
  • Act as a technical lead on data-driven reporting and application development projects with minimal oversight.
  • Keep abreast of current trends in database management, analytics, and data governance.
  • Perform other related duties as assigned.
Required Qualifications
  • 16 years of experience with relational database technologies and SQL development.
  • Extensive knowledge of IT standards, principles, concepts, methods, policies, and system testing approaches.
  • Extensive knowledge of authorized IT system approaches for database management.
  • Expertise in analytical methods, requirement analysis, and problem-solving.
  • Extensive experience in data modeling, metadata creation, data dictionaries, database views, and dashboards.
  • Deep understanding of data warehousing concepts and collaboration with data architects on schema design.
  • Knowledge of BI systems operations and maintenance.
  • Strong communication skills to effectively convey technical and non-technical information.
  • Demonstrated ability to speak and write clearly to diverse audiences.
  • Expert in data analysis and SQL code development.
  • Knowledge of SDLC and ability to manage small IT projects with minimal oversight.
Education / Certification Requirements
  • Bachelor's degree in IT or a related field, or equivalent experience.

Numbers & Facts

LocationWashington, DC
Salary$100,000–$107,000 Per Year

Skills

  • Analysis Skillsunmatched
  • Business Intelligenceunmatched
  • Business Intelligence Softwareunmatched
  • Business Solutionsunmatched
  • Capacity Requirements Planning (CRP)unmatched
  • Communication Skillsunmatched
  • Continuous Improvementunmatched
  • Cross-Functionalunmatched
  • Data Administrationunmatched
  • Data Analysisunmatched
  • Data Collectionunmatched
  • Data Managementunmatched
  • Data Modelingunmatched
  • Data Qualityunmatched
  • Data Warehousingunmatched
  • Database Administrationunmatched
  • Database Analysisunmatched
  • Database Designunmatched
  • Database Management Software/Systems (DBMS)unmatched
  • Database Technologyunmatched
  • Design Documentunmatched
  • Documentationunmatched
  • Enterprise Applicationsunmatched
  • Functional Analysisunmatched
  • Identify Issuesunmatched
  • Information Technology & Information Systemsunmatched
  • Management of Information Systems/Technology (MIS)unmatched
  • Metadataunmatched
  • Problem Solving Skillsunmatched
  • Project Trackingunmatched
  • Project/Program Coordinationunmatched
  • Project/Program Managementunmatched
  • Reconciliationunmatched
  • Relational Databases (RDBMS)unmatched
  • Reporting Dashboardsunmatched
  • Requirements Managementunmatched
  • SQL (Structured Query Language)unmatched
  • Scripting (Scripting Languages)unmatched
  • Software Developmentunmatched
  • Software Development Lifecycle (SDLC)unmatched
  • Specimen Collectionunmatched
  • System Operationsunmatched
  • System Testunmatched
  • Systems Analysisunmatched
  • Systems Maintenanceunmatched
  • Technical Leadershipunmatched
  • Technology Analysisunmatched
  • Telephone Skillsunmatched
  • Test Plan/Scheduleunmatched
  • Trend Analysisunmatched

Be found by employers

5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.

Level up your application

Professional resume templates

Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.

Free resume templates

Free resume builder

Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.

Free resume builder