Locals and Nearby Urgent need Data Modeler
At a glance
Mid-level Data Architecture & Governance role at USM. Vienna · contract.
Pay not stated Data Architecture & Governance salary
dataroles summary, based on the employer's posting.
What you'll do
- Design logical and physical relational and dimensional models, including database layouts and ER diagrams
- Gather reporting needs from stakeholders through interviews, workshops and existing documentation
- Profile, migrate, convert and check data quality as data moves between source systems and EDW tables
- Use Teradata SQL, views and bulk programs to move data into targets, then tune query performance
- Build data quality processes with Trillium and Informatica Data Quality
What you bring
- Hands-on Teradata experience, including BTEQ, Fast Load, MultiLoad and performance tuning with Teradata EXPLAIN
- Experience with data architecture, warehousing, OLAP, BI and relational and dimensional modeling
- Background in ETL, business and data analysis, data migration, governance, integration and metadata management
- Working knowledge of Agile, Scrum and Waterfall delivery, including creating epics and user stories
Who this fits
This contract role suits a mid-level data modeler with hands-on Teradata and data quality experience. The work is onsite in Vienna, Virginia, and the contract runs for at least six months. H1 candidates are excluded.
From the employer
GC and Citizens
Hi Friends,
Hope you are doing great,
I have an urgent requirement from one of my esteem client, I will appreciate if you can have an eye on the below requirement and send me your consultant updated profile ASAP.
Job Title: Data Modeler
Location: Vienna VA
Duration: 6+months
No H1 candidates
Need following qualifications:
- Data Modeling, ETL Development, Report Requirements, Reporting
- Experience in Data Architecture, Data Modeling, Data Warehouse, OLAP, and Business Intelligence (BI).
- Strong in-work skills on designing Relational and Dimensional Models. Teradata Experience
- Hands-on skills in Relational and Dimensional Data Modeling for creating Logical and Physical Design of Database and ER Diagrams.
- Strong experience in Business and Data Analysis, Data Profiling, Data Migration, Data Conversion, Data Quality, Data Governance, Data Integration and Metadata and Master Data Management Services
- Working experience in Software Development Life Cycle methodologies- Agile (creating Epic’s, User stories), SCRUM, and Waterfall
- Working Developed Data Quality processes using Trillium & Informatica Data Quality.
- Knowledge in Business Intelligence tools like Business Objects & Tableau
- Experience with Teradata as the target for the data marts, worked with BTEQ, Fast Load and MultiLoad
- Strong experience in interacting with stakeholders/customers, gathering requirements through interviews, workshops, and existing system documentation or procedures, defining business processes, identifying and analyzing risks using appropriate templates and analysis tools.
- Good understanding in XML languages &XML data standards Experience in Financial industries ETL (Extract-Transform-Load) and EDW tables with the data from the current sources. EDW and IDW working experience
- Experience in using SQL views using Teradata SQL to load data from source to target.
- Experience in writing Teradata SQL bulk programs and in Performance tuning activities for TeradataSQL statements using Teradata EXPLAIN
- Strong Informatica Trillium, experience
All your information will be kept confidential according to EEO guidelines. please send the profiles to alih(at)usmsystems.com and contact No# 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.