Senior Data Analyst - ABBTECH Professional Resources

This program requires US Citizenship or Green Card (Lawful Permanent Residents)

Position Description: The purpose of the position is to understand functional & technical requirements, analyze data, develop/deploy complex reports, and create project documentation related to data from the agency’s applications.

The master data analyst will ensure data accuracy, consistency, and integrity across various systems within the organization. This role involves conducting thorough data analysis to identify trends and discrepancies and collaborating with cross-functional teams to address data needs and enhance data management practices.

The ideal candidate will possess strong analytical skills, proficiency in data management tools, and the ability to communicate effectively with stakeholders, driving continuous improvement in data quality and governance.

The work includes:

• Development and maintenance of consulting relationships with multiple agencies that have unique systems, data, programs, business, and problem requirements
• Project planning and coordination of various projects
• Identification of problems and development of alert native solutions
• The complexity of the work is often compounded by the need to respond to agency business problems rapidly in response to Federal or District regulations
• Decisions regarding what needs to be done include largely undefined issues and elements and require extensive probing and analysis to determine the nature and scope of the problems
• The work requires continuing efforts to resolve unyielding problems

Position Responsibilities:

• Interfaces independently with high-level stakeholders via meetings, emails, and phone calls to manage data projects. Gather and document requirements and gather sample data throughout all phases of the project to ensure data quality.
• Works with District agency resources to analyze, compile, verify, and query data as part of data warehousing services. Develops complex SQL queries used by reporting environments and data-driven dashboard applications. Creates metadata and data dictionaries.
• Designs and documents methods to facilitate the implementation of new database systems. Designs and implements reports using SQL as well as a variety of reporting and business intelligence tools.
• Develops and administers data standards, policies, and procedures; and develops new standards, methods, and techniques. Develops common approaches to problem-solving and meeting processing requirements. Develops and analyzes new projects.
• Creates scripts to identify and correct common errors and inconsistencies in incoming data. The incumbent will make extensive use of structured query language (SQL).
• Troubleshoot problems related to the input, retrieval, or modification of database information and the general operation and maintenance of any enterprise data system elements or sub-elements.
• Perform complex data analyses, including experience validating data and identifying and correcting inconsistencies and errors. Analyzes and defines requirements and specifications for OUC and OCTO enterprise systems and applications. Analyzes and plans for anticipated changes in data capacity requirements. Evaluate the impact of technological changes and/or conceive solutions to highly complex technical issues. Operate and maintain Business Intelligence and ancillary systems for data analytics.
• Coordinates all activities with the project manager throughout the full software development life cycle (SDLC), including design, development, and testing.
• Works with minimal oversight as a technical lead on data-driven reporting and applications development projects.
• Stay abreast of current trends regarding all aspects of database management. Stay informed about the latest concepts, developments, approaches, and solutions to effective agency data management.

Minimum Education/Certification Requirements: Bachelor’s degree in IT or related field or equivalent experience

Skills Matrix: | Skill | Required /Desired | Yrs of Experience

Bachelor’s degree in IT or related field or equivalent experience | Required

Extensive knowledge of a wide range of IT standards, principles, concepts, methods, policies, system testing principles and methods | Required | 16

Extensive knowledge of authorized system approaches for IT pertinent to databases management. | Required | 16

Extensive knowledge of and skill in applying analytical methods and practices, and requirement analysis principles and methods. | Required | 16

Extensive knowledge in working with relational database technologies. | Required | 16

Extensive knowledge in creating metadata/data dictionaries; designing and implementing reports | Required | 10

Extensive knowledge creating database views used for the purposes of establishing live data feeds as well as the development of data-driven dashboard | Required | 10

Extensive knowledge of software development life cycle (SDLC), as well as, managing small IT projects with minimal oversight. | Required | 15

Extensive knowledge of data warehousing concepts; and extensive knowledge in working with data architects in the design of database schemas. | Required | 15

Knowledge of BI systems operations and maintenance | Required | 10

Expert knowledge of and skill in applying oral and written communication techniques; and in evaluating and reporting on accomplishments. | Required | 10

Demonstrated ability to speak and write clearly and effectively when dealing with various technical and non-technical audiences. | Required | 10

Skill in data analysis, and SQL code development. | Required | 16

Position Details:

• Pay Range: $35-$47.50

The above salary range represents the range expected for the position; however, final salary offers are based on a number of factors such as the position’s responsibilities; the candidate’s experience, education, and skills; location; travel required; and current market conditions.

• Benefits (Regular, Full Time Employees):
• Medical, Dental, and Vision offerings
• Weekly Direct Deposit
• Paid Holidays and Personal Time Off
• 401(k) with match
• Voluntary Life and AD&D, Short / Long Term Disability, plus other voluntary coverages
• Pre-Paid Legal and Employee Assistance Programs
• Northwest Federal Credit Union Membership
• BB&T @ Work Program

ABBTECH is an EOE/Minorities/Women/Disabled Individuals/Veterans