Data Modeler / Architect (Project-based)

Job Overview:

The Data Modeler/Architect will be responsible for translating the enterprise business needs into conceptual, logical and physical data models. This role will provide expertise on data modeling tools, techniques and best practices and lead the design and implementation of the data architecture and data modeling solutions supporting enterprise information management, business intelligence, machine learning, data science, and other business interests across relational, dimensional and NoSQL databases. Has solid knowledge of data architectures, data stewardship and data governance. The candidate must be able to work independently and collaboratively partnering with cross location business and technical teams

Responsibilities:

• Define & implement Data Management Strategies: -Data acquisition (Data integration & ETL), data inventory control (data cataloging) & data storage
• Establish Data Governance policies, practices: - cover data quality, accuracy, security & correctness
• Work with business and application/solution teams to implement data strategies, build data flows, and develop conceptual/logical/physical data models
• Define and govern data modeling and design standards, tools, best practices, and related development for enterprise data models.
• Define and maintain accurate functional data definitions and taxonomies for entities and attributes.
• Identify the architecture, infrastructure, and interfaces to data sources, tools supporting automated data loads, security concerns, analytic models, and data visualization.
• Work proactively and independently to address project requirements and articulate issues/challenges to reduce project delivery risks.
• Research latest data technologies and develop proof of concept

Requirements:

• 8+ years of experience in designing and implementing EDW, BI & A solutions
• Minimum 4 plus years of experience in Entity Relationship Models, Star Schema, Dimensional Modeling, and other Data Modeling Techniques and Methodologies
• Experience in Data Warehouse, Data Architecture, Design, Analysis, Modeling, Development, Testing, Implementation, Training and Documentation.
• Hands on experience in creating database schemas, SQL, PLSQL programming and End-to-End ETL validations.
• Experience with modeling tools like Erwin, Talend for Data Transformation (ETL) and Power BI Reporting
• Working knowledge in Analysis Services (SSAS) and Integration Services (SSIS)
• Exposure to Azure cloud components like Data Factory, Data Lake, SQL Database
• Experience in descriptive, diagnostic, predictive or prescriptive Data Analytics
• Experience in Snowflake schema methods, identifying the dimensions, measures, Hierarchy levels for Fact and Dimension tables.
• Strong in both Star schema and OLTP Schema
• Expertise in designing for late arriving data and factless facts
• Contact center domain knowledge and business data models
• Knowledge of mathematical foundations and statistical analysis.
• Analytical, flexible, team-oriented and have good interpersonal/communication skills

Education:

• Bachelor's degree in Computer Science, or related technical discipline