What are the responsibilities and job description for the SQL Database developer position at One IT Corp?
Job Details
SQL Database developer
Required Location: Hybrid/Midtown New York City 3 days a week.
Duration: 12 Months
Interview Required: Video
SQL Database developer with extensive experience working in Capital Markets/Financial Services environments and experience working with accounting systems or software is a huge plus. Candidates must Develop Power BI dashboards and SSRS reports.
Please make sure that each submittal includes:
- Driver s license or State ID
- Link to the candidates LinkedIn account.
Job Description:
The Fortress Technology team is a progressive, global technology organization laser-focused on improving its user community's impact through technology. It is responsible for delivering the technical infrastructure, end-user computing, mobile and business application platforms required for a global, multi-asset 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 vendor-based 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 self-starter with a proven track record in developing high-quality 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 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.
- Required to come into our NYC office 3 days a week
Qualifications/Skills:
- A bachelor's degree in computer science, or a related technical field.
- At least 10 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
- Strong analytical and problem-solving skills.
- Excellent communication and interpersonal skills.
- Ability to work independently and as part of a team.
- Strong organizational, multitasking and multi-focus 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.
