Data Analyst/ Data Modeler

Key Accountabilities:

1. Work with business users to obtain data requirements and analyze source systems data.
2. Design and develop conceptual, logical, and physical data models for operational and analytical databases.
3. Work closely with technical and application architects, and developers to implement the solution architecture for on-prem & Cloud.
4. Communicate physical database designs to, and work with, database/cloud administrators to implement databases.
5. Document data flows, identify appropriate data sources, entities, relationships, and redundancies.
6. Manage data integrity and data quality.
7. Maintain technical & business metadata. Generate metadata for Hadoop/Google Cloud ingestion for different frameworks.
8. Design data structures and document data meanings, definitions, and intended use. Collaborate with various departments/leaders and data stewards to make metadata available.
9. Define and document the data architecture for operational databases, reporting, and provisioning platforms, including the physical components and their functionality.
10. Support data strategies, standards, guidelines, data quality processes, and governance across the enterprise.
11. Provide leadership in researching and architecting emerging technology solutions to meet business objectives.

Functional Competencies:

1. Relational and dimensional data modeling and database design.
2. Ability to translate business needs into technical solutions. Strong analytical skills.
3. Strong exposure to cloud data platforms.
4. Strong SQL and Erwin (modeling) skills.
5. Knowledge of data architectural approaches, patterns, and emerging technologies.
6. Experience creating architecture and strategy artifacts.
7. Experience with XML, JSON, and Hive (Hadoop).
8. Experience working in an Agile environment.
9. Domain knowledge in financial services and enterprise functions.
10. Knowledge of database administration, database performance tuning, source & target data structures, ETL processes & products.

Nice to have: Experience with Google Cloud products (GCS, BQ, etc).

Educational Requirements:

Bachelor's Degree or diploma in computer engineering or information science.