Data Analyst & Designer Consultant

Job Purpose:The Data Analyst & Designer Consultant is responsible for analyzing enterprise data landscapes, translating business requirements into data design solutions, and developing conceptual, logical, and physical data models that support analytics, reporting, and data-driven decision-making initiatives. The role works closely with data architects, business stakeholders, and implementation teams to design scalable, governed, and business-aligned data platforms while ensuring compliance with enterprise architecture and data governance standards.Key Accountabilities:Analyze business requirements and translate them into detailed data requirements, business rules, and transformation specifications.Assess source systems and identify relevant data assets required to support business and analytics objectives.Design conceptual, logical, and physical data models aligned with enterprise data architecture principles.Develop and maintain enterprise data design artifacts, data dictionaries, and mapping documentation.Define source-to-target mappings, transformation rules, and data flow designs to ensure traceability and governance.Collaborate with data architects to design scalable, reusable, and modular data platform architectures.Support the development of data integration, analytics, reporting, and business intelligence solutions.Design storage-layer structures including data warehouses, data marts, data lakes, and analytical repositories.Identify extraction requirements, data sourcing strategies, and ingestion approaches for various source systems.Ensure alignment between data models, business semantics, performance requirements, and data quality standards.Work closely with data engineers to translate design specifications into data ingestion and transformation processes.Develop high-level and detailed solution design documents for data platform initiatives.Support data governance and architecture frameworks by ensuring consistency, compliance, and traceability across data assets.Participate in workshops, requirement gathering sessions, and design reviews with business and technical stakeholders.Contribute to continuous improvement initiatives related to data architecture, analysis, and design methodologies.

Minimum Qualifications

Bachelor's Degree in Computer Science, Information Technology, Information Systems, Engineering, Data Science.Professional certifications related to Data Management, Data Modeling, Data Architecture, or Analytics.CDMP (Certified Data Management Professional) or equivalent certification.Minimum Experience:+6 years of experience in Data Analysis, Data Modeling, Data Architecture, Data Design, or Enterprise Data Management.Proven experience analyzing complex business requirements and converting them into data design solutions.Experience designing enterprise data platforms, data warehouses, data marts, or analytics environments.Job-Specific Skills:Business Requirements Analysis.Data Requirements Definition.Source System Analysis.Data Discovery and Assessment.Data Flow Analysis.Data Mapping and Transformation Design.Source-to-Target Mapping.Conceptual Data Modeling.Logical Data Modeling.Physical Data Modeling.Enterprise Data Architecture.Data Warehouse Design.Data Mart Design.Data Lake and Modern Data Platform Concepts.Data Architecture Frameworks.Data Governance Principles.Data Quality Requirements.Metadata Management Awareness.Data Lineage and Traceability.Data Standards and Data Definitions.Business Glossary Development.SQL and Data Analysis.Data Integration Concepts.ETL / ELT Design Principles.Data Storage Layer Design.Reporting and Analytics Data Structures.Database Design and Optimization.