Key Responsibilities - Write advanced T-SQL queries, stored procedures, and functions to handle complex data transformations, ensuring optimal performance and scalability.
Perform query performance optimization, including indexing strategies and tuning for large datasets.
Design, develop, and maintain ETL/ELT pipelines using tools like SSIS, ADF, or equivalent, ensuring seamless data integration and transformation.
Build and automate data workflows to support accurate and productive data operations.
Collaborate with stakeholders to understand financial business processes and requirements.
Develop tailored data solutions to address challenges such as cost allocation, weighted distributions, and revenue recognition using mathematical and logical reasoning.
Conduct root cause analysis for data issues, resolving them swiftly to ensure data accuracy and reliability.
Apply critical thinking and problem-solving to transform business logic into actionable data workflows.
Partner with cross-functional teams to ensure data solutions align with business objectives.
Document data workflows, pipelines, and processes to support ongoing maintenance and scalability.





Required Skills and Experiences - Minimum 5+ years of experience require in the similar role or same skillset
Advanced proficiency in T-SQL and SQL Server, including tools like SSMS, SQL Profiler, and SQL Agent.
Proven experience developing and optimizing complex queries, stored procedures, and ETL pipelines.
Proficiency with SSIS for data integration and transformation.
Robust critical thinking and mathematical reasoning skills to design effective solutions for business problems.
Demonstrated ability to handle complex financial data challenges, including proportional distributions and other mathematical transformations.
Solid understanding of financial concepts and processes, enabling seamless translation of business needs into data solutions.
Ability to work effectively with business stakeholders, translating requirements into technical solutions.
Excellent interpersonal and communication skills, fostering collaboration across teams.
Familiarity with Python, C#, or similar scripting languages for backend integration.
Experience with cloud ETL tools such as Azure Data Factory (ADF), Fivetran, or Air byte.
Knowledge of data governance and compliance principles.

📌 Data Engineer Financial Analytics Specialist Bengaluru
🏢 RWS Group
📍 Bengaluru