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.
