IrvingRecruiter Since 2001
the smart solution for Irving jobs

Lead Data Modeler

Company: Virtusa
Location: Irving
Posted on: June 6, 2021

Job Description:

Detailed Job Description:

As a Senior Data Modeler, you will be responsible for designing and modernizing the data structures for the solutions delivered across North America. You will create and maintain conceptual, logical and physical data models, in support of the development efforts in various projects. You will plan for and implement steps towards a long term data strategy, and serve as a primary contributor to the clients vision. Duties will include: Interface on a regular basis with Business Owners, Subject Matter Experts (SMEs), other agency components to design, create, deploy and manage data solutions in accordance with the clients strategic enterprise data architecture. Serve as a subject matter expert in enterprise conceptual, logical, and physical data models and perform data management tasks that contribute to clients mission and vision. Gather data requirements to create and maintain entity relationship models and logical and physical data models that conform to existing standards and conventions. Provide leadership and guidance with enterprise data strategies. Maintain data dictionary and/or metadata repositories. Implement governance practices - implementing controls/governance across all data domains. Ensure data and data management standards are met and maintained. Partner with security architects to ensure compliance with data security and privacy mandates. Perform end-to end data lifecycle management activities that encompasses all aspects of data management, conceptual, logical, and physical, as well as evaluating and recommending new and emerging data management and storage technologies and standards. Support ongoing data strategy work, deliver data models and document data reference architectures that enhance project delivery ranging from transactional systems to reporting and analytic solutions. Develop data mapping documents for data development teams to use. Conduct and support data analysis, data mining, and identify patterns. Monitor data quality and identify data anomalies and assess possible business impact BS degree in a related scientific or engineering discipline from an accredited college or university and eight (8) to twelve (12) years of progressive experience, or an MS degree in a related scientific or engineering discipline, and seven (7) to ten (10) years of progressive experience, or a Ph.D. degree in a related scientific or engineering discipline, and two (2) to five (5) years of progressive experience.

Minimum Qualifications:

Minimum 8 years’ experience in Data Warehousing and Business Intelligence, including data modeling tools such as ERwin, ERStudio. Minimum 3 years’ experience designing and deploying data structures for Big Data environments such as Hadoop/Hive, MongoDB, HBase Experience building component based XML or JSON structures to support a Service-Oriented Architecture (SOA). Knowledge of UML modeling standards, XML transformation, XML validation schemas (XSD) is a plus. Experience with information architecture concepts (Common Information Model/Canonical Data Model, Enterprise Information Management, Metadata Management, Data Governance, and Master Data Management).

Desired Qualifications:

5 years of related experience in complex data environments 5 years of experience in strong SQL background 5 years of hands on experience in database and SQL performance tuning Deep understanding of Dimensional Modeling, Facts and Dimensions, Star Schemas, Snowflake Schemas Thorough knowledge of Data Warehousing concepts, top-down, bottom-up, common dimensions, EDW Bus Matrix Comprehensive knowledge of Conceptual, Logical and Physical modeling Excellent understanding of relational database concepts, impact of design on performance Strong experience with master data modeling best practices and data warehousing concepts Experience working with BI tools for data visualization like Tableau, Cognos, Business Objects

Keywords: Virtusa, Irving , Lead Data Modeler, Other , Irving, Texas

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category

Log In or Create An Account

Get the latest Texas jobs by following @recnetTX on Twitter!

Irving RSS job feeds