Research Modernization - Business Intelligence Developer

Job Responsibilities

• Design, develop, and maintain interactive dashboards and visualizations using Amazon QuickSight.
• Write and optimize complex SQL queries involving multiple joins and large datasets across RDBMS platforms.
• Use Python to transform, clean, and manipulate data for reporting and analytics purposes.
• Partner with stakeholders to gather requirements and translate them into actionable BI solutions.
• Ensure data accuracy, consistency, and performance across dashboards and underlying data pipelines.
• Monitor and troubleshoot dashboard/report performance issues, optimizing queries and data models as needed.
• Document data sources, query logic, and dashboard specifications for maintainability.

• Collaborate with engineering teams to ensure data availability and quality for BI use cases.

• 1 year of minimum experience in building Business Intelligence applications
• Strong knowledge of RDBMS (e.g., MySQL, PostgreSQL, Oracle, SQL Server) with demonstrated ability to write complex queries involving large volumes of data and multiple joins.
• Proficiency in Python for data transformation, manipulation, and automation (e.g., pandas, NumPy).
• Solid understanding of data modeling and BI best practices.
• Strong analytical and problem-solving skills with attention to detail.
• Ability to communicate technical findings clearly to non-technical stakeholders.

Preferred Qualifications

• Experience with AWS data services (e.g., Redshift, Athena, S3, Glue).
• Familiarity with data warehousing concepts and ETL pipelines.
• Proven experience building dashboards and reports in Amazon QuickSight (or similar BI tools, with QuickSight preferred).