Share this Job

Go Back

Data Warehouse/Business Intelligence MS BI (SSIS) Developer loc:Tampa, FL


2016-03-04 13:46:44
Job Type: Full Time only
Budget $: 100,000 - 200,000

  • Design, develop, and deploy Business Intelligence solutions (reports, dashboards, and KPIs) for complex business problemsWork with various executives to understand and document complex financial and strategic business requirements including gathering and understanding requirements, data and ETL design, and database and report developmentAccelerate business productivity via ad-hoc and self-service reporting, dashboards, etc.
  • Work closely with the user community understanding their data reporting requirements, building data marts and data warehouses to service the data analytics and reporting needs of the businessPerform data validation and data profiling on source systemsCreate source to target mappingsDesign and implement ETL flows for the data warehouse
  • Design and implement additions and modifications to the data warehouse data model
  • Design and implement reports based on business requirementsEnsure the quality and accuracy of work done by self and othersBecome a subject matter expert with chosen business intelligence tools and development standards and best practices related to reports and all related objects (Dashboards, Attributes, filters, metrics, facts, prompts, templates, consolidation, and custom groups)
  • Troubleshoot and support all SQL Server reporting and BI related production processingIntegrate with, support, and share responsibilities with internal web, application, and system development effortsPerform any other assigned tasks deemed necessary by management
Desired Skills and ExperienceKnowledge, Skills, and Abilities
  • Minimum of three (3) years of experience with Microsoft SQL/BI technologies, database design, development and administration including MS SQL Server 2008, 2012 (ETL, SSIS, SSRS, SSAS, T-SQL, SQL Agent, PowerShell)Knowledgeable in T-SQL programming, database and application design patterns integral to data integration and data deliveryStrong analytical and problem solving skills with the ability to focus on results, quality and satisfaction
Technical Skills:
  • Databases: MS SQL Server 2014/2014 Azure/2012/2008 R2SQL/Business Intelligence: T-SQL, ETL, SSIS, SSRS, SSAS, Multi-Dimensional Expressions (MDX), Metadata layer development and front-end integration, Team Foundation Server (TFS)/Visual Studio Online.DBA: Backup/Recovery, Data Modeling, Performance TuningOperating Systems: Windows 2008/2012 R2/AzureDesign Tools: SQL Server Management Studio, Visual Studio.NET, Business Intelligence Design StudioLanguages: SQL, C#.NET, VB.NET, ADO.NET, XML, PowerShellAbility to effectively use and operate a PC and standard business applications such as Microsoft Outlook, Word, Excel and PowerPointAdept at change management and release management policies and proceduresKnowledge of ITIL V3 desirableRequires ability to effectively present information to leaders, project committees and customers

Key Skills: