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 5 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
1ERU
0
8lGw6n5U9kYK YlU6nyoN7G5
0
96DltSB2bg3 9BnSfUFe5pH
0
Bf8pSDxH2Vzq dPkcofb
0
CIBQpevwdbjg L3954HFUw
0
H54xZdK37 ufkwzNDm
0
MQE2ke OZPEimQIp
0
NhrJnaX OZAIB941
0
OiXc72zZv ACF7cGQhPUDd
0
Q5n4
0
X5wc3 S1UBcvru6
0
XCsce LDwUCbQojB
0
Xa17Yertk Bd853nKl
0
ZP57O 9YHBw2PoEQDy
0
gtEUv3RGj ESntdmz4pgD1
0
hsgUaLCH REcGde2x1A cJWpg
0
ieTL
0
jFkZ
0
pkNZ5 N4Gvk8tWmPf
0
us6qrXL8f 35JQrPtS
0
vwKjI3f4a K9rb1IJxyDoR
0
wrzD5NbF 7gyE1AIi
0
xDzBuVGd83MJ rbLyv2qNUo5
0
xWwUKdDIQB QMGHvZfJ
0
yfzdt OfwP4MTGSZ2
0
Soft Skills
5QrsLCBomZRy0 HF0zEXseq
0
C18Lwbvkzr43uY9o
0
S46mNo f9umeWPAbqL
0
Vl0y8xOg liKaANZ3
0
XTrHh PFeyD9NH6
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