Sample Job Description for a BI/SQL Developer

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: