Developer - BI

Job Responsibilities

• Experience working with SQL Server Integration Services (SSIS).
• Experienced creating SQL statements, triggers, stored procedures, and data extraction routines to import/export data from the repositories.
• Demonstrates expertise in Query Optimization and Tuning.
• Experience running and supporting large scale database environments (1+ TB size) under high transaction volumes.
• Experience in integration projects involving off-site/on-site environments and database administration in 24x7x365 high traffic internet applications environment.
• Knowledge of database maintenance activities including backups, indexing, integrity, and consistency checking.
• Knowledge in administration of SQL Server database environments (optimization/tuning/backup/recovery), including SQL Server Integration Services, clustering, partitioning, log shipping, replication, and other advanced SQL Server implementations.
• Experience in database development in virtualized environments a plus.
• Strong analytical skills & ability to create and maintain a database environment to support increasingly complex business requirements.
• Experience in Microsoft’s Power Suite (Power BI, Power Pivot, Power Query and Power QA) and SQL Server Reporting Services.
• Experience working with SQL Server Analysis Services (cubes).

Minimum Job Requirements

• BS/BA in Computer Science or equivalent experience.
• 2-4 years’ experience.
• Knowledge of advanced SQL (Stored procedures, triggers, views, indexing, partitioning), MDX, virtual environments, good business acumen, strong customer service and communication skills.
• Ability to multitask and field priorities.