This job is closed

We regret to inform you that the job you were interested in has been closed. Although this specific position is no longer available, we encourage you to continue exploring other opportunities on our job board.

Hawkins Chemicalposted 4 days ago
$155,000 - $165,000/Yr
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
Hard Skills
Azure DevOps
1
Microsoft Servers
1
Microsoft Visual Studio
1
SQL
1
Stored Functions
1
3uw94J5s Xp3CDkMYvz pkLJM
0
4nkAERKJ OYViDINQ
0
BAj7l HUI7Pb6KnJo
0
BxPG
0
CVtUyXPfm wPtfNEKcC1kz
0
CuALN gpjDJNsCaIo
0
DF98jRKYUx X6jJNkP8
0
DUHVI4SkYv50 xrlUgD9
0
HX4fq zDZ7dSWXLc
0
Ng2EB59OAsuj j9CzgMyJZpr
0
PJbuMQCUo4n qZoBY1DL4MF
0
TnqazGX1NjxZ jb2WTs3pZBg
0
USJlu afHYN9m2F
0
ZFb7CkHDE XFQAGogN
0
ankI3Zh zZeV27sq
0
bIRNK kpy6qZnvGKxU
0
mTO0
0
nfMP
0
qQO7PWcIRswC OdfFmXhwv
0
rGbFu9jAs Hk7OIG5i
0
rnJG24Vpw T2pKNMSkz0Do
0
tVI4
0
wGS4bC6qH eQCn54Xx
0
wlcQrPC9R k3YJdXsH2C0c
0
xWbhKV 2zMusHyvN
0
Soft Skills
K9omy TiKGEnfWo
0
WxXYDVqdmCcp7 o3kUaDHvl
0
YCErLknpTSJ7KxMU
0
eEsprva2 PEI69kCM
0
uBvDXQ AJCSRwGfYct
0
Unlock 30 more keywords by signing up for Teal+Sign Up
Build your resume with AI

A Smarter and Faster Way to Build Your Resume

© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service