Enterprise Data Warehouse Analyst
Enterprise Data Warehouse Analyst
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
Title: Enterprise Data Warehouse Analyst
State Role Title: Info Technology Specialist II
Hiring Range: $80896 $92692
Pay Band: 5
Agency: Dept of Med Assistance Svcs
Location:Dept of Medical Asst Services
Agency Website:
Recruitment Type: General Public G
Job Duties
The Department of Medical Assistance Services (DMAS) is excited to offer a competitive opportunity to serve as an Enterprise Data Warehouse Analyst. The selected competitive candidate will provide exceptional delivery of services to the agencys Health Analytics Division.
Job responsibilities will include but are not limited to:
The position will be responsible for planning and executing the analytics roadmap for DMAS analyze client applications propose data quality
data integration and transformational rules. This position will evaluate load processes into the Data Warehouse address data migration issues sustain integrity of extract by identifying and resolving production issues and answer user questions. The incumbent will be analyzing existing database schema/instance and determine impacts migrating to new target schema/instance environment provide user education and training. The candidate will have an endtoend vision on how a logical design may be translated into a physical database and how the data will flow from source to destination communicate verbally and in writing to translate technology to simplified businessoriented conversations. The incumbent will be required to create metrics and specialized complex reports to support DMAS mission. The position will also be responsible for managing metadata monitoring data quality and data profiling.
As an employee of DMAS you are entitled to the many comprehensive benefits the Commonwealth has to offer. This includes health benefits 12 paid holidays paid leave flexible work schedules & retirement plans. For more specific details please visit: in beautiful Central Virginia the Richmond area puts you just 2 hours from the Blue Ridge Mountains Virginia Beach and Washington DC. To learn more about the Richmond VA area visit: Department of Medical Assistance Services (DMAS) is working to improve the health and wellbeing of Virginians through access to high quality health care coverage.
DMAS wants talented individuals who can align their experience with the mission of the agency and its core values service collaboration trust problem solving and adaptability.
At the Department of Medical Assistance Services (DMAS) we encourage and promote that you Come as you are Become who you want to be That is our promise.
Minimum Qualifications
Competitive candidates will meet these minimum qualifications:
Knowledge/Experience in implementing evaluating researching analyzing extracting transformation and cleaning of data.
Considerable WorkRelated Experience with one or more databases like Oracle SQL server DB2 Teradata MySQL etc.
Considerable WorkRelated Experience writing SQL scripts.
Knowledge/experience with one or more BI or analytical tool(s) like SAS R STATA Tableau Business Objects Cognos Qlickview etc.
Knowledge/experience working with Enterprise Data Warehouse.
Knowledge/Experience interpretation and application of federal state laws/regulations.
Experience in meeting deadlines.
Experience with internal/external stakeholders.
Additional Considerations
Competitive candidates will meet these Additional Considerations:
Knowledge/Experience with data modeling data schema ER diagram snowflake schema etc.
Knowledge/Experience with healthcare preferably Medicaid Medicare etc.
Knowledge/Experience writing BTEQ scripts and/or UNIX scripts.
Knowledge/Experience working with ETL tools such as Informatica Ab initio Datastage Oracle Data Integrator (ODI) etc.
Knowledge/experience in data warehouse design data structure and data organization.
Special Instructions
You will be provided a confirmation of receipt when your application and/or rsum is submitted successfully. Please refer to Your Application in your account to check the status of your application for this position.
The Virginia Department of Medical Assistance Services (DMAS) does not offer employmentbased Sponsorship. Selected candidates will have their work authorization completed using the EVerify Program.
The Department of Medical Assistance Services (DMAS) is an Executive Branch agency that will adhere to all policies and procedures to include the Commonwealths Department of Human Resource Management Policy 1.61 Teleworking.
This position requires a fingerprint based Criminal History Background Check Education Checks if applicable Work History Verification with references.
If you wish to apply for a job with the Department of Medical Assistance Services an application and/or resume for employment must be submitted electronically through this website. Mailed faxed emailed or handdelivered applications/resumes will not be accepted. Consideration for an interview is based solely on the relevant information presented in the state application and/or resume submitted before the closing date.
Applications and/or resumes should include relevant work history which indicates your qualifications for this position.
The Department of Medical Assistance Services practices fair and equal employment opportunity to all employees and applicants in accordance with applicable laws and regulations. It is our policy to prohibit discrimination on the basis of race sex color national origin religion sexual orientation gender identity age veteran status political affiliation genetics or disability in the recruitment selection and hiring of its workforce.
In support of the Commonwealths commitment to inclusion we are encouraging individuals with disabilities to apply through the Commonwealths Alternative Hiring Process. To be considered for this opportunity applicants will need to provide their AHP Letter (formerly called a Certificate of Disability) provided by the Department for Aging & Rehabilitative Services (DARS) or the Department for the Blind & Vision Impaired (DBVI). ServiceConnected Veterans may also apply via the AHP if they also provide an AHP Letter. To request an AHP Letter use this link: or call DARS ator DBVI at
The Department of Medical Assistance Services is a V3 certified state agency that provides hiring preference to veterans and members of the reserves and/or National Guard in support of executive order 29 (2010). If you are a Veteran or Spouse of a Veteran or Active Military Member DMAS encourages you to apply and respond accordingly on your state application.
Contact Information
Name: DMAS Talent Acquisition
Phone:
Email:
In support of the Commonwealths commitment to inclusion we are encouraging individuals with disabilities to apply through the Commonwealth Alternative Hiring Process. To be considered for this opportunity applicants will need to provide their AHP Letter (formerly COD) provided by the Department for Aging & Rehabilitative Services (DARS) or the Department for the Blind & Vision Impaired (DBVI). ServiceConnected Veterans are encouraged to answer Veteran status questions and submit their disability documentation if applicable to DARS/DBVI to get their AHP Letter. Requesting an AHP Letter can be found at AHP Letter or by calling DARS at.
Note: Applicants who received a Certificate of Disability from DARS or DBVI dated between April 1 2022 February 29 2024 can still use that COD as applicable documentation for the Alternative Hiring Process.
Required Experience:
IC
Employment Type
Full-Time
