• US Citizen

• Green Card

• EAD (OPT/CPT/GC/H4)

• H1B Work Permit

• Corp-Corp

• W2-Permanent

• W2-Contract

• Contract to Hire

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 4th Oct 2023

Responsibilities:

· Maintaining a solid understanding of the company's data model and the ability to design solutions and processes which combine disparate data into meaningful reporting and analysis for customers and internal audiences.

· Understanding complex data relationships and business requirements and formulate efficient and reliable solutions to difficult problems.

· Communication and analytical skills to work with business owners, stakeholders, developers, and DBAs.

· Design and implementation of relation and star schema modelling.

· Articulating data definitions, content domains, data classes, subject area classification, and conformed dimensions.

· Collecting, maintaining, and publishing corporate metadata related to the modelling.

· Enforcing data governance standards, policies, and procedures for the design and proper use and care of data

· Developing, managing, and updating data models, including physical and logical models of the data warehouse, data mart, staging area, and the operational data store and source systems

· Working with business owners to define and understand business requirements of the enterprise data warehouse.

· Understanding the company's transactional system and data sources and identifying gaps in business processes

· Ensuring data accuracy in the early life cycle of the project.

· Performing data modelling based on Dimensional Fact Model (DFM) principle.

· Assisting in the design of the company's data extraction, staging, and loading to data warehouse processes to ensure that data is as consistent, clean, and accurate as possible.

· Acting as a key liaison to the company's Data Management Leader and developers, developing solutions to design problems, increasing efficiency and performance, and recommending best practices for data warehouse-driven reporting and analytics

· Developing technical documentation including requirements documents, process overviews, and data models/data flow.

· Interacting with data stewards for data definitions, consistency, quality, privacy, security, and conflict resolution

Qualifications

· Strong math and analytical skills are essential to complete job requirements successfully.

· Able to compile and organize statistical information retrieved and present findings to management.

· Strong computer skills and ability to use necessary databases and software.

· Interpersonal and customer service skills are required when meeting with and interviewing potential clients.

· Excellent multitasking skills and task management strategies

· Ability to complete milestones and work toward multiple deadlines simultaneously.

· Bachelor’s degree in computer science or related field

· 10+ years of experience in database development, information systems design and analysis

· experience with database technologies and the design and implementation of enterprise-level data modelling/data architecture of data warehousing and the support of business intelligence initiatives.

· Hands on experience with data modelling

· 5+ years of experience data modelling, designing, implementing, and performance management of large-scale data warehousing initiatives.

· Strong grasp of advanced SQL writing and query tuning/optimization

· Strong documentation skills (source-to-target mappings, LDM, PDM, etc)

· Strong written / oral communication and organizational skills Responsibilities