Acuity Knowledge Partners is a leading provider of high-value research, analytics and business intelligence to the financial services sector. The company supports over 500 financial institutions and consulting companies through a team of over 2,500 subject matter experts who work as an extension of the clients’ teams based out of various global delivery centers.
We EMPOWER our clients to drive revenues higher. We INNOVATE using our proprietary technology and automation solutions. We enable our clients to TRANSFORM their operating model and cost base.
Job Purpose
Evaluate the data governance framework and Power BI environment. Provide recommendations for enhancing data quality, and discoverability, and optimize Power BI performance.
Desired Skills and experience
Candidates should have a B.E./B.Tech/MCA/MBA in Finance, Information Systems, Computer Science or a related field
7+ years of experience as a Data and Cloud architecture with client stakeholders
Understand and review PowerShell (PS), SSIS, Batch Scripts, and C# (.NET 3.0) codebases for data processes.
Assess complexity of trigger migration across Active Batch (AB), Synapse, ADF, and Azure Databricks (ADB).
Define usage of Azure SQL DW, SQL DB, and Data Lake (DL) for various workloads, proposing transitions where beneficial.
Analyze data patterns for optimization, including direct raw-to-consumption loading and zone elimination (e.g., stg/app zones).
Understand requirements for external tables (Lakehouse)
Excellent communication skills, both written and verbal
Extremely strong organizational and analytical skills with strong attention to detail
Strong track record of excellent results delivered to internal and external clients
Able to work independently without the needs for close supervision and collaboratively as part of cross-team efforts
Experience with delivering projects within an agile environment
Experience in project management and team management
Key Responsibilities
Understand and review PowerShell (PS), SSIS, Batch Scripts, and C# (.NET 3.0) codebases for data processes.
Assess the complexity of trigger migration across Active Batch (AB), Synapse, ADF, and Azure Databricks (ADB).
Define usage of Azure SQL DW, SQL DB, and Data Lake (DL) for various workloads, proposing transitions where beneficial.
Analyze data patterns for optimization, including direct raw-to-consumption loading and zone elimination (e.g.,stg/app zones).
Understand requirements for external tables (Lakehouse)
Evaluate and ensure quality of deliverables within project timelines
Develop a strong understanding of equity market domain knowledge
Collaborate with domain experts and business stakeholders to understand business rules/logics
Ensure effective, efficient, and continuous communication (written and verbally) with global stakeholders
Independently troubleshoot difficult and complex issues on dev, test, UAT and production environments
Responsible for end-to-end delivery of projects, coordination between client and internal offshore teams and manage client queries
Demonstrate high attention to detail, should work in a dynamic environment whilst maintaining high quality standards,a natural aptitude to develop good internal working relationships and a flexible work ethic
Responsible for Quality Checks and adhering to the agreed Service Level Agreement (SLA) / Turn Around Time(TAT)
Data Governance & Power BI, Databricks, Azure Data Factory, Azure Data Lake.