BI/SQL Developer

» BI/SQL Developer
Information Technology
in Tampa
, FL
Reference: 19-02019

Main Responsibilities:

  • Enterprise Information Management (EIM)
  • Ad-hoc SQL Development
  • Perform ad-hoc data analysis as needed
  • Extract, Transform & Load (ETL) and Data Integration
  • Participate in solutioning, design and development as needed
  • Including ad-hoc requests
  • Translate source-to-target specifications in to ETL designs and modify as needed
  • Collaborate with data modelers to ensure data models are feasible from an ETL perspective
  • Manage data integration processes (e.g. feeds to 3rd parties)
  • Build process schedules and orchestration
  • Environment administration
  • Ongoing maintenance
  • Management of users, roles, permissions, etc.
  • Performance tuning
  • Monitoring & defect resolution
  • T-SQL (a.k.a “SQL-TL”), SSIS, Informatica
  • Data Architecture
  • Data modeling
  • Prepare logical and physical data models
  • Participate in designs and reviews
  • Information Lifecycle Management (ILM)
  • Design and facilitate archiving strategy and approach
  • Environment  administration
  •  Security
  • Performance Tuning
  • Ongoing maintenance
  • Business Intelligence & Analytics
  • Participate in solutioning, design and development as needed
  • Semantic layer
  • Create business view which will facilitate self-service
  • Dashboards & Reports
  • Train power users to effectively leverage platform

Characteristics of the Ideal Candidate:

  • Autonomous and independent – own solutions from conception to delivery
  • Strong discovery and analysis skills – comprehend complex systems and the business processes they support
  • Creative – offer a fresh and unique solutioning/design perspective, think outside the box
  • Functionally Strong – understand the business context (the “Why”) for solutions being asked to deliver
  • Possesses soft skills – interact with internal customers, eliciting requirements and guiding in the refinement of their vision
  • Aptitude – ability to acquire and apply new knowledge/skills
  • Motivated – value opportunities to contribute and provide value, desire to learn and grow

Skills:

  • SQL
  • ETL
  • Report Development
  • Requirements Gathering
  • Data Warehouse Methodologies