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