Yakshna Solutions

DPOR - Data Warehouse/BI Developer - Herndon

Herndon, VA
Yakshna Solutions, Inc. (YSI) is a minority and women owned SBA 8(a), CMMI Level-2 Certified IT Serv

Job Description

DPOR - Data Warehouse/BI Developer

Posted: Wednesday, 8/30/2023

Yakshna Solutions, Inc., (YSI) is a CMMI Level 3 assessed, ISO 9001, 20000:1, 27001 certified, woman-owned small business enterprises, headquartered in Herndon, Virginia, USA. YSI provides professional IT solutions and services to business corporations and government organizations. YSI is committed to serve its business communities as a leading IT vendor providing innovative, quality, and cost-effective IT business solutions and services.

We offer a competitive benefits package that includes the following: 401(k), health, dental, and vision insurance, Life insurance, short-term and long-term disability insurance, paid time off, training, and professional development assistance.

YSI is seeking a highly qualified DPOR - Data Warehouse/BI Developer. The selected candidate will be able to communicate effectively (written/verbal), possess strong interpersonal skills, be self-motivated, and be innovative in a fast-paced environment.

Job Responsibilities:
  • Local Richmond, VA candidates needed due to onsite requirement
  • Onsite interviews, NO exceptions


  • The effort will be a mix of onsite and remote work; initial onboarding is ONSITE and schedule will be set accordingly afterwards.
  • IN PERSON Interviews required so must be local or willing to come to the facility and interview IN PERSON (no exceptions)
  • A major part of this project will be to convert data from DPOR's existing systems to its new system.

Responsibilities:

  • Position is initially onsite and will be hybrid at a later date after onboarding/training.
  • Analyze existing systems including screens and available documentation (e.g., data models or data dictionaries) to understand how the underlying data is organized, interrelated, and stored in various databases as well as identify where there may be data anomalies / inconsistencies
  • Interact with and ask pertinent questions of system users to understand the organization and relationship of data in the systems and map data from source systems to target templates/systems
  • Create clear, concise and complete documentation (e.g., data models, data dictionaries) regarding the organization and use of data in existing systems
  • Accurately map data from source systems to target templates/systems and resolve issues stemming from the mapping efforts
  • Working knowledge in Oracle (predominantly) and SQL Server creating complex queries, views, functions, and stored procedures that leverages knowledge gained from analyzing systems and underlying data organization to extract / transform data into a vendor defined (TBD) format
  • Experience developing and testing data extraction and transformation routines (5 Years)
  • Able to write complex SQL (joins, functions, stored procedures) to extract data and transform data from both Oracle and SQL Server databases (5 Years)
  • Able to analyze existing systems to understand how underlying data is stored and inter-related (5 Years)
  • Able to create, clear, concise and complete documentation related to the organization and use of data in existing system (3 Years)
  • Able to accurately map data from source systems to target templates/systems and resolve issues stemming from the mapping efforts
  • Experience developing and testing data extraction and transformation routines (5 Years)
Requirements
  • Able to perform data analysis and put together meaningful reports / dashboards using an agencies existing data (2 Years)
  • Strong working experience with Microsoft Power BI (2 Years)

Yakshna Solutions At A Glance

Yakshna Solutions, Inc. (YSI) is a minority and women owned SBA 8(a), CMMI Level-2 Certified IT Services firm providing business and technology services for corporate, government, and non-profit institutions. YSI leverages an advanced team of global professionals, cutting edge IT toolkits, and extensive business operations, experience to accelerate projects and organizational impact while optimizing administration costs and related activity. Our corporate mission is to deliver a comprehensive commitment to customer service combined with deep expertise to deliver a full range of business and technology solutions to provide real-time results for today’s organizational challenges.
Apply Now

Classet is a skilled trades network. Once you have applied, A Classet recruiter will reach out within 24 hours to learn more about your career search! Classet helps everyone from experienced crafstmen & women to eager apprentices find new opportunities. We are here to help you find the right fit for your career.