Data Architect / Data Engineering Lead (GCP)

Essential Duties:Develop and maintain the organization's overall data architecture strategy, including data models, data integration, data governance, and data quality standards.Design and implement scalable and efficient databases, data warehouses, and data lakes to support business needs and analytics initiatives. Excellent understanding of dimensional data modeling, RDBMS and NoSQL platforms.Responsible for managing the full life cycle of data warehouse and big data solutions. This includes creating the requirements analysis, the platform selection, design of the technical architecture, design of the application design and development, testing, and deployment of the proposed solution.Collaborate with stakeholders, such as business analysts, data scientists, and IT teams, to understand data requirements and translate them into effective data solutions.Benchmark systems, analyze system bottlenecks and propose solutions to eliminate them.Evaluate and select appropriate technologies, tools, and platforms to support the organization's data architecture strategy.Guide/Mentor/Assist in development of the proposed architectural solution.Lead performance tuning and optimization activities of the data systems to ensure high availability, reliability and efficiency.Lead the team in infrastructure setup phases.Take end-to-end ownership for solution components and bring in design best practices and tools. Define data integration and ETL (Extract, Transform, Load) processes to ensure smooth data flow between systems and data sources.Establish and enforce data governance practices, including data security, data privacy, and data access controls.Stay updated with emerging trends, best practices, and technologies in the data architecture field and recommend improvements to enhance data management capabilities.Skills:Minimum of 7 years work experience as a data or information architect (enterprise level preferred)Minimum 5+ years' experience in Data Warehouse design and development for large-scale complex Data Platform. Experience with star schemas, dimensional modeling, and extract transform load (ETL) design and development. Knowledge of data modeling using Kimbal and Inmon methodologiesRecent 5+ years in Big Data Ecosystem. Expertise in cloud-based data platforms, such as AWS, Azure & Google. In-depth knowledge of data modeling concepts and techniques, including relational, dimensional, and NoSQL data models.Python expert responsible for designing, coding, deploying and debugging development projects related to data pipelines that formulate data for valuable insights.Proven experience in the design, development, and implementation of complex data warehouse/data mart environments.Expert understanding of architectural and data warehouse design principles and data integration.Experience with major big data solutions like Hadoop, Hive, and MongoDB. Experience with open table formats like Iceberg, Hudi and Delta.Understanding of major programming/scripting languages like Java and/or R.Expert with data integration technologies like Kafka and Spark.Knowledgeable of any of the ETL technologies like Pentaho, SSIS, Informatica or DataStage.Experience working with RDBMS like Oracle, SQL Server, MySQL and Postgres.Excellent team player with a proven background of individual contribution. Strong track record in building strong relationships.Detail-oriented with very good organization and project management skills.Must be comfortable communicating with all levels of the organization, have good interpersonal skills, and display good team work ethics.Must be self-motivated, problem-solver with analytical skills with the ability to multi-task while meeting deadlines.Knowledge of data governance practices, data security, and privacy regulations (e.g., GDPR, CCPA). PRB