Job details
Salary $84,255 a year job type full-time
Full job description
The data warehouse team within the office of research and planning is seeking a data warehouse developer.
This position is a database analyst and etl developer on the data warehouse team responsible for delivery of backroom data processing services and loading presentation layer data stores for data engineering excellence.
Job duties include but are not limited to:
Identify and fulfill business needs for enterprise data by building the vdss data warehouse (dw).
Conduct source data discovery and analysis, document business rules for source data extracts, ensure other metadata is captured, and build and implement what is needed.
Perform dw etl system planning, design, development/testing, and publishing tasks.
Assist customer business units to develop source data definitions, business rules to be applied using the data, sor data extract requirements, and extract job functional specifications.
Analyze sor data to confirm business rules and assist in the definition of sor extract data models.
Participate in testing of sor data extracts.
Assist in the definition of staging area and dw target data models.
Etl job development – requirements, design and review, code & unit test, qa testing, uat, and sat support.
Assist in the definition of bi reporting data models and develop supporting database views.
Develop sor extract and dw target metadata and document in the enterprise data catalog.
Etl job production support.
Supports development of data, metadata, and technical architecture design, performance monitoring, systems analysis, quality assurance, and integration methodologiesResponsible for design, coding, testing, debugging, and maintaining complex computer programs— especially for data warehouse etl and business system applicationsAssists with dw project management providing analysis and research on technical or other problems; communicating problems & project risks; scheduling/coordination of project development, and activities of assigned projectsDesigns technical etl specifications for assigned projects and ensures proper usage of standards and processes as part of the design efforts in building a system to be put into productionUses database sql programming, unix shell scripting, and etl code-generation tools along with the ability to develop business requirements and the technical design to produce an etl application to be run in productionPrepares system documents and constructs code to deliver quality, cost-effective, and timely deliverables according to the department’s lifecycle development approach (sdlm)This includes:
Clarifying requests for enhancements or systems changes with system and business analysts.
Analyzing user requirements, documents, and requests to develop effective automated solutions.
Maintaining production code and programs and supporting test plans.
Position may also support 24 × 7 operations, making necessary decisions independently
Minimum qualifications
Significant expertise with gathering requirements, data analysis, design, development, testing, and implementation of major applications in business systems, data warehousing, and business intelligence environments.
Skilled in data warehouse etl development and design with expertise in code-generation tools, job monitoring, and job automation preferably in a linux environment.
Skilled in database analysis, experience with data modeling, and database table design.
Skilled in sql programming with expertise in oracle or other enterprise database and application development tools.
Strong technical and business writing skills.
Support project planning and management for software development.
Preferred qualifications
Bi reporting requirements, data analysis, sql code design, and development experience.
Investigate & resolve all etl data issues and tune system for poor performance.
Expertise with automated data profiling tools such as experian pandora.
Certification as oracle database administrator or equivalent experience.
Certification as certified business intelligence professional.
Design, development, and testing of large automated systems specifically in the health and human services field.
Fluent with microsoft productivity tools including word, excel, visio, and project professional.
Special requirements in accordance with executive directive #18 (2021), the successful candidate will be required to disclose their covid -19 vaccination status upon hire prior to onboardingIn addition, employees who are not fully vaccinated will be subject to masking and weekly covid -19 testing as required in the executive directive.
Selected candidate(s) must successfully pass a fingerprint-based criminal history background check.
Selected candidate(s) will be assigned to an emergency role upon hire and is expected to perform in that capacity as needed.
Telework is a condition of employment for this positionThe employee may be required to work a schedule that is split between remote and onsite (shared workspace) locations.
Special instructions to applicants to be considered for this position, you must submit a commonwealth of virginia application or resume through the on-line “virginia jobs” (rms) employment site no later than 11:59 p.mOn the closing date listedEach application is reviewed for documentation that shows the applicant meets the minimum and preferred qualifications stated in the job announcementThe decision to interview an applicant is based on the information providedThis website will provide a confirmation of receipt when the application is submitted for considerationPlease refer to your rms account for the status of your application and this positionVdss values the service and experience of our veteransAs such, veterans are encouraged to apply and receive preference in the hiring processAmericorps, peace corps and other national service alumni also are encouraged to applyReasonable accommodations are available to applicants, if requested, during the application and/or interview process[tty/ttd: (800) 828-1120 ]
Virginia department of social services does not provide sponsorshipThe virginia department of social services is an equal opportunity employer and encourages diversity within its workforce.
We are a “virginia values veterans” (v3) official certified company and state agency that provides hiring preference to veterans and members of the virginia national guard in support of executive order 29, (2010)If you are a veteran or virginia national guard member, we urge you to respond accordingly on your state application or resumeMinorities, individuals with disabilities, veterans and people with national service experience are encouraged to apply.
For more information about our employment practices, please visit our “vision, mission and strategic plan”Multiple positions may be filled from this recruitment within 90 days of the closing dateIn addition to a rewarding work experience, vdss offers excellent health and life insurance benefits, pre- tax spending accounts, state funded short and long term disability, paid holidays, vacation, tuition assistance, free wellness programs, and a state retirement plan with options for tax-deferred retirement savings including employer matching – employee benefits.
If you have been affected by policy 1.30 layoff as a state employee and possess a valid interagency placement screening form (yellow form) or a preferential hiring card (blue card), you must submit this document through the “virginia jobs” (rms) employment site when you apply.
Name vdss – office of research and planning
Phone 804-726-7057
Fax 804-819-7019 (applications/resumes or any other supporting documents are not accepted)
Email dssrecruitment@dss.virginia.gov
Address 801 eMain street
Richmond, va 23219
