Address
Form of work$85,000.00 - $110,000.00 per year
Rates determined by experience level
About us:
At Jetro/Restaurant Depot, we are a full line cash and carry wholesale supplier to foodservice and retail food independent business owners. Everything from stoves, tomatoes, fish, olive oil and steak can be purchased at our warehouses.
About the job:
Excellent full-time opportunity for a SQL Developer working on a large-scale SQL Server environment. Your primary role will be to write and maintain reports against our data warehouse using SQL, SSRS, SSMS, and Visual Studio. You will also help maintain the reporting and data warehouse environment. This includes optimizing SQL code and creating, re-structuring, archiving, and purging tables as needed to improve server performance.
Responsibilities:
- Developing tabular, web based, and graphical reports in Visual Studio using SSRS.
- Creating complex SQL queries that involve multiple tables, databases, and linked servers.
- Optimizing existing stored procedures to improve performance.
- Creating tables, views, clustered & non-clustered indexes, and user defined functions.
- Troubleshooting database performance issues, bottlenecks, and errors.
- Creating SQL jobs that aggregate and maintain large-scale data to be used by reports.
- Creating and maintaining data sets for the software development team.
- Performing data analyses to identify data quality issues and compose data cleansing plans.
- Learning, understanding, and utilizing our datasets to efficiently meet business needs and the requests of our many system users.
Requirements:
- BA/BS in CIS/MIS or related field and/or certification in SQL related technologies (depending on the coursework included).
- Knowledge of relational database design and architecture.
- Proven experience in writing complex SQL queries, stored procedures, and functions.
- Proficiency in designing, developing, and optimizing SSRS reports.
- Ability to adapt and learn quickly in a dynamic, data-centric environment.
- Excellent at interpreting and analyzing data.
- Strong problem-solving and decision-making skills.
- Excellent interpersonal skills and the ability to work independently and/or as a member of a team.
- Excellent oral and written communication skills.
Environment and Software:
- Microsoft Windows
- Microsoft SQL Server
- Microsoft SQL Server Management Studio (SSMS)
- Microsoft SQL Server Reporting Services (SSRS)
- Visual Studio
- Team Foundation Server (TFS)
- Microsoft Excel
- Microsoft Outlook
Experience with any or all of these a plus.
- Data warehouse environments
- SQL Server Integration Services (SSIS)
- ETL concepts
- SQL Replication
- SQL Server Analytic Services (SSAS)
- Multi-dimensional and tabular models
- PowerBI
- SQL Database permissions
- Redgate software
- SQL Server Profiler
- App development and other programming languages
- Source control
- Ticketing systems such as JIRA software and ServiceNow.
Location:
This is a Hybrid Role - based in Whitestone, NY
