SQL Database Specialist

The Role:

We are seeking a SQL Data Analyst responsible for multiple facets of Planes data, assisting management with decision-making, querying, and analyzing complex data sets in various repositories. The SQL Data Analyst will collaborate with cross-functional teams to create reports, dashboards and visualizations for stakeholders. The SQL Data Analyst will also assist in management and maintenance of the data infrastructure, including SQL Server, Reporting Services, and various Azure products. Fully On-Site, No relocation assistance is offered, Must be able to commute daily to the office in West Chester, OH.

• Collect data from various sources, including primary databases, spreadsheets, and external systems.
• Write and maintain complex T-SQL queries and stored procedures to produce datasets upon stakeholder request.
• Ability to use SQL and related tools to create the reports for the users.
• Create and maintain dashboards using Planes data ecosystem.
• Work with stakeholders to understand the data and aid them in their requests.
• Consult on dataset creation for Business Analyst consumption, data warehouse modeling, and API data integration.
• Assist in database and database server maintenance.
• Collaborate with broader Solutions team on enterprise projects.
• Document and communicate the results of your efforts.
• Effectively communicate your insights and plans to cross-functional team members and management.
• Ensure solutions meet business needs and requirements.
• Perform user acceptance testing.
• Prioritize initiatives based on business needs and requirements.
• Suggest solutions and encourages a culture of problem solving.
• Being fully aware of and actively complying with Planes Companies’ policies and procedures relevant to your responsibilities and corporate policies and procedures, including equality, sustainability, the environment, health and safety, and data protection
  
  
  

Pay & Benefits:

This is a full-time position that comes with a comprehensive benefits package and a competitive salary commensurate with experience. Benefits include:

• Competitive pay: $65,000 - $72,000 per year
• Health, dental, and vision insurance
• Life and disability insurance
• Accident, critical illness insurance
• 401k retirement plan with company match
• Paid time off and paid holidays
  
  
  

Requirements:

• Bachelor’s degree in information technology or related discipline preferred.
• Experience in related position and/or related industry preferred.
• Minimum of 2 years of SQL Reporting experience.
• Experience with SQL Management Studio
• Experience with Stored Procedures Functions
• Experience with SQL objects and SQL server/database Management
• Experience with SSRS – SQL Service Reporting Services.
• Remain current on the latest technology regarding essential functions of the position.
• Possess and maintain certifications as may be required by the company and/or supervisor.
• Legally eligible to work in the United States.
• Fully On-Site, No relocation assistance is offered, Must be able to commute daily to the office in West Chester, OH.
  
  
  

Conditions:

• Full time, Monday through Friday, On-Site in West Chester, OH
• May require occasional nights and/or weekends
• Demanding, fast-paced work environment.
• Full-time position. Generally, Monday through Friday. Occasional overtime as necessary, including nights and/or weekends.
• Inside average office environment with average noise levels.
• Must be able to sit for extended periods of time at workstation.
• Low physical effort-average lift less than 10lbs. and maximum unassisted lift up to 35lbs.
• Fully On-Site, No relocation assistance is offered, Must be able to commute daily to the office in West Chester, OH.
  
  
  

The Company:

We are a global company with local values. What started with a single truck in 1921 in Cincinnati, Ohio has become a third-generation, family-owned business. Our goal is to move our customers to their next big milestone. Whether that's helping a person move one block or solving complex supply chain problems, we're here to help you move forward with confidence.

At Planes, everything starts with culture. Our TEAM culture is part of our DNA: it's evident in how we speak, in the choices we make, and in how we interact with our customers and with each other. We prioritize our culture because we know it's what makes us different - and it's what drives us to grow, and evolve, together.