Business Intelligence Data Analyst II

Advarra is a leader in clinical research, dedicated to advancing human health through innovative technology solutions. The Business Intelligence Data Analyst II role involves supporting the Analytics and Reporting team by delivering insights, managing data structures, and collaborating with various teams to optimize reporting and analytics processes.

Responsibilities:

• Understand and optimize data structure to drive consistent data capture and reporting
• Lead situations where new data modeling is required to support the business
• Follow best practice as defined by Data Engineering to support Business Intelligence needs
• Drive collaboration with identification of required individuals necessary for identified resolutions
• Work with Business and Product Management team to ensure appropriate requirements are captured and documented
• Support the architect of solutions to support analytics needs
• Understanding of on all development in process, regardless of team ownership, for appropriate tracking and project updates
• Participate in release management and deployment, where necessary
• Monitor data feeds and engage with Data Engineering to resolve issues

Requirements:

• Bachelor's Degree in Data Science, Information Science or related area of experience
• 2-4 years of experience with a focus on SQL coding, system and data feed monitoring, and data validation
• Excel – advanced
• Snowflake – advanced
• Databricks – advanced
• SQL – advanced
• DBT
• Github
• Presentation skills – advanced
• Business analysis skills – advanced
• Demonstrated proficiency in making effective, well-reasoned decisions
• Demonstrated proficiency in end user requirements gathering
• Ability to work on cross-functional teams
• Excellent attention to detail and time management skills, proven ability to adapt and navigate change
• Ability to quickly learn new technologies and systems
• Python, JSON, HTML, and other coding experience