Data Engineer - Financial Analytics Specialist

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 efficient 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

Skills Required

T-sql, Analytical Skills, Finance, Ssis, Sql