Senior DATA MODELER---------------Need GC,USC,GC-EAD,TN
At a glance
Senior Data Architecture & Governance role at USM. Columbus · no salary stated · we estimate $130,000–$181,000 across the United States.
USM has not published a salary for this role. The figure below is our estimate, not theirs.
dataroles summary, based on the employer's posting.
What you'll do
- Build and update logical and physical models for the enterprise’s operational and analytical systems
- Keep the ERWIN repository current, and create and run DDL for new or changed database objects
- Guide development teams on data design, SQL practices and database modeling choices
- Map data for integration teams and help business and IT partners profile and understand it
- Apply enterprise governance standards and review database-object requests promptly
What you bring
- You can build data models from the ground up, with relational modeling and OLTP experience
- You have advanced SQL skills, including joins, subqueries, grouping and window functions
Who this fits
This senior role suits a data modeler who can work across IT development and business teams. The position is onsite in Columbus and requires eligibility as a Green Card holder, U.S. citizen, Green Card EAD holder or TN visa holder.
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.
Senior DATA MODELER
6+ Months
Columbus, Oh.
Need GC,USC,GC-EAD,TN
MUST HAVE SKILLS – Create data models from scratch, OLTP, SQL (very complex) and relational
Top Three Skills:
advanced SQL (join tables, what is an interjoin, group buys, subqueries, windowing functions (analytics)), OLTP (online transactional processing) and relational modeling
Job Description:
The Data Modeler advises the enterprise application teams on data architecture, relational and dimensional database design and modeling, efficient SQL development, and best practices for the IT data development staff as it relates to data management. The position assists IT staff as well as business partners in profiling and understanding their data. The position must communicate clearly and effectively, collaborating with IT and business teams in order to deliver timely and effective solutions. The Data Modeler is expected to be creative and provide lateral thinking, all the while being proactive in finding solutions to the enterprises data needs.
Responsibilities:
- Develops and maintains data models (logical and physical) for operational and analytical systems in the Enterprise
- Maintains the ERWIN model repository and ensures the models are current
- Creates and executes DDL in development environments for any new and/or revised database objects
- Works closely and communicates effectively with the IT development staff on providing the best data design solutions for their needs
- Documents data mappings for integration development teams.
- Works to promote the enterprise’s data governance standards
- Reviews and Approves requests pertaining to database objects in a timely manner.
If you are interested in the below position please forward your profile to preethib@usmsystems(dot)com or call me on 703 468 0398.
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.