Salary: $52,331.12 – $80,000.00 Annually
Location : Atlanta, GA
Job Type: Full-Time Salaried
Remote Employment: Flexible/Hybrid
Job Number: 2022-03267
Division: Office of Analytics and Program Improvement (OAPI)
Opening Date: 08/09/2023
Closing Date: 8/23/2023 11:59 PM Eastern
Description
Pay Grade: O
The Georgia Department of Community Health (DCH) is one of Georgia’s four health agencies serving the state’s growing population of over 10 million people. DCH serves as the lead agency for Medicaid, oversees the State Health Benefit Plan (SHBP) and Healthcare Facility Regulation, impacting one in four Georgians.
Through effective planning, purchasing and oversight, DCH provides access to affordable, quality health care to millions of Georgians, including some of the state’s most vulnerable and under-served populations. Six enterprise offices support the work of the agency’s three program divisions. DCH employees are based in Atlanta, Cordele and across the state.
DCH is committed to providing superior Customer Service and Communication, embracing Teamwork and fostering Accountability to ensure that our internal and external customers and stakeholders feel included, respected, engaged and secure.
The Georgia Department of Community Health (DCH) is in the process of replacing its legacy data warehouse / decision support system (DW/DSS) with a modern cloud-based enterprise data warehouse and analytics solution to serve the entire department as part of its Enterprise Analytics Solution for Everyone (EASE) project. DCH is seeking 2 qualified candidate to serve full-time, as a Senior Modeler/Architect for the EASE project.
Job Responsibilities
The Senior Modeler/Architect will be responsible for designing and developing conceptual, logical and physical data models and implementing these models in Snowflake using WhereScape Data warehouse automation. This role will also develop, implement, and automate testing scrips using Validatar. The Senior Architect will also work closely with other EASE developers, testers, and analysts.
The Senior Modeler/Architect will report to and receive strategic guidance from the OAPI Solutions Manager.
Roles and Responsibilities
The ideal candidate will design and develop the data models and data warehouse including the loading of data, Data vault and information marts. The ideal candidate will also be responsible for implementing and maintaining the architecture for the EASE solution. The Senior architect will, at minimum, perform the following:
- Design and develop conceptual, logical, and physical data models for the cloud data warehouse
- Work with business stakeholders to understand reporting requirements and develop data models to support those requirements
- Create database scripts and powerscripts including data definition language, database schemas, and roles, for all layers of the cloud data warehouse
- Work individually and with other developers on extract, load and transform logic
- Applies and adapts data architecture principles, standards, concepts, practices and techniques as appropriate to specific use cases
- Performs Data vault2 modeling and associated tasks
- Designs and implements Validatar tests to ensure the integrity and quality of the data warehouse
- Writes and deploys codes to all data warehouse environments
- Create views to support business user requirements
- Designs and implements role based security throughout the data warehouse
Minimum Qualifications
Bachelor’s degree in computer science, information systems or related specialty from an accredited college or university AND Ten years of job specific experience that includes system analysis, design and development, and relationship management.
Preferred Qualifications (Preference will be given to candidates who, in addition to meeting the qualifications listed above, demonstrate some or all of the following skills/experience):
- BA or BS in Business Information Systems, Information Technology, Computer Science or related field.
- 2 years in related supervisory position
- At least 5 years of Data warehouse architect experience
- Cloud Architecture skills
- 3 years of Sql experience
- 2 years of WhereScape RED and 3D experience
- 1 year of Snowflake experience
- Extremely strong analytical, critical thinking and problem-solving skills
- Excellent speaking and writing skills
- Attention to detail
- High personal and professional integrity
- Collaborate well with a team
- Manages time well
Position may be filled at lower level, depending on experience and qualifications.
Current Georgia state government employees will be subject to SPB rule provisions.
Additional Information
EARN MORE THAN A SALARY! In addition to a competitive salary, the Georgia Department of Community Health offers a generous benefits package, which includes employee retirement plan; paid holidays annually; vacation and sick leave; health, dental, vision, legal, disability, accidental death and dismemberment, health and child care spending account.
Due to the volume of applications received, we are unable to provide information on application status by phone or e-mail. All qualified applicants will be considered, but may not necessarily receive an interview. Selected applicants will be contacted by the hiring agency for next steps in the selection process. Applicants who are not selected will not receive notification.
THIS POSITION IS SUBJECT TO CLOSE AT ANY TIME ONCE A SATISFACTORY APPLICANT POOL HAS BEEN IDENTIFIED. APPLICATIONS WITHOUT WORK EXPERIENCE LISTED WILL NOT BE CONSIDERED. CURRENT GEORGIA STATE GOVERNMENT EMPLOYEES WILL BE SUBJECT TO STATE PERSONNEL BOARD (SPB) RULE PROVISIONS. THE POSITION MAY BE FILLED AT A LOWER OR HIGHER POSITION LEVEL.
This position is unclassified and employment is at-will. Candidates for this position are subject to
a background history, reference check, and credit check. For more information about this job
contact: :
In addition to a competitive salary, we offer a generous benefits package that includes a flexible schedule, training opportunities, employee retirement plan, deferred compensation, 13 paid holidays, vacation & sick leave, dental, vision, long term care, and life insurance.
01
The answers you provide to the supplemental questions will be used to determine if you meet the minimum qualifications for this position. Your responses pertaining to specific work experience and education must be clearly shown in the areas for work history and education on your application. Your application must be completed in full before it is submitted. We do not accept additional information after your application has been received by the Personnel Department. Do you accept these conditions?
- Yes
- No
02
Are you a veteran?
- Yes
- No
03
Are you a current employee of the Georgia Department of Community Health?
- No
- Full Time Employee
- Part Time Employee
- Temp or Contractor
- Intern
- Volunteer
04
Please select which of the following best describes your education.
- Juris Doctorate
- Master’s Degree
- Bachelor’s Degree
- Associate’s Degree
- High School Diploma
05
How many years of experience do you have as a supervisor?
- None
- Less than 3 yrs
- 3 yrs to 5 yrs
- 5 yrs to less than 7 yrs
- 7 yrs to less than 10 yrs
- 10 yrs or more
06
How many years of experience do you have in data modeling?
- None
- Less than 1 year
- 1 year
- 2 years
- 3 years
- 4 years
- 5 years or more
07
How many years of experience do you have working with reporting systems and performing complex statistical analysis with extremely large data sets across different systems?
- Less than 2yrs
- 2yrs to less than 3yrs
- 3yrs to less than 5yrs
- 5yrs to less than 6yrs
- 6 years or more
- None of the above
08
How many years of experience do you have as a Data architect?
- NONE
- 0-6 YEARS
- 6-10 years
- 10 years or more
Required Question