Join our talent network

Job #: R-00011290
Location: King Of Prussia, PA
Category: Database Management
Schedule (FT/PT): Full time
Travel Required: No
Shift: Day
Potential for Telework: Yes
Clearance Required: None
Referral Eligibility: Eligible
Group: Corporate

Job Description:

Leidos Corporate is seeking a Data Modeler to join our Enterprise Information Management (EIM) team. This position can be supported from one of the following locations: King of Prussia - PA or Orlando - FL. We will also consider telecommute for the right candidate.

In this role, you will be responsible for:
  • The capture of business requirements and rules.
  • Design associated logical models, and create all required documentation to support, communicate, and validate the data model.
  • Manage the conversion of the logical models to physical models.
  • Design and develop replication mappings.


PRIMARY RESPONSIBILITIES:
  • Analyze logical and physical data models to support the business requirements in a dynamic, expanding business environment.
  • Map data elements of data sources into the domain data models.
  • Maintain documentation of data models and data flows, including relationships, constraints and metadata.
  • Publish and conduct model reviews with business and technical project teams.
  • Develop scripts to build database objects and roles, including stored procedure, views, tables, privileges, etc.
  • Coordinate with development/implementation team to improve model formats and approaches with regard to implementation issues.
  • Manage the replication and Change Data Capture process for source databases to targets.


REQUIRED QUALIFICATIONS:
  • Bachelor's degree and 8+ years of relevant experience. Additional years of relevant experience will be considered in lieu of Bachelor's degree.
  • Strong experience in Oracle SQL and PL/SQL development environment using SQL Developer, TOAD, and other tools.
  • Strong analytical skills, able to translate business requirements and translate them into complex database models and execute them to completion.
  • Knowledge of ER/Dimensional modeling and have extensive experience in developing logical and physical data models in complex, multi-application environments.
  • Hands-on experience in data management, data warehousing, data transformation, metadata and reference data management.
  • Experience with a data modeling tool supporting an enterprise environment.
  • Able to support production promotions and/or issues after hours or weekends.
  • US Citizenship is required and able to obtain security clearance.


DESIRED QUALIFICATIONS:
  • Experience with Oracle Golden Gate replication or a similar tool
  • Experience with Idera ER Studio or a similar modeling tool
  • Experience with tuning in Oracle
  • Knowledge of VPD security
  • Understanding of big data solutions, including commercial cloud solutions is a plus.
  • Knowledge of deployment architectures, e.g. distributed, cloud, transaction, warehouse.
  • Experience with one or more BI tools such as Oracle OBI, Tableau, PowerBI, etc.


Leidos is a Fortune 500® information technology, engineering, and science solutions and services leader working to solve the world's toughest challenges in the defense, intelligence, homeland security, civil, and health markets. The company's 32,000 employees support vital missions for government and commercial customers. Headquartered in Reston, Virginia, Leidos reported annual revenues of approximately $10.19 billion for the fiscal year ended December 28, 2018. For more information, visit www.Leidos.com .

Pay and benefits are fundamental to any career decision. That's why we craft compensation packages that reflect the importance of the work we do for our customers. Employment benefits include competitive compensation, Health and Wellness programs, Income Protection, Paid Leave and Retirement. More details are available here .

Leidos will never ask you to provide payment-related information at any part of the employment application process. And Leidos will communicate with you only through emails that are sent from a Leidos.com email address. If you receive an email purporting to be from Leidos that asks for payment-related information or any other personal information, please report the email to spam.leidos@leidos.com .

All qualified applicants will receive consideration for employment without regard to sex, race, ethnicity, age, national origin, citizenship, religion, physical or mental disability, medical condition, genetic information, pregnancy, family structure, marital status, ancestry, domestic partner status, sexual orientation, gender identity or expression, veteran or military status, or any other basis prohibited by law. Leidos will also consider for employment qualified applicants with criminal histories consistent with relevant laws.

Talent Community

Join our Talent Community to create a profile, enabling a streamlined application process and to help our recruiters better understand your areas of expertise and interest.

Join our Talent Community