What are the responsibilities and job description for the SQL DeveloperCapital MarketsAccounting - Fortress Financial - HybridMidtown NYC position at SmartIPlace?
Job Description :
The Fortress Technology team is a progressive global technology organization laserfocused on improving its user communitys impact through technology. It is responsible for delivering the technical infrastructure enduser computing mobile and business application platforms required for a global multiasset class enterprise to operate in a reliable scalable and secure environment.
An integral part of the enterprise the Fortress Corporate Application Development teams are responsible for building and supporting proprietary and vendorbased applications. It interacts daily with business teams corporate operations teams and all parts of the technology organization.
Job description
Fortress IT is seeking a dynamic selfstarter with a proven track record in developing highquality software. The Corp IT Accounting team is seeking an experienced Program Analyst with SQL experience to manage the delivery of technological solutions for key stakeholders. This individual will drive and manage the successful execution of key projects across the team. The role requires mobilizing crossfunctional teams towards agreedupon 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 crossfunctional 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.
- Required to come into our NYC office 3 days a week
Qualifications / Skills :
Please note that this job description is a general outline of the responsibilities and requirements for the Program Analyst. Additional duties may be assigned as needed.
