Senior Database Analyst
Senior Database Analyst
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
$ 155000 - 165000
1 Vacancy
Job Description
About Hawkins
Hawkins Inc. is a formulator manufacturer blender distributer and sales agent for thousands of industrial chemicals and reagent grade laboratory chemicals sold to municipalities and businesses throughout the Central United States. Thousands across a variety of industries have depended on Hawkins for the chemical products they need since 1938.
Learn more about us at THE JOB
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 seniorlevel 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.
DUTIES AND RESPONSIBILITIES:
Strategy & Planning
- Design develop deliver maintain and support analytic applications for the
- Forecast and plan application resource needs for all data warehouse tools and database systems.
- Drive communication initiatives to empower endusers with the latest tools updates and database enhancements.
- Ensure that the performance levels are met for hardware software databases and backup and recovery.
Acquisition & Deployment
- Evaluate and recommend analytic tools database systems backup and recovery tools and other data related
- Build adhoc JD Edwards (JDE) data load and extraction
- Ensure data accuracy across all systems and create ad hoc
- Provide database installs ongoing maintenance and development
- Gather extract manipulate analyze and model data using analytical and statistical tools.
Operational Management
- Maintain the SQL Server production databases for the following applications: JDE Wercs FormScape and other various systems.
- Execute adhoc JDE system updates via
- Execute and verify database and system backup and recovery
- Proficient at analyzing slow performance and making enhancements to speed up queries and reports using
- Monitor and resolve any data related issues in a timely
- Design and implement efficient ETL workflows to support data integration reporting and analytics needs
ABOUT YOU:
- College diploma or university degree in the field of computer science or at least 10 years equivalent work experience in a Sr. Database
- Experience with Windows desktop and Server operating
- Experience with various versionsof 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 TSQL 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 userfriendly
- Effective interpersonal skills and relationshipbuilding
- Highly selfmotivated and
- Keen attention to detail.
- Proven analytical and problemsolving
- Ability to effectively prioritize and execute tasks in a highpressure
- Exceptional customer service
- Experience working in a teamoriented collaborative environment.
NICE TO HAVE
- 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.
PHYSICAL REQUIREMENTS:
The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job.
While performing the duties of this job the employee is regularly required to talk or hear. The employee frequently is required to stand; walk; use hands to finger handle or feel; and reach with hands and arms. The employee must frequently lift and/or move up to 10 pounds and occasionally lift and/or move up to 25 pounds. Specific vision abilities required by this job include close vision distance vision color vision peripheral vision depth perception and ability to adjust focus.
TRAVEL
No travel required.
Expected Compensation: $155000$bonus eligibility
Hawkins offers eligible employees and their dependents comprehensive benefits which includes medical dental vision life insurance LTD/STD and benefits for eligible employees include 401(k) match Employee Stock Purchase program (ESPP) paid time off and paid holidays.
For more information on Hawkins benefits visit: applications must be received online. All qualified applicants will receive consideration for employment without regard to race color religion sex sexual orientation gender identity national origin disability protected veteran status or any other characteristics protected by law. Hawkins is a Drug Free workplace.
Required Experience:
Senior IC
Employment Type
Full-Time
