Job Description :
Need i94/PP No for submission


Position Details:
Own the overall technical vision and direction for the databases that support the reporting and analytics capabilities utilizing SQL Server BI Stack.
Create and deploy cubes, write complex database queries, consult with clients on business needs.
Translate business needs into requirements and interface with company to ensure successful delivery of client reporting.
Define the overall data strategy for all development of reports and dashboards.
Drive database design and technical vision for reporting and analytics teams.
Ensure a high degree of data quality by applying industry standards and best practice to design, development, and testing.
Produce detailed documentation of design, development, testing and deployment activities.
Set standards for performance, scalability, and flexibility in a SQL Enterprise environment.
Maintain source/version control for all Business Intelligence components and documentation.
Collaborate with end users to identify needs and opportunities for improved data management and delivery.

Experience Profile:
5+ years designing, building, and maintaining enterprise-scale databases experience
5+ years SQL experience
Experience designing databases to handle millions of records with high performance
Proficient in SSAS, .NET, Database structures, Data Warehouses, Cubes
Data architecture and data analysis
Excellent requirements gathering skills
Proficient Business Intelligence (BI) development experience
Experience using large relational databases for analytical reporting
Experience with data mapping, naming, definition and value assignment best practices
Excellent customer service and interaction skills
Data modeling experience
Ability to design systems from business requirements.
Excellent analytical and problem-solving abilities.
Effective technical writing and documentation skills.
Ability to interpret business requirements into functional and technical requirements.
Knowledgeable of designing workflow/process-based systems
3 years of demonstrated C# and .Net
3 years of demonstrated advance proficiency in development methodologies as lead architect
2+ years of technical lead or management experience.
5+ years of experience in data warehouse architecture and engineering
Advanced expertise with SSIS, SSAS and SSRS
Must be able to manage the end-to-end delivery of data warehousing solutions.
Strong experience building extract, transformation, and load (ETL) processes to convert operational transactional data into dimensions and fact tables
Strong experience developing SSAS Cubes, Dimensions, Facts and data source view SSAS-Data Mining Models, performance tuning or Deploying and Processing SSAS objects
Experience with SSRS using Analysis Services as a data source, passing parameters to drill down reports, working with Charts/Gages, PowerPivot, Deploying Reports, and Administering Security
Education:
BS in Computer Science or related technical subject