SQL Developer

Job Description

SQL Integration Developer

Overview

We seek a skilled and innovative SQL Developer to join our datadriven team. The ideal candidate will be proficient in developing and maintaining solutions that transform raw data into actionable insights enabling informed decisionmaking across the organization. As a SQL Developer you will play a crucial role in the continued effort of designing implementing and optimizing our company infrastructure while collaborating with crossfunctional teams to deliver meaningful data solutions. Your role is integral to our datadriven team and will report to the Information Systems Manager.

Responsibilities

• Manage the data needs of technologyforward projects. Admin Office365/Azure ERP (Dynamics GP SalesPad) integrated software including CRM Customer Survey Platform Paycom etc.

• Extract transform and load (ETL) data from various sources into data warehouses or data marts ensuring data accuracy and consistency.

• Optimize and finetune SQL queries and data models for optimal performance and responsiveness.

• Develop and maintain data pipelines data integration processes and data cleansing procedures. Implement data governance practices ensuring data quality security and compliance with relevant regulations.

• Participate in data architecture and modeling discussions to ensure the scalability and flexibility of BI solutions.

• Design develop and maintain BI reports dashboards automated alerts and data visualizations using industryleading tools and technologies

• Collaborate with business stakeholders to gather requirements and translate them into effective BI solutions that address data analysis and reporting needs.

• Implement automation of various functions related to departmental needs in Microsoft GP Taulia SalesPad and others.

• Monitor and troubleshoot data solutions to identify and resolve performance issues or data discrepancies.

• Stay current with industry trends and best BI and data analytics practices bringing innovative ideas to enhance the organizations data capabilities.

• Collaborate with crossfunctional teams including data analysts data scientists and business users to understand their requirements and provide datadriven solutions.

• Provide training and support to endusers ensuring they can effectively utilize BI tools to access and analyze data.

• Participate in the planning and executing of data projects ensuring ontime delivery and alignment with business goals.

• Collaborate with thirdparty IT support vendors as needed and ensure they are informed when projects affect them or the services they provide or manage.

• Assist with data capture planning and implementation of new software releases and crossfunctional assignments.

Contribute as a member of the Opportunity Analysis Team by researching following up resolving issues and documenting resolution processes that may need to be replicated by others.

Role Specific Requirements

• Strong understanding of software systems including cloudhosted (Azure) webbased and softwareasaservice (SaaS).

• Proficiency with MS SQL PowerShell Python

• Experience in data warehouse design and schema structuring.

• Indepth knowledge of Microsoft SQL Server and TransactSQL.

• Strong understanding of database design principles and data modeling processes. Proven work experience designing and optimizing SQL queries stored procedures functions and jobs.

• Experience developing and maintaining scripts for data migration and ETL (Extract Transform Load) processes.

• Knowledge of software development and user interface web applications.

• Familiarity working with .Net Framework JavaScript and HTML.

• Familiarity with scripting languages (e.g. Python) for automation tasks.

• Previous experience in cloudbased API integrations (e.g. AWS Azure).

• Experience with RESTful and/or SOAP APIs.

• Proficiency in data formats such as JSON and XML.

• Familiarity with authentication mechanisms such as OAuth and API keys.

• Critical thinking using logic and reasoning to identify the strengths and weaknesses of alternative solutions conclusions and approaches to problems.

Experience & Education

• Bachelors degree in Computer Science Information Systems Data Science or a related field. 25 years of Backend SQL Development experience required.

• Experience in PowerBI and SSRS preferred

• Positive work attitude that is professional responsive and welcoming.

• Demonstrated abilities of resourcefulness flexibility thinking with good judgment initiative and a strong work ethic.

• Proficiency in computer software in all aspects of Microsoft Office particularly Excel Word and Outlook.

• Judgment and decisionmaking considering the relative costs and benefits of potential actions to choose the most appropriate one.

• A team player driven to help our clients team accomplish our goals.

• Prior experience with Microsoft GP SalesPad ZenDesk and StockIQ would set a candidate apart but is not required for this role.

Remote Work :

No