Sr. Data Modeler/Lead
At a glance
Senior Data Architecture & Governance role at USM. Reston · contract.
Pay not stated Data Architecture & Governance salary
dataroles summary, based on the employer's posting.
What you'll do
- Turn business requirements into conceptual, logical and physical models for EDF ODS and EDF ODR
- Shape models with data architects, then align database naming and performance standards with DBAs
- Map product changes into data structures and share data standards with technology and product teams
- Design schemas with developers, add referential integrity, and examine existing databases to understand their contents
- Create physical DDL for deployment and standardize database object names and domains
What you bring
- A related technical bachelor’s degree and at least twelve years modeling large-scale data structures
- At least ten years using Erwin or ER Studio, plus ten years in data architecture and database design patterns
- At least ten years mapping ETL data and producing physical DDL for database deployment
- You can reverse engineer databases and build both transactional and dimensional models
- You understand UNIX, DB2, SQL and data quality
Who this fits
This senior, twelve-month contractor role suits an experienced data modeler who can work across business, architecture, database and product teams. You must be local to Reston or nearby, and the position is onsite. GC and citizens only.
From the employer
USM Business Systems Inc. is a quickly developing worldwide System Integrator, Software and Product Development, IT Outsourcing and Technology assistance supplier headquartered in Chantilly, VA with off-shore delivery centers in India. We offer world-class ability in giving most astounding quality and administrations through industry best practices planned to convey remarkable worth to our customers.
Utilizing our industry knowledge, administration service offering expertise and innovation abilities, we distinguish new business and innovation slants and create answers for help customers around the globe, giving top of the line solid and practical IT benefits which are cost effective services.
Established in 1999, the organization has corner qualities in building and dealing with a Business Oriented IT environment with rich involvement in technology innovation, ERP and CRM counselling, Product Engineering, Business Intelligence, Data Management, SOA, BPM, Data Warehousing, SharePoint Consulting and IT Infrastructure. Our other offerings include modified solutions and administrations in ERP, CRM, Enterprise architecture, offshore advisory services ,e-commerce, Social , Mobile, Cloud, Analytics (SMAC) and DevOps.
USM, a US ensured Minority Business Enterprise (MBE) is perceived as one of the fastest developing IT Systems Integrator in the Washington, DC zone. Most as of late, USM was positioned #9 on the rundown of the Top administrations organizations in the DC Metro Area – Washington Business Journal (2011). We are a project-driven firm that reliably meets the IT needs of our State and Government customers through development and business keenness.
GC and Citizens only
Position Title: Sr. Data Modeler/Lead
Location: Reston, VA (Local or nearby)
Duration: 12 Months
Responsibilities
The Senior Data Modeler is responsible for creating, and maintaining, conceptual, logical and physical data models to support EDF ODS and EDF ODR. They will work with the business architects and data architects to fully understand the business requirements and be able to translate them into data structures. They will also work with the DBA’s to establish naming conventions and optimization standards for the database objects.
Key Responsibilities
• Work with the business and product owners to understand new functionality in products.
• Closely work with Data Architects to manage conceptual/logical/physical data models.
• Develop and communicate data standards
• Effectively communicate with other technology and product team members
Other Responsibilities
• Build referential integrity into the models.
• Work with developers and data architects to design data schemas.
• Profile existing databases to thoroughly understand all data.
• Standardize database object naming and domains.
Required Skills
• Bachelor’s Degree in related technical field of study.
• 12+ year’s data modeling experience with large scale models.
• 10+ years’ experience with data modeling tools (Erwin / ER Studio).
• 10+ years’ experience in Data Architecture and Database design patterns.
• 10 + years’ experience mapping data elements for ETL purposes.
• 10 + years’ experience generating physical DDL to deploy to databases Ability to reverse engineer existing databases.
• Ability to build both transactional as well as dimensional models.
• Thorough understanding of database technologies (UNIX, DB2, SQL, Data Quality).
• Experience with Healthcare data a big plus.
If you are interested in the below position please forward your profile to alih@usmsystems(dot)com or call me on 703-955-3955
Data Architecture & Governance work from LinkedIn, X, Reddit and Upwork, in one list.
Each morning you get everything that fits, strongest first.
Data Architecture & Governance
Find me workBy the team behind dataroles.