Sr. Business Analyst

Agile Defense•Arlington, VA

23h•Hybrid

About The Position

At Agile Defense, we are committed to adaptive innovation to support our nation's most important missions. The Sr. Business Data Analyst will provide data governance and analytics support to USMS by implementing and maintaining effective data governance frameworks and compliance. This role also involves delivering insightful business intelligence reports designed to empower informed decision-makers.

Requirements

Bachelor’s degree in a relevant discipline from an accredited institution of higher learning.
5+ years of experience with data architecture, data management, data analysis, IT process reengineering, systems analysis, design, and implementation, and data modeling.
Hands-on experience with data migration/integration of multiple data sources into a single repository.
Hands-on experience with Data Analysis.
Hands-on experience with SQL programming language (e.g., ANSI SQL).
Familiarity with reporting/ad-hoc analysis tools such as Tableau, Power BI.
Knowledge of Master Data Management principles.
Knowledge of Data Integration and Data Migration.
Knowledge of Microsoft Power Apps.
Expert knowledge of MS Office Suite (Word, SharePoint, Excel, and PowerPoint).
Excellent communication, consultation, conflict resolution, negotiation, and facilitation skills.
Able to contribute to creating, refining, and documenting team business processes (e.g., in SOPs, design documents, process diagrams, etc.) in a highly flexible environment.
Able to be flexible and able to thrive in a time-sensitive environment to meet strict deadlines with sudden and unpredictable needs.
Able to independently synthesize unstructured feedback from stakeholders and consider relevant data to present quality business solutions.
Proven problem-solving skills with demonstrated ability to think out of the box and generate creative solutions; ability to break a complex problem down into its component parts and arrive at the appropriate solution in a timely fashion.
Positive attitude, averse to the status quo, always looking to improve current processes and procedures; ability to see opportunities for change, capitalize on them, and implement them when appropriate for the benefit of the organization.
A self-starter with a strong work ethic who sets high standards for self and others and demonstrates enthusiasm for the mission of the team.
U.S. Citizenship (pursuant to a government contract).

Nice To Haves

Knowledge of external data standardization and exchange organizations such as NIEM, FBI CJIS, and ISO.
Knowledge of SQL Server 2016 Master Data Services (MDS).
Knowledge of database and programming tools such as SQL Server and Visual Studio.
Knowledge of Amazon S3 and AWS Athena query tool.
Familiarity with Microsoft Visual Studio.

Responsibilities

Develop, refine, and implement organization-wide data governance policies, procedures, and standards to ensure data accuracy, integrity, and security.
Collaborate and work with business users and IT partners to remediate identified gaps, using both manual and automated solutions.
Conduct regular data audits and assessments to identify and rectify data issues and discrepancies.
Provide consultation and direct support to product owners, developers, business analysts, end users, and other customers to further data governance program initiatives.
Create, refine, and document team business processes (e.g., in Standard Operating Procedures and/or process diagrams) in a highly flexible environment.
Coordinate with other team members to reach project milestones and deadlines.
Perform data cleansing and standardization (e.g., removing duplicates, sanitization), assessing data quality, and eliminating irrelevant data to identify and interpret data patterns and trends.
Plan and execute data migration strategies from legacy systems to modern databases.
Assess data repositories for compliance with data governance policies and standards.
Create database queries using ANSI SQL or other programming languages.
Create reports/dashboards leveraging Power BI.
Analyze data from various systems and formats and audit databases regularly to maintain data quality.
Ensure data integrity and data standards within databases.
Provide enterprise data solutions and enhance reporting capabilities.
Maintain current databases and database objects.
Identify areas for improvement in the current process.
Recommend processes and create reports to continuously monitor data quality.