Data Analyst II
About The Position
The Data Analyst II, depending on applicant skill level, could become a Senior Data Analyst. The position analyzes quantitative and qualitative administrative and operational data supporting scientific research initiatives within the Scientific Director's Office. It combines data analytics expertise with solutions engineering, including development of dashboards, automated reporting systems, and custom Power Platform applications with AI capabilities. Under guidance from senior staff, the role supports data-driven decision-making by building analytics tools, assisting with team training and adoption, and translating data into actionable insights. The position works with data pipelines, ETL processes, data models, governance standards, enterprise reporting, and cloud analytics platforms to support the quality, integrity, security, and availability of data. It also evaluates emerging data, AI, and low-code technologies and collaborates with IT and cross-functional stakeholders to integrate scalable solutions with enterprise systems. Regular and predictable attendance is required; other related duties may be assigned to meet department and institutional goals.
Requirements
- Bachelor's degree in computer science, data science, information science, business, or a related field.
- At least 2 years of IT experience designing databases and ETL processes, preferably in a comparable industry.
- Proficiency with Microsoft Power Platform, Power BI, SQL, data modeling, ETL, and cloud analytics platforms such as Microsoft Fabric, Databricks, or Azure.
- Ability to build low-code, web-based, and enterprise-integrated solutions supporting data access, reporting, and workflow needs.
- Working knowledge of AI/ML tools such as Copilot or Azure AI and ability to embed them in analytics, automation, and business applications.
- Strong analytical thinking, critical reasoning, data visualization, and data storytelling skills to connect insights to business outcomes.
- Clear communication, training, documentation, collaboration, prioritization, and accountability skills to support technical and non-technical stakeholders.
- Experience with programming and querying languages.
- Some experience with enterprise reporting tools for report development, as applicable.
- Some experience creating dashboards with data visualization tools such as Power BI, Tableau, or Qlik, and with data warehousing applications, as applicable.
- Proven performance in an earlier or comparable role.
Nice To Haves
- Master's degree.
- Three years of IT experience in data analytics, business intelligence, or solutions development, preferably in healthcare, research, or a comparable industry.
- Experience with SDLC methods such as Agile, Waterfall, or CI/CD.
- Experience with Microsoft Power Platform, enterprise reporting, dashboards, cloud data platforms, data engineering, SQL, AI/ML integration, or SharePoint development or integration.
- Microsoft certifications in Power Platform, Databricks, or related technologies.
Responsibilities
- Design and maintain dashboards, reports, data visualizations, and analytics tools using Power BI, Microsoft Fabric, and related platforms to support research operations and administrative decision-making.
- Build Power Platform and low-code solutions with AI-enabled workflow automation to improve reporting, operational efficiency, and decision support.
- Develop and maintain data pipelines, ETL processes, data models, and governance standards using Databricks, SQL, Microsoft Fabric, and other enterprise data tools to ensure data quality, integrity, security, and availability.
- Translate scientific and administrative needs into technical specifications, predictive analytics, and AI/ML-enabled solutions with guidance from senior analysts.
- Support training, adoption, documentation, user guidance, and knowledge transfer for analytics tools and decision-support systems.
- Evaluate emerging data, AI, and low-code technologies and collaborate with IT and cross-functional stakeholders to integrate scalable Scientific Director's Office solutions with enterprise systems.
- Maintain regular and predictable attendance.
- Perform other related duties as assigned to meet department and institutional goals.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
