Create, maintain and evolve Power BI dashboards to support client data analysis and the native modules of the Moderna system.
Build and maintain Power BI dashboards for clients and for native use within the Moderna system.
Gather reporting and KPI requirements from internal teams and clients.
Process, organize and validate data used in dashboards, reports and migrations.
Support data migration processes between systems by analyzing datasets, files and received structures.
Map fields between the source system and the Moderna system.
Perform checks before and after data imports, identifying inconsistencies, duplicates and errors.
Create basic SQL queries for extraction, validation and cross-referencing of information.
Support implementation, support, product and development teams with data-related requests.
Desired experience with Power BI, Excel, Power Query, basic SQL and handling CSV/Excel files.
Requirements
Basic to intermediate knowledge of Power BI, including creating dashboards, reports, filters and KPIs.
Knowledge of Excel, including formulas, pivot tables, filters, validations and data handling.
Basic understanding of SQL, especially queries, filters, joins, aggregations and validating information in databases.
Basic knowledge of Power Query for data transformation, cleaning and organization.
Familiarity with DAX for creating measures, calculated columns and metrics in Power BI.
Ability to work with CSV, Excel, TXT files and datasets exported from other systems.
Ability to analyze data, identify inconsistencies, duplicates, missing required fields and discrepancies.
Preferred technical course or degree in progress/completed in Systems Analysis, Data Science, Information Systems, Business Administration, Statistics or related fields.
Desired knowledge of ETL, data modeling, relational databases and system integration.
Nice to have: courses or certifications in Power BI, advanced Excel, SQL, Databases, Data Science or Microsoft PL-300.
Tech Stack
ETL
SQL
Benefits
Meal and food allowances
Health insurance
Life insurance
Dental plan
Birthday day off
Transportation allowance
Corporate university (IPED / Allura): Free corporate education platform
Certification incentive: Additional compensation for each certification obtained, according to company policy
Education assistance: Reimbursement of up to 50% for postgraduate or MBA programs
Marriage assistance
Childcare assistance for children up to 5 years old