Requirements
The right individual will be responsible for:
- Build, support, and manage analytical requirements for our customers on the AWS data mgmt suite
- Developing, maintaining, and managing reporting, analytics, and dashboards.
- Performing and documenting data analysis, data validation, and data mapping/design
- Reviewing and improving existing systems and collaborating with teams to integrate with new systems
- Write and edit custom SQL queries to generate customer-facing dashboards and reports in Tableau for both sites and pharma sponsors designed to meet their clinical trial operational needs
- Analyze reporting requests to develop solutions addressing common needs across sites and pharma sponsors practices
- Maintain data catalogue / data dictionary for both internal and external data sets using AWS Glue; Oversee API Catalogue and drive API Roadmap and vision
- Develop database queries to analyze the results and troubleshoot any issues
- Ability to work with ETL tools in an RDBMs and NoSQL environment
- Manage the Tableau solution architecture, administration and actively manage the performance and usability. Align/standardize team members on best practices around Tableau driven implementations
- Some travel may be required
Essential Experience
- Degree in Statistics, Mathematics, Computer Science, Information Systems or Accounting preferred. Or relevant work experience may be considered.
- Minimum 2+ years of experience with Tableau Business Intelligence
- Deep understanding of SQL, relational databases & normalization.
- Analytics experience manipulating large data sets to formulate insights and drive solutions
- Experience with data warehousing tools such as Redshift or Snowflake
- Expertise in developing, maintaining and managing Tableau driven dashboards & analytics, preferably with working knowledge of Tableau administration/architecture
- Proficient in the use of query and reporting analysis tools.