VDOT Cloud ETL Developer

We strive to attract and retain the brightest people and offer different job experiences with a full range of challenges and rewards.

We help companies realize and implement IT solutions strategically. Yakshna Solutions supports our client’s mission and goals by sharing our know-how, skills, and knowledge. We take pride in being an equal opportunity employer.

Working with Yakshna gives you the opportunity to develop your knowledge, skills, and abilities. Additionally, you can build a network of peers and mentors and advance your career! We offer exciting opportunities to work with leading industry experts, business consultants, and IT specialists across large government and private sector companies. The people who work in Yakshna are as diverse as our services.

We recognize the crucial importance of each individual to our success and offer competitive compensation, comprehensive benefits, and innovative training.

Yakshna Solutions, Inc ., (YSI) is a CMMI Level 3 assessed, ISO 9001, 20000:1, 27001 certified, woman-owned small business enterprise, headquartered in Herndon, Virginia, USA. YSI provides professional IT solutions and services to business corporations and government organizations.

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 Cloud ETL Developer to join our team. This position is hybrid, requiring the candidate to work 3 days per week onsite in Richmond, VA. Local candidates are preferred. Experience in data analytics to work as a key member of the Enterprise Data Asset team. This analyst will support teams working in Agile (Sprint) to analyze datasets to be made available in a cloud-based data management platform that will support the agency to produce master data with data governance.

Responsibilities include analyzing source systems which contain a spatial component for candidate datasets; documenting business processes and data lifecycle; developing data requirements, user stories, and acceptance criteria; and testing strategies. Develop ETL to extract business data and spatial data and load it into a data warehousing environment. Design and test the performance of the system. Consult with various teams to understand the company’s data storage needs and develop data warehousing options.

Deep knowledge of coding languages, such as Python, Java, XML, and SQL. Well-versed in warehousing architecture techniques such as MOLAP, ROLAP, ODS, DM, and EDW.

YSI is a fast-paced organization with very high standards for work quality and efficiency. This position is expected to handle multiple projects and remain flexible and productive, despite changing priorities and processes. Ongoing improvement and efficiency are a part of our culture, and each team member is expected to proactively contribute to process improvements.

Responsibilities:

• Work with the Project team members and business stakeholders to understand business processes and pain points.
• Develop expertise in source system datasets and data lifecycle.
• Profile source data which may contain a spatial component; review source data and compare content and structure to dataset requirements; identify conflicts and determine recommendations for resolution.
• Conduct entity resolution to identify matching and merging and semantic conflicts.
• Elicit, record, and manage metadata.
• Diagram current processes and proposed modifications using process flows, context diagrams, and data flow diagrams.
• Decompose requirements into Epics and Features and create clear and concise user stories that are easy to understand and implement by technical staff.
• Utilize progressive elaboration; map stories to data models and architectures to be used by internal staff to facilitate master data management.
• Identify and group related user stories into themes, document dependencies, and associated business processes.
• Discover and document requirements and user stories with a focus on improving both business and technical processing.
• Assist Product Owner in maintaining the…