SQL Developer / Database Developer / Data Warehouse Developer
Dental City SQL Developer / Database Developer / Data Warehouse Developer
Summary
Senior SQL Developer at Dental City, a dental supply distributor in Green Bay, WI, maintaining and enhancing SQL Server data warehouses, building T-SQL/SSIS ETL pipelines, SSRS reports, and internal/external system integrations. Onsite preferred (hybrid possible); salary range $95,000-$125,000.
- Maintain, support, and enhance SQL Server data warehouse environments using T-SQL and SSIS; develop advanced stored procedures, functions, triggers, and SQL Agent jobs.
- Develop and support integrations with internal and external systems.
- Create and maintain SSRS reports, including parameterized, drill-down, and matrix reports; design, implement, and maintain queries, dashboards, reports, and data solutions.
- Troubleshoot production issues with minimal supervision and provide database support to web developers and reporting teams.
- Document system processes, procedures, and technical workflows; support end users with Microsoft SQL Server and Microsoft Dynamics GP applications.
- Collaborate within Agile development environments and participate in continuous improvement initiatives.
- Bachelor's degree in Computer Science, Information Systems, or equivalent experience.
- 7+ years of experience with IT applications, relational databases, and software development, preferably MS SQL Server.
- 5-7 years of experience supporting ERP/CRM integrations and IT development initiatives using web technologies and architectures.
- Experience with sales order processing, purchasing, inventory control, warehousing, or wholesale distribution is a plus.
- SQL Server 2012+ and Azure SQL; SSMS, SQL Profiler, and Database Tuning Advisor.
- SSRS and SSIS development; data warehousing, ETL, and data integration.
- JIRA and Azure DevOps.
- ODBC connectivity and report-writing tools.
- Microsoft Office applications, particularly Excel and Access.
- Microsoft Dynamics GP (preferred).
- Strong database performance tuning and optimization experience.
- Ability to analyze complex problems and develop practical solutions.
- Understanding of large-scale system integrations and application development concepts.
- Excellent documentation, communication, and collaboration skills.
- Ability to quickly learn new technologies and understand technical documentation.