Call us 24/7 - 1-800-461-8898

Business Intelligence/SQL Developer

SmartPak seeks talented, independent thinkers who understand the power of collaboration and imagination – people who thrive in a hard-working and fun corporate culture. You must be able to work independently and communicate your ideas quickly and clearly.


Position Summary

The BI/SQL Developer using Microsoft’s BI Stack will be responsible for identifying and implementing Business Intelligence (BI) solutions which will provide or improve the company’s various analysis needs. Working under the DBA, who is also our data architect, this role will work closely with business users to identify requirements and formulate business intelligence solutions.


Essential Job Functions

  • Works with disparate data sources to develop and implement business intelligence solutions
  • Creates Extract, Transform, & Load (ETL) procedures to load the Enterprise Data Warehouse (EDW)
  • Support EDW and Microsoft SQL Server Analysis Services, both Multi-dimensional and Tabular
  • Handles Ad-Hoc requests as they arise
  • Support Business Analyst community on data analytics as needed
  • Backup the Database Administrator (DBA)
  • Multi-tasks across approved projects
  • Creates/Maintains technical documentation
  • Identifies areas for improvement in performance, efficiency, and consolidation
  • Report progress on development at daily stand-ups and escalate issues or slippage in a timely fashion, identifying remedial action to keep the project on track
  • Analyze problems from a practical point of view and evaluate ideas and suggestions so that the team can make balanced decisions
  • Identify critical activities & tasks on projects, help with estimation and planning, ensure timely and accurate communication of status, resolution of issues, and contribute beyond assigned tasks – adjusting priorities when appropriate
  • Contribute to project success by providing ideas, strategies, improving communication among team members and executing decisionsQualifications
  • Three years working with Business Intelligence technologies
  • Three years working with Microsoft SQL Server 2012+
  • Bachelor’s Degree in Computer Science or related field of study
  • Excellent T-SQL skills including stored procedures, functions, triggers & views
  • Excellent table schema design
  • Experience with the Microsoft BI Stack (SQL Server SSMS, SSRS, SSIS, & SSAS)
  • Extensive knowledge of indexing, query optimization and other performance tuning techniques
  • Experience with SSRS on SQL Server 2012+
  • Experience with SharePoint Enterprise 2013+ and Performance Point
  • Experience with Power Pivot
  • Experience in troubleshooting and resolving database problems.
  • Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler, Extended Events and other related monitoring and troubleshooting tools
  • Ability to work well with others and understand business process
  • Excellent business communication, writing and interpersonal skills
  • A passion for well-architected, reusable solutions
  • An inquisitive mind
  • Desire to continuously improve
  • Superb planning & organization skills
  • Ability to make independent, reliable decisions
  • Ambitious, a highly-driven self-starter, with a strong desire to challenge and deliver
  • Adaptable and flexible working style, remaining calm under pressure, and adjusting comfortably to changing conditions and priorities
  • A passion for high quality standards, and execution through sound processes
  • A superior work ethic
  • Prefer experience with Agile development practices
  • Prefer experience with Pragmatic Works Task Factory

Apply Here!

Posted in Jobs

Recent Posts

Leave a Reply

Your email address will not be published. Required fields are marked *


Share it:
SmartPak is an Official partner of AQHA.
Members save 5% off all purchases.
You'll this

SmartCombo™ Senior Pellets

As Low As: $57.95
(250 reviews)
Healthy Horses  ❤  Happy Riders