Business Intelligence Analyst

• Design, develop, and optimize complex SQL queries, stored procedures, and data pipelines to process and analyze large-scale structured datasets from SQL Server and Snowflake environments
• Engineer and deploy data validation and quality assurance frameworks using Python, SQL, and VBA to enforce data integrity, consistency, and referential accuracy
• Perform advanced data analysis, statistical evaluation, and reconciliation of multi-source datasets using Python (Pandas, NumPy) and SQL
• Apply data modeling techniques, normalization principles, and schema design to build scalable and efficient data structures
• Conduct root cause analysis (RCA) of data anomalies by performing data lineage tracing and system-level diagnostics
• Support data migration, system integration, and data conversion projects through data profiling, validation, and User Acceptance Testing (UAT)
• Integrate and validate external financial datasets (e.g., Bloomberg) with internal enterprise systems using automated validation logic
• Develop and implement Python-based data processing frameworks and ETL pipelines for data extraction, transformation, cleansing, and integration across heterogeneous systems
• Collaborate with cross-functional stakeholders to translate business requirements into technical data solutions and system specifications
• Utilize enterprise tools such as JIRA and ServiceNow for defect tracking, incident management, and workflow coordination in Agile environments
• Leverage AI-assisted development tools (e.g., Microsoft Copilot) to enhance productivity in coding, debugging, and technical documentation
• Ensure adherence to data governance frameworks, regulatory compliance standards, and audit requirements in all data processing activities

Ability to work in a project driven environment