Data Architect - Data & Performance

Cigres Technologies Private Limited; Bengaluru; On-site; INR 1,500,000 - 2,000,000; Full time

Benefits offered by this job

Training and mentoring opportunities

Collaborative team environment

Job summary

A leading tech company is seeking a Data Engineer to design and deliver solutions on their corporate platform. The role requires extensive experience in data engineering, particularly with AWS services like Redshift and Glue, and solid skills in SQL and data modeling. Ideal candidates should have over 15 years in BI projects and be capable of establishing data architecture frameworks. Strong communication and leadership skills are essential. This position is based in Bengaluru, India, and offers opportunities for growth and innovation.

Qualifications

• 15+ years experience in the full software development lifecycle on BI projects.
• 10+ years experience working on data objects in SAP & Oracle ERP.
• Expertise in AWS services and data modeling tools.
• Strong in SQL and experience with BI and ETL tools.

Responsibilities

• Design and deliver Data Engineer solutions on the corporate Data Platform.
• Collaborate with functional teams for requirement reviews.
• Develop data architecture framework and standards.
• Provide leadership and mentoring to team members.

Skills

Data modeling

SQL query writing

Analytical skills

Collaboration

Cloud management

Education

B.E / B TECH / MASTERS IN COMPUTER SCIENCE

Tools

AWS Redshift

Tableau

Informatica PowerCenter

PL/SQL

Job description

RESPONSIBILITIES

This is a strong technology and solution delivery role, accountable for the successful design, development, and delivery of Data Engineer solutions on the corporate Data Platform. The duties and responsibilities of this job are to prepare data and make it available in an efficient and optimized format for consumer analytics, BI, or data science applications. It requires working with current technologies used by IntelDS and in particular Spark, Presto, Hive and RedShift on AWS environment. This includes:

• Data & Analytics Industrialization with continuous delivery of business facing applications covering project management, functional expertise, technical architecture design, development, testing and UAT.
• Delivery responsibilities (95%):
  • Collaborating with functional teams including, but not limited to, requirement reviews to define solutions or alternatives according to the business need and technological capabilities/limitations.
  • Influencing technical and business members at different levels of the organization to ensure data models align to strategic objectives, considering current need and future potential (scalability/reusability).
  • Promoting "data first" benefits to the organization and usage of Enterprise capabilities to relevant business groups.
  • Defining the data architecture framework, standards and principles, including modeling, metadata, security, reference data and master data.
  • Hands‑on experience in building conceptual, logical & physical dimensional data models.
  • Prepare designs for database systems and recommend improvements for performance.
  • Maintain and develop various database scripts and tools to facilitate automation process.
  • Assess database implementation procedures to ensure they comply with internal and external regulations.
  • Prepare accurate database design and architecture reports for management and executive teams.
  • Follow all standard System Development Life Cycle processes and produce required documentation.
  • Produce guidelines and standards for E2E analytics implementation for both ETL &Reporting usage, manageability and maintainability within the organization.
  • Execute analysis, planning, right technology selection, prototyping, designing, developing, deploying, and assist in end‑user training of solutions to the user community for projects, changes and maintenance & evolutions.
  • Provide leadership, technical guidance, training and mentoring to others including external consultant partners – knowledge sharing is key to our success.
  • Stay abreast of industry standard and cutting‑edge technologies through whitepapers, vendor‑based collaboration and literature, and technical newsgroups – sharing research with all members of the local team and extended global community through internal collaboration tools.
  • Communicate risks and ensure understanding of these risks.
  • Strong analytical & problem‑solving skills.
  • Strong verbal and business communication skills.
  • Skill in identifying data issues and anomalies during the analysis.
  • Strong business acumen & demonstrate aptitude for analytics that incite action.
• User Support (5%):
  • Post go‑live support via ticketing tool of the full Enterprise B.I. & Analytics platforms’ capabilities – irrespective of technology.
  • The first contact point of our end users globally in run mode – optimal communication, resolution and issue closure.
  • Operational availability of our evolving technology portfolio, with deep understanding of the various technical components/features of each technology and proactive trending of weaknesses/’areas to watch’ with proposals to Platform Owner of evolutions required.
  • Realizing (& exceeding) our SLAs and Service Delivery KPI targets by defining those KPIs, with daily monitoring and benchmarking on both quantitative and qualitative measures.
  • Contributing to upgrades/evolutions end to end on the portfolio of technologies.
  • Creation and maintenance of the knowledge store of operational issues, trends, activities.
  • Applying Problem Management techniques to reduce recurring incidents and requests.

QUALIFICATIONS

EDUCATION: B.E / B TECH / MASTERS IN COMPUTER SCIENCE, ELECTRONICS, RELEVANT TECHNICAL CERTIFICATION.

Technology Skills and Project Experience:

• 15+ years experience of the full software development lifecycle on BI projects and support experience.
• 10+ years experience working on data objects pertaining both master and transactional data in Purchasing, Material, Sales Orders and Supply chain in SAP & Oracle ERP (mandatory).
• 8+ years dimensional data modelling experience (STAR & Snowflake).
• Expertise in AWS services such as Redshift, Database Migration Service, Glue, S3, and Schema Conversion Tool.
• Any one data modeling tool experience is mandatory (Erwin or any other tool).
• Strong in SQL query writing and procedures.
• Experience with BI tools: Tableau, Oracle Business Intelligence, PowerBI, etc.
• Experience with ETL tools: Informatica PowerCenter, PL/SQL, IICS, etc.
• Experience with databases: RedShift, Oracle, PostgreSQL, Exasol, etc.
• Object‑oriented programming language experience (Python).
• Experience managing servers both Cloud and On‑prem (ideally with AWS).

Business / Soft Skills:

• Proven ability and initiative to learn and research new concepts, ideas, and technologies quickly.
• Ability to communicate effectively, both verbal and written; excellent presentation skills.
• Ability to effectively move forward on tasks even with ambiguous or changing requirements.
• Ability to work in a team‑oriented, collaborative environment in a global context.
• Willingness and ability to train and teach others.
• Ability to facilitate meetings and follow up with resulting action items.
• Self‑management, prioritization and execution of tasks in a high‑pressure environment.
• Strong systems/process orientation with demonstrated analytical thinking, organization skills and problem‑solving skills.
• Desire for growth and innovation, to bring rapid solutions to business challenges/opportunities.
• Strong consultancy orientation and experience, with ability to form collaborative, productive working relationships across diverse teams and cultures (mandatory).
• Ability to work in a centralized/decentralized operating model, with varying implementation partners and owners.