Advarra

Data Analyst IV

Job description

Principal Duties & Responsibilities
  • 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

Please let the company know that you found this position on this Job Board as a way to support us, so we can keep posting cool jobs.