Data Analyst

ECS Corporate Services; Fairfax (VA); On-site; USD 93,000 - 140,000; Full time

Job summary

Everforth ECS in Arlington, VA is seeking a Data Analyst to manage data targets and quality for the CDM Data Services - BETSIE Program. You will liaise with Agile teams, program leadership, and customer representatives to understand data models and support change requests with impact analyses.

The role emphasizes data modeling concepts, data dictionaries, governance, and building reporting solutions, dashboards, and data quality processes while ensuring accuracy and compliance with federal

Qualifications

• Experience with data modeling concepts and ERD/UML.
• Ability to design and implement data quality processes and data dictionaries.
• Strong communication with stakeholders across Agile teams and leadership.
• Proficiency with SQL and relational databases for data extraction and analysis.

Responsibilities

• Ensure data collection, processing, and analysis meet objectives.
• Design and deliver reporting and analytics solutions with stakeholders.
• Collaborate to gather data requirements and improve visualization.
• Respond to ad hoc data requests and educate users on reports/dashboards.
• Create, test, and demo reports and dashboards and refine based on feedback.
• Improve data quality and program metrics with documentation and automation.
• Monitor system performance metrics and report trends.
• Research and implement new reporting and analytics features.

Skills

Data modeling

Data quality

Stakeholder comms

SQL databases

UML/ERD

Data dictionaries

Tools

Alation

Collibra

SQL

Job description

Everforth ECS is seeking a Data Analyst to work in our Arlington, VA office.

Job Description: This candidate will serve as a key point of contact in managing data target and data quality aspects of the CDM Data Services - BETSIE Program. Successful candidates will have excellent communication skills and will interact with stakeholders spanning multiple Agile teams, program leadership, and customer representatives. All parties have an interest in understanding and/or implementing the data model with quality in mind. Successful candidates will have an intermediate understanding of data modeling concepts and be able to perform impact analysis on change requests, respond to queries, and facilitate independent analysis efforts. Furthermore, the successful candidate will serve as the liaison for the customer's data quality efforts, participating in regular meetings, representing the CDM Data Services - BETSIE program, and supporting the requirements gathering process.

Specific Duties Include:

• Ensuring technical and performance objectives related to data collection, processing, and analysis.
• Design and deliver reporting and analytics solutions independently and in collaboration with stakeholders, ensuring alignment with program objectives.
• Collaborate with cross-functional teams to gather and understand data requirements, identify pain points, and opportunities for improved data visualization and interaction.
• Respond to ad hoc data requests, troubleshoot issues, and provide user education on reports and dashboards.
• Create, test, and demo reports and dashboards, actively seeking feedback to refine and enhance user experiences.
• Improve data quality and program metrics by developing appropriate documentation, automating data extraction, and generating visual reports.
• Monitor and analyze system performance metrics, identifying trends or anomalies and reporting findings regularly.
• Research, build and implement new reporting and analytics features.
• Perform other duties as needed to support the program's success.

Salary Range: $93,000 - $140,000

General Description of Benefits

US citizenship with ability to obtain Public Trust Suitability.

At least three years of experience analyzing customer data requirements and prescribing and implementing solutions to meet those requirements.

Must have prior experience working on data models:

• Developing and documenting data models
• Adhering to data modeling standards
• Interpreting data model intent
• Managing the change process for data models
• Serve as the SME supporting data modeling efforts

Must have an excellent understanding of:

• UML standards and knowledge of entities, attributes, relationships on an ERD
• Database management systems (i.e. relational, non-relational)
• Understanding of data normalization processes
• Knowledge of Federal Cybersecurity and Federal Cybersecurity and Risk Management Policies and practices, including: FISMA; NIST 800-37, 800-53, 800-30, 800-39; NISTIR 8286 Series, and FedRAMP.
• Experience creating and maintaining Data Dictionaries and/or Data Catalogs to describe data inventories and schemas to help users understand, locate, and utilize data within the system.
• Knowledge of data transformation processes and experience documenting and maintaining data lineage, esp. traceability of transformed data to source data.
• Experience utilizing data cataloging and governance tools, esp. Alation and Collibra to help organizations improve data management, collaboration, and governance.
• Experience automating assessment of data quality.