Lead the implementation of the Snowflake Datawarehouse
Build data pipeline to ingest large volume of data from both internal applications and external data source
Provide data for Enablement of BI/ Analytics, Data Sciences, and external customers
Supports MDM implementation plan and direction toward a single version of
Create, follow, and ensure compliance with database security
Provide technical recommendations for reporting infrastructure project costing
Design, maintain and deploy data sources for operational and strategic dashboards
Education
Bachelor’s degree or equivalent combination of education and related work experience
Snowflake certification preferred
Experience
10+ years of relevant experience in managing and implementing an enterprise data warehouse; Green field Datawarehouse implementation experience is a plus
Snowflake implementation experience
Experience in migrating data from on-premise transactional system to cloud data warehouse
Data Architecture & Data modeling experience in Clinical trials domain / Life Sciences
Knowledge of data management tools and process; Data governance tools is a plus
Hands-on experience with BI solutions (e.g. PowerBI, Tableau, Sisense or other format for reporting)
Working experience with version control platforms, e.g. Git, and agile methodologies and supporting tools (e.g. Jira)
Skills
Advanced SQL query skills such as complex joins, sub-queries, grouping, aggregation, as well as stored procedures
Programming languages, especially Python and Java
Knowledge of data modeling and transformation tools like Trifacta, Tableau data prep
Expert in data warehousing concepts, methodologies, and best practices