Job Title: Sr. Business Intelligence Developer
Location: San Jose, CA
Duration: 12+ months
Interview process: Phone+Onsite
The ideal candidate for this role will be working in an autonomous environment while maintaining a close partnership with Sr. level professionals.
The candidate should be able to collaborate with business and BI teams and able to understand/document the requirements, research and analyze the data and convert functional requirements to technical solutions.
The candidate should be able to participate in the development of Business Intelligence solutions to meet the needs of the Commercial Organizations (Finance, CRM, Sales, Sales Operations, Marketing)
The candidate should possess/demonstrate critical attention to detail and must be able to demonstrate expertise in Database development, SQL optimization, building scalable custom ETL solutions
Candidate should be able to re-engineer existing solutions to scalable solutions.
5-7 years of experience as ETL Developer with strong database development skills using PL/pgSQL, PL/SQL
5-7 years of experience in building Data Warehouse and Data Mart solutions
5-7 years of experience in Dimensional Modeling, Star and Snowflake Schemas design and maintaining dimensions using Slowly Changing Dimensions(SCD)
3+ years of experience in scripting using Shell, Python
3+ years of experience in SQL performance tuning and optimization techniques
Domain knowledge in Finance and CRM and products like Salesforce CRM and NetSuite ERP is a plus
- Optimization and Migration
- Experience designing and building Data Mart