SQL Developer

We are looking for a strong SQL developer to work as part of a strong team of developers, business analysts, and business owners to architect, develop, implement, and support and troubleshoot Client databases and applications. As a SQL developer, your responsibilities would include:

  • Creating and altering stored procedures, functions, triggers, and other SQL database objects that assist in the implementation of business logic and data flows through Client data and application infrastructure
  • Ensuring that the integrity of company databases is maintained
  • Creating Integration Service packages (SSIS) to automate ETL processes
  • Monitoring and troubleshooting SQL Server Agent jobs that execute SSIS packages; ensuring that data is loaded in a timely manner daily
  • Writing and creating data processing/control scripts and stored procedures; ensuring the quality of the data
  • Actively helping our team reconcile data
  • Writing reports for the general business, as requested
  • Working with the team on database design, query tuning, index assignment, and trigger and procedure creation
  • Implementing data models and database designs
  • Supporting the business on data issues

The ideal candidate for this position should meet the following requirements:

  • Excellent communication skills; works well in a team environment
  • Minimum of 5+ years of SQL experience
  • Java Experience is a plus
  • Teradata experience and Microsoft SQL Server experience preferred
  • Ability to write, troubleshoot, and performance tune stored procedures and triggers
  • Ability to reverse engineer and understand code
  • Experience with data warehousing
  • Bachelor’s degree in a technology-related field or equivalent work experience
  • Ability to learn new technical skills easily and troubleshoot data-related issues and errors
  • A solid understanding of relational and dimensional modeling

Specific skills:

  • Teradata experienced highly preferred
  • Stored procedure writing
  • Proven experience writing data loads using stored procedures and SSIS packages
  • Extensive knowledge of ETL techniques, methods and best practices
  • Experience using Metadata driven process development
  • Experience with Pivoting and Un-Pivoting data within stored procedures
  • SQL 2005, SQL 2008, SQL 2012
  • Excellent troubleshooting skills and the ability to reverse engineer in a timely manner
  • Tableau Experience preferred
  • Hadoop Experience preferred