Senior ETL Developer

As a BI ETL Developer, you’ll be responsible for designing data solutions, optimizing our data pipeline architecture, as well as developing infrastructure for data collection to support cross functional teams in the BI & Analytics Organization. You will also contribute towards building reports, dashboards and analytics for the entire organization including Product, Pricing, Finance, Sales and Marketing Teams. Your ability to creatively collaborate and execute team goals will affect scalability and directly contribute to the company growth and profitability.  

Responsibilities 

• Plan, design, develop, test, implement, and maintain BI ETL pipeline in DWH environment.
• Build the data model for optimal extraction, transformation, and loading of data from a wide variety of data sources.
• Analyze source data using complex SQL queries to come up with best possible data model design and development. 
• Debug and tune ETLs, reports and dashboards by analyzing relevant SQL queries. 
• Optimize data systems to support our data initiatives, increase operational efficiency, improve collaboration and knowledge sharing.
• Gather, analyze, and document business requirements and translate into technical specifications, prototypes, and end state products.
• Work closely with Executive Management, Software Engineers, Data Engineers, Quality Engineers, and various cross functional team members to design, build, test, and maintain analytics solutions.

Requirements  

• 4-7 years of proven experience in Data Warehousing, ETL and Business Intelligence. 
• Highly proficient in data analysis and troubleshooting skills with ability to write complex SQL queries. 
• Advanced SQL knowledge and in-depth ETL development experience.
• Strong knowledge of Data Warehousing and Multidimensional Data Modeling.
• Tableau or other reporting tool experience preferred.
• Cloud based DWH & ETL Tool experience good to have
• Strong ability to multi-task and meet deadlines. 
• Excellent verbal and written communication skills. 
• Work independently and self-learning without much guidance. 
• Experience in gathering and understanding requirements from executive management.    
• A successful history of integrating source systems and delivering self-serve Business Intelligence.

Education:

• BE, B.Tech, MCA in Computer Science, Engineering, Information Technology/Systems or another related discipline. Additional technical certifications are a plus.