Job Description : Data Architect
- Role : Data Architect
- Job Location : Bangalore (Hybrid – 3 days from office)
- Experience : 10+ years
About the Role We are seeking an experienced Data Architect with a strong background in IBM DataStage, Power BI, and SAP BOBI 4.3 tools . The ideal candidate will be responsible for designing, developing, and optimizing data models, ensuring efficient data flow across systems, and transforming business requirements into actionable insights. This role requires a deep understanding of data warehousing principles, ETL processes, and business intelligence tools.
Key Responsibilities :
Design and develop data models and ETL processes using IBM DataStage 11.7 .Build and manage reports and dashboards using Power BI (Desktop, Server, and Cloud).Work with SAP BOBI 4.3 Tools including UDT, IDT, Web Intelligence, CMC , and Promotion Management .Develop, optimize, and maintain complex SQL / PLSQL queries for data extraction and transformation.Work with Oracle and PostgreSQL databases for data integration and analysis.Implement and manage Unix shell scripts to automate data workflows and processes.Conduct performance optimization for data queries and reports.Translate business requirements into scalable and efficient data models and visual reports.Analyze existing data models and build new models to support evolving business needs.Monitor and manage ETL job schedules and ensure timely data availability.Troubleshoot complex data and reporting issues independently.Must-Have Skills & Qualifications
Strong understanding of RDBMS principles such as normalization, de-normalization, data modeling, relationship models, and ER diagrams .Proficiency in Structured Query Language (SQL) for data extraction and transformation.Sound knowledge of data warehouse design concepts and different schema types (Star, Snowflake, etc.).Understanding of data security and governance principles .Hands-on experience in ETL processes and data transformation methodologies.Proficiency in Power BI – including report creation, data modeling, DAX, and performance tuning.Familiarity with Unix / Linux shell scripting for automation.Excellent analytical, problem-solving, and debugging skills.Strong communication skills and ability to collaborate across technical and business teams.Nice-to-Have Skills
Experience working in financial services or global markets domain .Exposure to cloud-based BI and data warehousing platforms .Ability to manage multiple data sources and ensure data integrity across systems.Integers.Ai is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees.