Risosu Consulting LLP

Job Description :

We are seeking a highly experienced Sr Data Modeler / Solution Architect to join the Data Architecture team at Corporate Office in Bangalore. The ideal candidate will have 4 to 8 years of experience in data modeling and architecture with deep expertise in AWS cloud stack, data warehousing, and enterprise data modeling tools. This individual will be responsible for designing and creating enterprise-grade data models and driving the implementation of Layered Scalable Architecture or Medallion Architecture to support robust, scalable, and high-quality data marts across multiple business units.

This role will involve managing complex datasets from systems like PoS, ERP, CRM, and external sources, while optimizing performance and cost. You will also provide strategic leadership on data modeling standards, governance, and best practices, ensuring the foundation for analytics and reporting is solid and future-ready.

Key Responsibilities:

·               Design and deliver conceptual, logical, and physical data models using tools like ERWin.

·               Implement Layered Scalable Architecture / Medallion Architecture for building scalable, standardized data marts.

·               Optimize performance and cost of AWS-based data infrastructure (Redshift, S3, Glue, Lambda, etc.).

·               Collaborate with cross-functional teams (IT, business, analysts) to gather data requirements and ensure model alignment with KPIs and business logic.

·               Develop and optimize SQL code, materialized views, stored procedures in AWS Redshift.

·               Ensure data governance, lineage, and quality mechanisms are established across systems.

·               Lead and mentor technical teams in an Agile project delivery model.

·               Manage data layer creation and documentation: data dictionary, ER diagrams, purpose mapping.

·               Identify data gaps and availability issues with respect to source systems.

Required Skills & Qualifications:

·               Bachelor’s or Master’s degree in Computer Science, IT, or related field (B.E./B.Tech/M.E./M.Tech/MCA).

·               Minimum 4 years of experience in data modeling and architecture.

·               Proficiency with data modeling tools such as ERWin, with strong knowledge of forward and reverse engineering.

·               Deep expertise in SQL (including advanced SQL, stored procedures, performance tuning).

·               Strong experience in data warehousing, RDBMS, and ETL tools like AWS Glue, IBM DataStage, or SAP Data Services.

·               Hands-on experience with AWS services: Redshift, S3, Glue, RDS, Lambda, Bedrock, and Q.

·               Good understanding of reporting tools such as Tableau, Power BI, or AWS QuickSight.

·               Exposure to DevOps/CI-CD pipelines, AI/ML, Gen AI, NLP, and polyglot programming is a plus.

·               Familiarity with data governance tools (e.g., ORION/EIIG).

·               Domain knowledge in Retail, Manufacturing, HR, or Finance preferred.

·               Excellent written and verbal communication skills.

Certifications (Preferred):

·               AWS Certification (e.g., AWS Certified Solutions Architect or Data Analytics – Specialty)

·               Data Governance or Data Modeling Certifications (e.g., CDMP, Databricks, or TOGAF)

Mandatory Skills

aws, Technical Architecture, Aiml, SQL, Data Warehousing, Data Modelling

Job Description:

We are seeking a skilled Power BI Developer with a strong understanding of Capital Markets to join our data analytics team. The ideal candidate will be responsible for designing, developing, and maintaining interactive dashboards and reports that provide insights into trading, risk, and financial performance. This role requires experience working with capital market data sets and a solid grasp of financial instruments and market operations.

Key Responsibilities:

• Develop interactive Power BI dashboards and reports tailored to capital markets (e.g., equities, derivatives, fixed income).
• Connect to and integrate data from various sources such as Bloomberg, Reuters, SQL databases, and Excel.
• Translate business requirements into data models and visualizations that provide actionable insights.
• Optimize Power BI reports for performance, usability, and scalability.
• Work closely with business stakeholders (trading, risk, compliance) to understand KPIs and analytics needs.
• Implement row-level security and data access controls.
• Maintain data quality, lineage, and versioning documentation.

Required Skills & Qualifications:

• 3+ years of experience with Power BI (Power Query, DAX, data modeling).
• Strong understanding of capital markets: trading workflows, market data, instruments (equities, bonds, derivatives, etc.).
• Experience with SQL and working with large financial datasets.
• Familiarity with risk metrics, trade lifecycle, and financial statement analysis.
• Knowledge of data governance, security, and performance tuning in BI environments.
• Excellent communication skills and ability to work with cross-functional teams.

Preferred Qualifications:

• Experience with Python or R for data analysis.
• Knowledge of investment banking or asset management reporting frameworks.
• Exposure to cloud platforms like Azure, AWS, or GCP.
• Certifications in Power BI or Capital Markets.

Frontend Developer (Angular) – 2-3 Year’s Experience

Role & Responsibilities:

·         Develop scalable, high-performance web applications using Angular.

·         Work closely with Spring Boot microservices via REST and GraphQL APIs.

·         Ensure responsive and accessible UI using Material UI, Tailwind CSS, or Bootstrap.

·         Optimize state management using NgRx.

·         Follow best coding practices, code reviews, and agile development.

·         Write unit and integration tests using Jest, Cypress.

·         Collaborate with UI/UX designers for intuitive, modern user experiences.

Skills Required:

·         Frontend: Angular, TypeScript, JavaScript (ES6+).

·         State Management: NgRx.

·         API Integration: REST, GraphQL (Apollo Client, Relay).

·         CSS Frameworks: Tailwind CSS, Material UI, Bootstrap.

·         Testing: Jest, Cypress.

·         Build Tools: Webpack, Babel, Vite.

·         Version Control: Git, SVN.

Required Skills

·      Experienced developer with hands-on expertise in Java Spring Boot: Spring Boot Data, Spring Boot Integration, Spring Boot Messaging, Spring Boot Web, Spring Boot Security, and Spring Boot AOP., MySQL, REST API, SOAP APIs, JavaScript, Angular, Tomcat, Drools, Docker, Kubernetes.

·      Strong understanding of MicroServices architecture, design patterns and best practices.

·      Designing and Developing web applications using Microservices on Java Spring Boot, testing using jUnit & jMeter, deploying using Maven, Jenkins, Docker & Kubernetes, monitoring using ELK and associated technologies.

·      Excellent problem-solving skills and ability to troubleshoot technical issues effectively. Troubleshoot and resolve technical issues, ensuring the stability and performance of applications.

Responsibilities

·      Implement low-level designs and coding for complex software systems.

·      Collaborate with cross-functional teams and Business Analysts to understand business requirements and translate them into technical solutions.

·      Implement best practices for software development, code reviews, and quality assurance.

We are looking for, Java Full stack Developer / Java Developer

Relevant Experience (In years):4+

Job Location: Mumbai

Skill: Java 8+, Spring Boot, Spring, Junit, MySQL, JSP, Servlet, JPA/Hibernate, REST Web service, SOAP web service, JQuery, Ajax, HTML, JS, JSON.

Role Category: Software Development

Education: BE / BTech in Any Specialization, MCA, BSC (IT)

Desired Competencies (Technical / Behavioral Competency)

Has experience working on Frontend technologies CSS, HTML, and JavaScript / JQuery

Hands-on experience of MYSQL Database.

Good verbal and written communication and collaboration skills to effectively communicate with both business and technical teams.

Comfortable working in a fast-paced, result-oriented environment.

Able to understand the requirement quickly and efficiently, should be able to work independently.

Significant Java Programming experience (in J2EE).

Prefer to have experience work with Agile Sprint and Scrum methodology.

Should be able to understand the requirements clearly and document the same whenever required.

Able to write reusable and scalable components and to build product aligned to platform architecture.

Follow coding guidelines and write efficient code.

Perform unit testing and preparation of unit test cases effectively.

Explore new technologies and carryout POCs

Willingness to explore and innovate new ideas with team members and appreciate individual inputs/ strengths

Good communication skills.

To support product and team with positive attitude and full dedication.