Senior BI Developer (Data Warehouse Analyst)

  • El Segundo, CA
  • Contract

Company Description

As a Freelance recruiter, catering all my fortune 1000 clients to find the right match for their staffing needs in IT & Non IT technologies. Catering the clients of various industries like IT services, Telecom, Helath care services & Products, Insurance, Banking, Finance, Auto, etc. Share your resume to me,  will must come to you with a match job for you of your interest.

Job Description

The responsibilities of the job include, but are not limited to:
 Author and publish reports in SQL Server 2008 R2 Reporting Services
 Complete ad hoc report requests from business stakeholders leveraging necessary BI tools
 Develop and support the SQL Server 2008 R2 data warehouse by creating tables, indexes, views, indexed views, functions, triggers, stored procedures, and tuning complex T-SQL queries
 Build and manage ETL routines with SSIS (SQL Server Integration Services) and SQL Server Agent jobs
 Design and implement SQL Server 2008 R2 Analysis Services multi-dimensional cubes
 Identify inefficiencies and gaps in current data warehousing and reporting solutions
 Create and maintain documentation on data warehouse processes and procedures


The ideal Candidate will possess qualifications and technical knowledge in the following areas:
 Data Warehouse Relational Database Design
SQL Server VLDB (5TB+) physical database design, administration and maintenance
 Database storage design using SAN-based high-performance disk arrays

High-performance, intraday data warehouse loading from multiple sources using SQL Server Integration Services
 Automation via scripting tools such as PowerShell (in addition to T-SQL)
 Advanced performance tuning techniques for complex report generation
 Advanced job scheduling and monitoring automation

Additionally, experience in the following is a plus:
 Report development and delivery using SQL Server Reporting Services and Report Builder
 SQL Server Analysis Services development and administration
 Development and deployment of data maintenance interfaces utilizing Microsoft technologies
 .NET-based CLR function or standalone application development (either VB or C#)
 Master Data Management or Data Quality Services implementations
 Advanced understanding of data warehouse design theory including logical and physical modeling
 Financial accounting reporting and marketing campaign performance reporting

Additional Information

Sanjay Kumar

Freelance Recruiter