Data Architect (BigQuery)

DUTIES AND RESPONSIBILITIES:

• Design logical data models, ensuring alignment with business requirements, industry standards, and current data modeling best practices.

• Create robust physical data models, optimizing structures for efficient data storage and retrieval.

• Provide optimization strategies for existing data models, incorporating performance improvements, scalability, and maintainability.

• Review deliverables to ensure completeness and correctness against business requirements, promoting data quality and integrity.

• Ensure that the physical design meets the standards set by the Data Architecture team, adhering to industry best practices and compliance requirements

• Guide and provide inputs to Solution Architects on the implementation of various Business Intelligence (BI) solutions, ensuring alignment with the overarching data strategy.

• Develop in-depth source system knowledge to determine the best sources for specific information, supporting data accuracy and reliability.

• Provide source-to-target mapping for reports, extractions, and other analytical requirements, ensuring a clear understanding of data flow and transformations.

• Other job-related activities that may be assigned from time to time.

JOB SPECIFICATIONS:

• Education – Graduate of a Bachelor’s Degree preferably in Information Technology or Computer Science.

• Related Work Experience - 5+ years of experience in data architecture-related work. Must have experience in designing and/or developing a mid - large scale data warehouse or data lake.

• Experience in implementing various relational or NoSQL databases or Hadoop technologies. (e.g. Oracle, SQL Server, DB2, Teradata, Hive, Pig, Impala, MongoDB, Cassandra, HBase).

• Experienced in either Reporting or ETL is required.

Knowledge – Knowledgeable on the following:

• SDLC with emphasis on design phase or any other Agile methodologies

• Data warehousing implementation using MPP databases.

• Knowledgeable of both 3NF and Star Schema model implementation.

• Knowledgeable of various Hadoop implementation strategies.

• Knowledgeable on SDLC with emphasis on the design phase or any other Agile methodologies

Skills:

• Excellent communication skills with the ability to articulate technical concepts to non-technical stakeholders.

• Demonstrates presentation skills with a high degree of comfort for diverse audiences.

• Must have sound problem resolution, judgment, analytical, and decision-making.

• Possesses solid stakeholder relationship management skills and the ability to collaborate with various teams to attain goals and pursue excellence.

• Demonstrates excellent Organizational, Time Management, and Attention to Detail Skills.

• Ability to work with minimum supervision and able to guide new team members.

• Must be adept at working in a fast-paced environment with tight SLAs