Syneos Health

SSU Operations Analyst II (Power BI/DAX)

Location
Serbia, SRB
Salary
Competitive
Posted
14 Jun 2021
Closes
13 Jul 2021
Ref
21001589
Discipline
Clinical Research
Hours
Full Time
Contract Type
Permanent
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
Technical
  • 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

#LI-GZ1

Disclaimer:

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