What are the responsibilities and job description for the Data Modeler, Mid-Level position at ACS?
Location: Chantilly, VA (position may also be performed in Springfield, VA)
Clearance Required: Must be a U.S. Citizen and possess a current and active TS/SCI clearance granted by the Department of Defense or an Intelligence Community agency. Must be able to pass a Counterintelligence (CI) Polygraph.
Background:
Assured Consulting Solutions provides strategic and innovative solutions for customer needs across the business, technology, and organizational spectrum. As a member of our team, you will have the chance to work with customers that are both Government and industry leaders and technology innovators.
We are seeking a highly motivated Mid level Data Modeler. The Data Modeler works with data architects and metadata managers to model enterprise data, translating agency needs into long-term physical models and database designs in order to empower production systems
Responsibilities include, but are not limited to:
- Identify and describe relationships between data fields and how they are maintained in enterprise databases
- Responsible for progressing and maintaining official description of enterprise datasets
- Organize the integration of data and migration activities to enhance operating efficiency
- Performs gap analysis of legacy application data structures and enterprise data warehouse
- Performs analysis on enterprise data holdings to reduce redundancy of data within existing systems or improve the way to conflate datasets from one system to another
- Analyze ETL processing to identify risk factors and make necessary recommendations to ensure data integrity in the data warehouse
- Applies naming standards, and metadata standards, checks models in and out of Model Repository, and documents data model translation decisions
- Participates in team discussions with other data modelers and data SMEs across the enterprise
- Create new ontologies to improve problem solving within that domain
Required Qualifications:
- Bachelor’s degree in Computer Science, Information Systems, or specialized experience in a scientific or technical discipline, or equivalent Mid level experience as Data Modeler.
- Demonstrated experience with ontology that encompasses a representation, formal naming and definition of the categories, properties and relations between the concepts, data and entities that substantiate one, many, or all domains of discourse
- Experience in data modeling principles/methods including conceptual, logical & physical data models
Desired Qualifications:
- Experience with Collibra, Informatica or related data governance tools
- GEOINT domain experience, in particular GEOINT TCPED cycle
- Working experience with GEOINT TCPED metadata
- Experience working with dimensionally modeled data
- Experience in translating/mapping relational data models into XML and Schema
Education Qualifications:
- Bachelor’s degree in Computer Science, Information Systems, or specialized experience in a scientific or technical discipline, or equivalent Mid level experience as Data Modeler.
Years of Experience:
- 10-16 years w/ HS Diploma
- 6-12 years w/ Bachelor's degree
- 4-10 years w/ Masters degree
Position Type: Full-Time
Shift: Day
COVID-19 VACCINATION REQUIREMENT. All ACS employees must be fully vaccinated against COVID-19 by their first day of employment or January 18, 2022, whichever is later. Exceptions to the vaccine mandate will be considered only where legally required. To discuss an exemption for medical reasons or due to a sincerely held religious belief, please contact ACS Human Resources at (703) 662-5062.
Assured Consulting Solutions is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, or protected veteran status and will not be discriminated against on the basis of disability. If you are an individual with a disability and would like to request a reasonable accommodation as part of the employment selection process, please contact ACS Human Resources at (703) 662-5062