Responsibilities
- Provide both database programming capabilities and analyze complex datasets
- Provide analysis on all data related subjects, from identifying and extracting data, creating both relational and non-relational Data Marts, and drive database requirements
- Be a hands-on programmer who will integrate multiple complex marketing, finance and e-business data sources into easily consumable visualizations and generate marketing insights.
Requirement
- 5 years Data Engineering experience - design, develop, deliver and maintain large-scale and well-documented robust “data marts” to drive data insights.
- 5 years SQL experience - Extensive knowledge and vast experience with SQL Queries (various joins, correlated subqueries, knowledge of recursive queries).
- 5 years Scripting experience in Linux Shell Scripting and Python. Scripting ability to understand and translate scripts written in legacy languages such as Perl.
- 5 years of experience in building reports and visualization using Power BI and Power BI Premium. Experience maintaining and troubleshooting on-premise Data Gateway. Experience with DAX and ability to create appealing visualization for derived datasets
- 3 years of experience working with multiple ERPs (E1, SAP, etc.) and SFDC as main CRM.
- 3 years of extensive Data Modeling experience - Star schema, 3rd Normal form, partitions etc
- Able to troubleshoot the data issues in dashboarding or reporting tools (Power BI, SFDC, Cognos, etc.) and suggest solutions.
- Drives communication, strong communicator, shows initiative, works well with stakeholders.
Preferred
- Someone who has worked in Bio-science/Pharma industry
