Senior Database Analyst

Full-time - Senior

Roseville, MN

Professional, Scientific, and Technical Services

About the position

A senior database analyst specializes in collecting data, organizing that data, and then analyzing the data so that they can accurately report out information so other departments can make informed decisions. As a senior-level employee, the senior database analyst serves as a liaison between the Information Technology team and other departments. They use their experience with data management, database systems, and reporting systems to collect and report on data within the organization. A great deal of this process is automated, so the ability to see the big picture and architect out solutions that consider all areas of the organization is important. Familiarity with database systems, especially Microsoft SQL Server, is a must. Ability to troubleshoot database issues, locks & blocks, and performance tuning is required. Experience with JD Edwards or similar ERP systems is a plus.

Responsibilities

• Design, develop, deliver, maintain, and support analytic applications.
• Forecast and plan application resource needs for all data warehouse tools and database systems.
• Drive communication initiatives to empower end-users with the latest tools, updates, and database enhancements.
• Ensure that the performance levels are met for hardware, software, databases, and backup and recovery.
• Evaluate and recommend analytic tools, database systems, backup and recovery tools, and other data related tools.
• Build ad-hoc JD Edwards (JDE) data load and extraction.
• Ensure data accuracy across all systems and create ad hoc reports.
• Provide database installs, ongoing maintenance, and development.
• Gather, extract, manipulate, analyze, and model data using analytical and statistical tools.
• Maintain the SQL Server production databases for the following applications: JDE, Wercs, FormScape, and other various systems.
• Execute ad-hoc JDE system updates.
• Execute and verify database and system backup and recovery.
• Proficient at analyzing slow performance and making enhancements to speed up queries and reports.
• Monitor and resolve any data related issues in a timely manner.
• Design and implement efficient ETL workflows to support data integration, reporting, and analytics needs.

Requirements

• College diploma or university degree in the field of computer science or at least 10 years' equivalent work experience in a Sr. Database role.
• Experience with Windows desktop and Server operating systems.
• Experience with various versions (2019, 2022) of Microsoft SQL Server database.
• Experience building business solutions with SQL Server Analysis Services (SSAS), and SQL Server Integration Services (SSIS).
• Develop, manage, and optimize ETL (Extract, Transform, Load) processes to ensure seamless data integration across systems, supporting business acquisitions.
• Strong T-SQL skills (Stored Procedures, Functions).
• Strong SQL Server database administration skills (optimization, backup and recovery, design).
• Ability to absorb and retain information.
• Ability to present ideas in user-friendly formats.
• Effective interpersonal skills and relationship-building.
• Highly self-motivated.
• Keen attention to detail.
• Proven analytical and problem-solving skills.
• Ability to effectively prioritize and execute tasks in a high-pressure environment.
• Exceptional customer service skills.
• Experience working in a team-oriented, collaborative environment.

Nice-to-haves

• Experience building reports with SQL Server Reporting Services (SSRS).
• Experience with Microsoft Visual Studio.
• Experience with using Azure DevOps, or other source control technologies.
• Other software development experience (.NET, PowerShell).
• Experience with WebFOCUS (Information Builders).
• Experience working in an agile software development environment (e.g. SCRUM).
• Experience with Excel and Excel pivot tables.

Benefits

• Medical insurance
• Dental insurance
• Vision insurance
• Life insurance
• Long-term disability insurance
• Short-term disability insurance
• 401(k) match
• Employee Stock Purchase program (ESPP)
• Paid time off
• Paid holidays