SQL Developer
Paoli Direct Hire Jul 1, 2024
Role: SQL Developer
Type: Direct-hire/permanent
Location: REMOTE, must be based in one of the following US states: 
Arkansas, Florida, Georgia, Indiana, Kansas, Maryland, Massachusetts, Mississippi, Nevada, New York, Ohio, Pennsylvania, South Carolina, Texas, Virginia, Wisconsin
*W2 only*
*No sponsorship provided*

Our client, a specialty retail and e-commerce company, is seeking an experienced SQL Developer to join their team. This is a DIRECT HIRE role. This position is a REMOTE role.

Job Summary:
Reporting to the Manager of Data Engineering, the SQL Developer is primarily responsible for developing and maintaining robust data integration pipelines between various systems such as internal OLTP databases, third-party vendor platforms, and an Enterprise Data Warehouse (EDW), scoping requirements for advanced reports, developing metrics and dashboards, and making recommendations for process improvement based on analysis of historical data.
  • Develop, Extract, Transform, & Load (ETL) scripts and their execution schedules utilizing applications such as SSMS, SSIS and Azure Data Factory.
  • Work with multiple .NET Development teams to create stored procedures, functions, tables, and other SQL objects to support the needs of our eCommerce web sites and other internal applications. 
  • Triage, prioritize, manage, and resolve any data related requests and issues generated to the IT Department.
  • Collaborate with representatives from across internal departments to contribute in analytics and data integration projects.
  • Understand business processes and scope data requirements for reports.
  • Discover opportunities and provide recommendations for improvement within company strategy to drive incremental operational success.
  • Ensure maximum availability and performance reliability of dashboards and visualizations available via Tableau Server, coordinating with IT Support for maintenance and administrative tasks.
  • BA/BS in IT, marketing, e-commerce, economics, mathematics, or other related degrees AND at least 1 year of experience working in similar capacity. BA/BS degree requirement can be substituted for 3 + years of related work experience.
  • Excellent oral and written communication, interpersonal skills.
  • Excellent analytical skills: including being able to quality-assure, clean, and analyze large data sets to draw conclusions and propose recommendations.
  • 1-3 years of experience working with ETL tools such as MS SQL Server Integration Services
  • Proficiency with creating packages to support ETL process to and from data sources such as, but not limited to, CSV and text files, XML, JSON, MS Excel, MS SQL Server tables, and Tableau Extracts.
  • Proficiency in MS Excel (Pivot tables, VLOOKUP, text to table conversions, etc) .
  • Data-centric experience working with various applications (OMS, WMS, etc.) implemented within an eCommerce setting would be a plus.
  • Experience with Powershell Scripting required
  • Hands on experience developing and querying Data Warehouse(s) would be a plus.
  • 1-3 years of experience supporting Tableau Server by performing upgrades, installs, and configuration change would be a plus
  • Retail or e-commerce experience is highly preferred