Overview Role: Data Analyst Client: DC Government Location: Washington, DC (Onsite) Responsibilities 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. 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 data inconsistencies in incoming data. The incumbent will make extensive use of structured query language (SQL). 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. Performs 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 conceives solutions to highly complex technical issues. Operates and maintains Business Intelligence systems and ancillary systems for serving up 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. Keeps abreast of current trends regarding all aspects of database management and stays informed about latest concepts, developments, approaches, and solutions to effective agency data management. Performs other related duties as assigned. Qualifications Minimum Education/Certification Requirements: Bachelor’s degree in IT or related field or equivalent experience Job Type: Full-time Experience Bachelor’s degree in IT or related field or equivalent: 5 years (Preferred) Knowledge of a wide range of IT standards and principles: 10 years (Preferred) Authorized system approaches for IT pertinent: 10 years (Preferred) Analytical methods and SQL code development: 10 years (Preferred) Working with relational database technologies: 10 years (Preferred) Creating metadata/data dictionaries: 10 years (Preferred) Creating database views for data feeds: 10 years (Preferred) Software development life cycle (SDLC): 10 years (Preferred) Data architecture in database schema design: 10 years (Preferred) BI systems operations and maintenance: 10 years (Preferred) Data analysis and SQL code development: 10 years (Preferred) #J-18808-Ljbffr Go Intellects Inc
...Reward and Recognition Program ~ Professional development ~401(k) retirement savings plan ~ Paid parental leave ~ Adoption Assistance ~ Flexible Schedule ~ Full and Part Time positions available Job Location Google Maps requires functional...
...The position offers comprehensive training, opportunities for remote work, and serves primarily the military community and their families... ...products. You will interact with our members across multiple contact channels (i.e. inbound phone calls, email, chat, social media,...
.... The core responsibilities of this role include: Safely operate a forklift and/or Tugger, perform material handler job duties to include... ...candidate will also possess the following skills and/or experience: -Applicants must be able to work a rotating night shift that...
...construction and service organization offering a complete range of door and door related products and commercial security products. The... ...Company, Inc. , is currently looking for Residential Door Installers to install garage doors. Job seekers with a background in...
...Job Description We're Hiring Compassionate Caregivers to Join our Growing Home Care Team! Flexible Scheduling, Competitive Pay, and a Fulfilling Career in Care! Make a meaningful difference in the lives of seniors by helping them live safely and comfortably at...