Job Information
Robert Half Database Analyst in Conshohocken, Pennsylvania
Description Summary: The Database Analyst will be responsible for developing financial reporting dashboards and creating and maintaining integrated database systems. The ideal candidate will have a strong background in financial reporting and advanced knowledge of SQL and Microsoft SQL Server. This candidate will be at the forefront of developing new financial reporting tools and dashboards in Microsoft Power BI and manages our company's SQL databases, ensuring their stability, security, resiliency, and performance.
Key Responsibilities:
Manage and maintain the company's databases, including database design, implementation, backup, recovery, resiliency, and performance tuning
Develop and maintain database-related queries, scripts, and stored procedures to support financial reporting and data analysis
Build and maintain dashboards in Power BI to visualize financial data and support decision-making processes
Collaborate with the organization to design, develop, and implement database solutions that meet business requirements
Proactively monitor database performance, resolve database issues, and identify areas for improvement
Develop and maintain database security and access controls to ensure data confidentiality and privacy
Develop integrations to internal and external systems with REST APIs
Provide database support to the organization and resolve technical problems as needed
Participate in the development and testing of database backup and recovery procedures
Document new and existing processes including queries, development workflows, and procedures
Performs other duties including advanced projects as required
Qualifications:
5+ years of experience as a DBA, with a focus on financial reporting
Strong knowledge of SQL & SQL Server, including stored procedures, views, SSIS & SSAS integrations, SSRS customizations, and optimization best practices
Hands-on experience with Power BI and dashboards development
Experience with REST API development and integration
Working knowledge of on-premises ERP systems
Excellent problem-solving and analytical skills
Ability to work independently as well as part of a team
Excellent written and verbal communication skills
Education:
Bachelor's degree in Computer Science, Information Technology, MIS, or a related field Requirements SQL, SQL Server, SSAS SSIS, SSIS - SQL Server Integration Services, SSIS, SSIS SSRS, SSRS, Power BI, Microsoft Power BI, Power BI, REST API, REST API Design Technology Doesn't Change the World, People Do.®
Robert Half is the world’s first and largest specialized talent solutions firm that connects highly qualified job seekers to opportunities at great companies. We offer contract, temporary and permanent placement solutions for finance and accounting, technology, marketing and creative, legal, and administrative and customer support roles.
Robert Half works to put you in the best position to succeed. We provide access to top jobs, competitive compensation and benefits, and free online training. Stay on top of every opportunity - whenever you choose - even on the go. Download the Robert Half app (https://www.roberthalf.com/us/en/mobile-app) and get 1-tap apply, notifications of AI-matched jobs, and much more.
All applicants applying for U.S. job openings must be legally authorized to work in the United States. Benefits are available to contract/temporary professionals, including medical, vision, dental, and life and disability insurance. Hired contract/temporary professionals are also eligible to enroll in our company 401(k) plan. Visit roberthalf.gobenefits.net for more information.
© 2024 Robert Half. An Equal Opportunity Employer. M/F/Disability/Veterans. By clicking “Apply Now,” you’re agreeing to Robert Half’s Terms of Use (https:///www.roberthalf.com/us/en/terms) .
Robert Half
- Robert Half Jobs