Menu

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

« More Job Listings

At MODintelechy, we are always looking to add top talent to our team. Please send resumes, design or writing samples and salary requirements to [email protected]

No phone calls or walk-ins please! What’s in it for you?

Health Benefits

Health and vision coverage available, because you only get one bod. We encourage stress-relief breaks and even have a hidden garden, library and “chill zone” area to relax, play a board game and get your mind in a flow state.

Flexible Paid Time Off

We offer a flexible time-off policy that allows you to use as you please. We also recognize that life happens and sometimes you just need to work from home. Thus, we offer an allowance for monthly WFH days.

Annual Training and Conference Budget

We’ll pay you to geek out, seriously. Expand your knowledge in your chosen field at a conference or training event, flight tickets and lodging included – within reason, of course.

Unlimited Espresso, Tea, Snack, Beer Bar & Friday Tacos

Never-ending supplies of coffee, tea and snacks, plus free-flowing beer and a cold brew keg. You know, the essentials. Additionally, the breakfast of champions is served every Friday. Taco Deli is our go-to.

Team Outings, Happy Hours and Quarterly Awards

Play together, slay together. Taking half days to celebrate our community or indulge in a little happy hour isn’t out of the ordinary for us. Our award shows take place quarterly and recognize the best of the best around here. No good deed goes unnoticed.

B.Y.O.D. Bring Your Own Dog

This is Austin, we wouldn’t have it any other way.

Dream Office

Decked out with a moody library, hidden garden, beverage nook, spacious kitchen, exercise balls, and more, we’ve made our space the total dream office.