Technology Architect

GSPANN; Hyderabad, Pune District, Gurugram District; On-site; INR 3,000,000 - 6,000,000; Full time

Job summary

GSPANN is seeking a seasoned Data Architect to lead architectural strategies across data modeling, data warehouses, ETL/ELT and cloud platforms. The role focuses on designing scalable data models, guiding data engineers, and ensuring governance and data quality across projects.

You will mentor teams, participate in architecture reviews, and collaborate with business stakeholders to translate requirements into robust data solutions using tools such as MicroStrategy, Tableau, Power BI and cloud

Qualifications

• 6+ years of data modelling experience for DW & analytics applications (OLAP)
• Expert data modelling skills (conceptual, logical, physical) for EDW/Data Marts
• Strong knowledge of cloud DB technologies and services (e.g., GCP, Redshift, Aurora, DynamoDB)
• Experience with data governance, data quality, and data security teams
• Experience with data curation, representation, standardization and normalization
• Experience handling large databases and data volumes
• Experience building/optimizing data pipelines (ETL/ELT, CDC, streaming)
• Experience with data discovery/BI tools like MicroStrategy/Tableau/Power BI
• Ability to lead and mentor delivery teams
• Strong executive communication and cross-functional collaboration

Responsibilities

• Develop data architecture strategies for models, metadata, MDM, DWs, ETL/ELT
• Design scalable data models and support DB structure creation
• Lead and mentor data engineers and DevOps/DataOps teams
• Explore new data technologies and define implementation timelines
• Ensure consistency of models with ecosystem (names, relationships)
• Participate in information architecture design and reviews
• Provide guidance to teams to meet milestones
• Contribute as an expert across delivery teams and build reusable components
• Align with industry trends and data community best practices

Skills

Data modelling

Data warehouses

ETL/ELT

Cloud DB tech

Python

SQL

GCP

Redshift

Tableau

Power BI

Mentoring

Executive communication

Education

Bachelor’s or Master’s in CS/EC/Software Eng

Tools

MicroStrategy

Tableau

Power BI

Job description

About GSPANN :

Headquartered in California, U.S.A., GSPANN provides consulting and IT services to global clients. We help clients transform how they deliver business value by helping them optimize their IT capabilities, practices, and operations with our experience in retail, high-technology, and manufacturing. With five global delivery centers and 1900+ employees, we provide the intimacy of a boutique consultancy with the capabilities of a large IT services firm. GSPANN is looking for a Data Architect. As we march ahead on a tremendous growth trajectory, we seek passionate and talented professionals to join our growing family.

Job Position - Technology Architect

Experience Required- 8+ Years

Location - Gurugram / Hyderabad/ Pune

Technical Skill -

Technical Architect, ETL, Data Engineer, Python, SQL and Any Cloud

Role and Responsibilities

• Develop architectural strategies for data modeling, design and implementation to meet stated requirements for metadata management, master data management, Data warehouses, ETL and ELT.
• Analyzing business requirements, designing scalable/ robust data models, documenting conceptual, logical & physical data model design, helping developers in development/ creating DB structures and supporting developers throughout the project life cycle.
• Lead and Mentor Data Engineers: This role will be responsible for leading and developing a team of data engineers focused on the growth in the team's skills and ability to execute as a team using DevOps and Data Ops principles.
• Investigate new technologies, data modelling methods and information management systems to determine which ones should be incorporated onto data architectures, and develop implementation timelines and milestones.
• Recognizes and resolves conflicts between models, ensuring that information and data models are consistent with the ecosystem model (e.g., entity names, relationships and definitions).
• Participates in the design of the information architecture: supports projects, reviews information elements including models, glossary, flows, data usage.
• Provides guidance to the team in achieving the project goals/milestones.
• Works independently within broad guidelines and policies, with guidance in only the most complex situations.
• Contribute as an expert to multiple delivery teams, defining best practices, building reusable design & components, capability building, aligning industry trends and actively engaging with wider data communities.

Required Skills

• Graduate or post graduate in Computer science/Electronics/Software engineering.
• 6+ years of relevant experience in Data modelling for DW & analytics applications (OLAP) / Database related technologies.
• Expert data modelling skills (i.e. conceptual, logical and physical model design, experience with Enterprise Data Warehouses and Data Marts).
• Solid understanding of cloud database technologies and services (eg..GCP, Redshift, Aurora, DynamoDB, etc)
• Experience in working with data governance, data quality, and data security teams.
• Experienced in knowledge-driven data processing techniques like data curation, representation, standardization, normalization and any other type of processing that prepares the data for integration, persistence, analysis, exchange/share and so forth.
• Experience in handling very large DBs and large data volumes
• Strong experience in working with large, heterogeneous datasets in building and optimizing data pipelines, pipeline architectures and integrated datasets using traditional data integration technologies. These should include ETL/ELT, data replication/CDC, message-oriented data movement and upcoming data ingestion and integration technologies such as stream data integration and data virtualization.
• Strong experience in working with and optimizing existing ETL processes and data integration and data preparation flows and helping to move them in production.
• Knowledge with popular data discovery, analytics, and BI software tools like MicroStrategy, Tableau, Power BI and others for semantic-layer-based data discovery.
• Ability to lead and mentor teams for effective delivery
• Crisp and effective executive communication skills, including significant experience presenting cross-functionally and across all levels.