Data Analyst Job at Stellent IT LLC, Washington DC

UG4xaCs1YUFLTjhTNlo5WGNJbEJsNTNsQmc9PQ==
  • Stellent IT LLC
  • Washington DC

Job Description

Role : Data Analyst

Location: the DC Metro area (Onsite)

Job Type : 1099 Contract

Interview: Expect IN-PERSON or VIRTUAL interview

SHORT DESCRIPTION:

16+ years of experience. The purpose of the position is to understand functional & technical requirements, analyse data, develop / deploy complex reports, & create project documentation related to data from the agency's applications.

COMPLETE JOB DESCRIPTION:

The master data analyst will be responsible for ensuring the accuracy, consistency, and integrity of data 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 problems requirements; project planning; coordination of multiple projects; identification of problems; and development of alert native solution.

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.

ADDITIONAL JOB REQUIREMENTS:

  1. Interfaces, independently, with high level stakeholders via meetings, emails, and phone calls to manage data projects. Gather and document requirements; and to gather sample data throughout all phases of the project to ensure data quality.
  1. 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.
  1. 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.
  2. 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.
  1. Creates scripts to identify and correct common errors and data inconsistencies in incoming data. The incumbent will make extensive use of structured query language (SQL).
  1. Troubleshoots problems involved in the input, retrieval or modification of database information and the general operation and maintenance pertinent to any of the enterprise data system elements or sub elements.
  1. Perform complex data analyses including experience validating data and identifying and correcting data inconsistencies and errors. Analyzes and defines requirements and specifications pertinent to OUC and OCTO enterprise systems and applications. Analyzes and plans for anticipated changes in data capacity requirements. Evaluates the impact of technological changes; and/or conceives of solutions to highly complex technical issues. Operate and maintain Business Intelligence systems and ancillary systems for serving up data analytics.
  1. Coordinates all activities with the project manager throughout the full software development life cycle (SDLC). to include design, development, and testing.
  1. Works with minimal oversight as a technical lead on data-driven reporting and applications development projects.
  1. Keep abreast of current trends regarding all aspects of database management. Keep information of latest concepts, developments, approaches, and solutions to effective agency data management.
  1. Performs other related duties as assigned.

MINIMUM EDUCATION/CERTIFICATION REQUIREMENTS:

Bachelor's degree in Information Technology, or related field or equivalent experience

CLIENT REQUIREMENTS

Item

Skills

Required or

Years of

Candidate's Years of Exp.

Desired

Experience

1

Bachelor's degree in IT or related field or equivalent experience

Required

2

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

Required

16

3

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

Required

16

4

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

Required

16

5

Extensive knowledge in working with relational database technologies .

Required

16

6

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

Required

10

7

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

8

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

Required

15

9

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

Required

15

10

Knowledge of BI systems operations and maintenance

Required

10

11

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

Required

10

12

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

Required

10

13

Skill in data analysis, and SQL code development .

Required

16

14

Accepts In-Person if requested

Required

Y/N

15

Accepts ONSITE work requirement

Required

Y/N

Email- [email protected] Phone Number : +1 321 7856 062

STELLENT IT A Nationally Recognized Minority Certified Enterprise

" Happiness can be found, even in the darkest of times, if one only remembers to turn on the light ."
- JK Rowling

Job Tags

Contract work,

Similar Jobs

The Momba Group

Scrum Master Job at The Momba Group

 ...Scrum Master (Contract Opportunity) Location: West Des Moines, IA Employment Type : 6-month Contract Hybrid About the Role...  ...applying Scrum/Agile methodologies across diverse projects. Certified Scrum Master (CSM) strongly preferred. Strong... 

Sweet P's Pre-K

Private School Teacher Job at Sweet P's Pre-K

Summary ALL Green Fields School is hiring! If you are idealistic, self-motivated, and passionate about making a meaningful difference; if teaching highly motivated, gifted students, in a small classroom setting appeals to you; and if being associated with a school...

ETS Dental

Associate General Dentist Job at ETS Dental

 ...Ready to take your dental career to the next level? We are hiring an Associate General Dentist to join a locally owned, private practice in Billings, MT. This is a full-time position! New Grads Welcome! Our ideal general dentist candidate will have a drive to help... 

Advanced Systems Design

Internet/Web Systems Administrator, Intermediate Job at Advanced Systems Design

 ...Our Employees: ~ Are actively working on next-generation technology projects with the U.S. Department of Veterans Affairs, CDC,and a wide array of Federal, State, and Local agencies throughout the United States ~ Are eligible for wide-ranging benefits and perks... 

EBSCO Information Services

Sr Sales Trainer, FOLIO Job at EBSCO Information Services

 ...perspectives will help us achieve this global, inclusive mission. Join us to help make an impact.**Your Opportunity**As the Senior Sales Trainer, FOLIO you are responsible for the creation and delivery of internal Sales training for FOLIO and FOLIO-related products and the...