At Buchanan Ingersoll & Rooney PC, working together - to serve clients and to serve each other - is what we're all about. Our Firm has multiple offices in California, Florida, New Jersey, New York and Pennsylvania, as well as offices in Delaware, Virginia and Washington, D.C.; we are always looking for talented professionals to join our team.
Currently, we are recruiting for an experienced Financial Systems Database Analyst in our Pittsburgh location, located in the heart of downtown Pittsburgh in Oxford Centre.
The Financial Systems Database Analyst functions as part of the IT project team and reviews, analyzes, and evaluates business systems and user needs. Documents business requirements, defines scope and objectives, and formulates systems to parallel overall business strategies. Leads multiple projects and oversees developers to ensure that specifications are met. Demonstrates expertise in a variety of the field's concepts, practices, and procedures. Relies on extensive experience and judgment to plan and accomplish goals. Engages in a variety of tasks and performs the role of team leader. Provides consultation on complex projects and is considered to be the top level contributor/specialist. A wide degree of creativity and latitude is expected.
Specific Responsibilities of the Position Include:
• Install, configure, maintain, support, and upgrade all components of the firm's Practice Management Systems: This includes hardware (~26 servers), DBMS, Operating Systems, and server/client applications.
• Maintain established backup and recovery procedures. Monitor performance and tune financial servers. Perform server capacity planning.
• Resolve problems with financial server hardware and software. Provide 7x24 support when needed.
• Maintain documentation and standards.
• Interface with Elite, and other vendors as needed for technical support and customizations.
• Provide and enforce guidelines related to system access and development for vendors.
• Coordinate with the vendor, financial, networking, and applications teams to accomplish goals. Continue to improve upon the strategic direction set for the firm's financial systems.
• Maintain separate development and testing environments to protect the production environment and to eliminate contention among the varied activities.
• Lead the development of specifications for custom programs and reports.
• Coordinate budget planning related to the financial systems. Estimate budgets, develop proposals, and maintain established project budget when leading a project.
• Provide technical and consultative advice to custom reporting teams and developers.
• Direct and supervise vendors, consultants, and team members when leading projects.
Skills and Requirements:
• Bachelor's Degree in computer science or area of specialty with a minimum of 8-10 years of experience in the field or in a related area.
• Minimum of five to eight years technical experience administering SQL database systems.
• Advanced understanding of MS Business Objects, SQL, MS Operating systems, Citrix, IIS, VMWare.
• SQL Server - complex query development, User Defined Functions and DTS (SSIS) Packages.
• Experienced in writing SQL Queries, Stored Procedures, Views and ETL process and Reference Data Management.
• Demonstrated understanding of the interrelationship of hardware, OS, and SQL DBMS.
• Advanced understanding of relational database design, both logical and physical, and SQL.
• Communicates professionally and diplomatically with all levels of users, managers, and vendors.
• Ability to qualitatively and objectively evaluate and recommend technological changes in the context of business requirements.
• Dependable team player with a strong sense of client and coworker service.
• Outstanding organizational skills.
• Demonstrated ability to lead projects.
• Prior knowledge of the Elite financial system preferred.
Buchanan Ingersoll and Rooney PC offers a benefit package that includes;
• Medical
• Dental
• Vision
• 401K Program
• Pension Profit Sharing Program
• Paid Time Off
• Holiday Pay
All qualified interested candidates should submit their resume and cover letter via email to: bistaff@bipc.com. Please attach your resume and cover letter in word format, and in the subject line, indicate the title "Financial Systems Database Analyst Pittsburgh". Salary information must be included to be considered.
Candidates from staffing agencies will not be considered.
We are an Equal Opportunity Employer