Contractor - Technical BA /SQL Developer - Corporate IT Accounting Team at Global Investment Management Firm - NO THIRD PARTIES - M-Logic : Job Details

(*Will not accept third party applicants)

Corporate IT Accounting team at a leading investment manager in NYC is seeking an experienced technical business analyst / SQL developer with strong SQL database and financial data analysis experience to drive and manage the successful execution of key projects across the team. The role requires mobilizing cross-functional teams towards agreed-upon goals, showcasing key benefits, and overseeing and reporting progress on projects.

Responsibilities:

• Gather and document business requirements from stakeholders and Analyze business processes and identify areas for improvement.
• Create detailed business analysis, outlining problems, opportunities, and solutions.
• Collaborate with cross-functional teams to ensure successful implementation of projects.
• Conduct data analysis to support business decisions.
• Design, develop, and maintain SQL databases and database objects (tables, views, indexes, stored procedures, functions, etc.)
• Optimize database performance through indexing, query optimization, and other techniques.
• Collaborate with application team to design and implement database schemas and structures.
• Ensure data integrity and security through proper design and implementation of database constraints and permissions.
• Develop and maintain ETL processes to integrate data from various sources.
• Develop Power BI dashboards and SSRS reports.

Qualifications/Skills:

• A bachelor's degree in computer science, or a related technical field.
• At least 7 years of proven experience as an SQL Developer and Business Analysis.
• Proficiency in writing and optimizing complex SQL queries and stored procedures.
• Experience with data analysis and reporting tools (e.g., Excel, SQL, SSRS, Power BI).
• Strong knowledge of accounting principles and financial data analysis.
• Experience in Infor / Lawson financials is a plus
• Ability to work independently and as part of a team.
• Strong organizational, multitasking and multi-focus skills.