Syneos Health

SSU Operations Analyst II (Power BI/DAX)

Serbia, SRB
14 Jun 2021
13 Jul 2021
Clinical Research
Full Time
Contract Type
Experience Level
Experienced (non-manager)
Provides support to Site Start-Up (SSU) operational and financial processes, data reporting, and metrics. Assists in the conduct of operational and financial functions supporting global SSU operations. Compiles and disseminates standard and specific reports on SSU business unit performance. Enters and extracts data from standard Company information systems. Responds to requests for information, performs other tasks as designated and proactively addresses emerging requirements.

Essential Functions:
  • Develop reporting specifications in collaboration with stakeholders
  • Gap/feasibility analysis of datalake/Activate database, developing solutions and suggestion improvements or alternatives
  • Develop sematic data model to power reports, using SQL, PowerQuery and/or DAX
  • Develop and release Tableau or Power BI report
  • Maintain and release reports
  • Iterate and optimize data models/reports
  • Ad hoc analysis via SQL and/or excel
  • Excel
    • Index/Match, vLookup
    • Array formula
  • SQL
    • Joins
    • CTEs
  • Power BI/DAX
    • Data modelling
      • Star schemas
      • Cardinality
    • Measures
      • Filter context
      • Context Transition
      • Active/inactive relationships
      • Disconnected tables
      • Calculation groups
    • Tools
      • DAX studio
      • Tabular editor
    • Certification
      • Microsoft Certified Data Analyst (DA-100) (nice to have)
      • Or 70-788



Tasks, duties, and responsibilities as listed in this job description are not exhaustive. The Company, at its sole discretion and with no prior notice, may assign other tasks, duties, and job responsibilities. Equivalent experience, skills, and/or education will also be considered so qualifications of incumbents may differ from those listed in the Job Description. The Company, at its sole discretion, will determine what constitutes as equivalent to the qualifications described above. Further, nothing contained herein should be construed to create an employment contract. Occasionally, required skills/experiences for jobs are expressed in brief terms. Any language contained herein is intended to fully comply with all obligations imposed by the legislation of each country in which it operates, including the implementation of the EU Equality Directive, in relation to the recruitment and employment of its employees.

Similar jobs

Similar jobs