DataArchitect / Modeler

Employer
Apex Systems, Inc.
Location
Washington, DC
Posted
Dec 01, 2021
Closes
Dec 04, 2021
Ref
238154680
Function
Accountant, IT
Hours
Full Time
Apex Systems is Hiring for a Direct Hire Top Secret Database Architect role located in DC (Partial Remote, 2 days) available. This is a small family owned company that's looking to hire quickly . If this interests you Please see details below! If interested, please send most up to date Word resume, target hourly rate, and the best time to speak to tcarter@ ! MUST HAVE: Must be eligible to obtain/maintain Top Secrete Clearance Bachelor's Degree & 10+ years of experience (5+ within Data Modeling) Must have experience with Data Warehousing/Data Modeling experience PostgresSQL/AWS experience is highly desired Description: Looking for an experienced Data Architect / Modeler for an effort on a Business Process Management project including the following opportunities: Develop enterprise data models to provide data for process development teams Model data structures for the transition of data from the live system to data warehouse Assist with transition from Oracle to PostgreSQL Assist with migration from on premises system to AWS hosted system across multiple security enclaves Candidate needs Oracle PL/SQL experience as well as extensive background in data modeling and data warehousing. Experience with a data modeling tool such as ERWin is a plus. Given our transition to PostgreSQL, experience with that tool is a plus. We would expect an understanding of star/snowflake schemas, indexing, aggregate tables, dimension tables, constraints, keys, and fact tables. Perform analysis of business requirements and develop logical and physical data models for data warehouse to support them. Develop the data warehouse, including the design and implementation of the logical and physical data model. Support the business by creating, adapting, and troubleshooting ETL jobs to populate the Data Warehouse. Drive the design and analyze discussions to determine the best database design to satisfy functional requirements for advancing the maturity of the organization's enterprise data warehouse capabilities. Responsibilities: Support new and existing development projects with data and process modeling activities. Provide entity, logical and physical data models Create and maintain custom and vendor provided data technical dictionaries for all business systems Communicates project status, issues, and resolutions with appropriate Lead and/or Managers Work with data suppliers to establish input and interface specifications Perform database and data warehouse design across multiple platforms Codes, tests, and supports existing and new systems and applications Perform data analysis for source system data Conducts thorough unit testing Writes design specifications for solutions as identified by Analyst, Lead and/or management Design time variant models that support both point in time historical and current state analysis Conducts data requirements assessment and design sessions with customers Works with analysts to establish clearly defined business requirements Estimates level of effort for work assignments and requests received, then communicate accordingly to the Project Manager to determine delivery time Participate in data governance processes related to data quality and information management Requirements: Strong analytical, problem solving, and work management skills Proficiency with some leading data profiling tools (such as SQL, BI tools, etc) Participate in data governance processes related to data quality and information management Strong SQL skills to pull data from Oracle/PostgreSQL and perform usage analysis and/or data profiling Experience with JSON data type and transformations in Oracle Conducts thorough unit testing Writes design specifications for solutions as identified by Analyst, Lead and/or management Bachelor's Degree in Computer Science, Computer Engineering, or a closely related field Support new and existing development projects with data and process modeling activities Provide entity, logical and physical data models Exposure and understanding of Big Data technologies and architectures Ability to work collaboratively in teams and develop meaningful relationships to achieve common goals Perform database and data warehouse design across multiple platforms Codes, tests, and supports existing and new systems and applications EEO EmployerApex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at employeeservices@ or 844-463-6178.VEVRAA Federal ContractorWe request Priority Protected Veteran & Disabled Referrals for all of our locations within the state.We are an equal opportunity employer. We evaluate qualified applicants without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status, or any other protected characteristic. The EEO is the Law poster is available here.PDN-94d8c4cd-e315-49fa-adbf-f9103724b99c

Similar jobs