This is a remote role in the USA.
Job Qualifications:
- Bachelor’s degree or international equivalent is required.
- Power BI report and dashboard design, including DAX measures, Power Query (M), data refresh and gateway setup, row-level security, and workspace / publishing management.
- Dimensional / star-schema data modeling: fact and dimension design, managing granularity and relationships, and building semantic models for self-service reporting.
- Strong SQL: writing and optimizing queries (joins, aggregations, window functions) against relational sources.
- Strong analytical mindset: translating ambiguous business questions into metrics, validating data, and presenting clear findings to non-technical stakeholders.
- Data quality and documentation: reconciling figures to source, defining measures consistently, and maintaining a data dictionary.
- Effective communication and presentation skills; self-starting, detail-oriented, and able to work both independently and as part of a team.
- Finance / financial-services domain experience (reading revenue, cost, billing, or AML / compliance data) preferred.
- Databricks / Spark SQL, Python for analysis, and Git version control preferred.
- Experience working with large or regulated datasets preferred.
Job Responsibilities:
- Build and maintain Power BI dashboards and reports for business, operations, and leadership stakeholders.
- Design and maintain dimensional / semantic data models (star schema — facts and dimensions) that power self-service reporting.
- Author and maintain DAX measures and Power Query (M) transformations with consistent, documented definitions.
- Reconcile reported figures back to source systems and resolve data-quality issues before they reach reports.
- Gather requirements from stakeholders and translate ambiguous business questions into clear metrics and KPIs.
- Produce ad hoc analysis to answer specific business and operational questions.
- Maintain a data dictionary and report catalog; configure refresh schedules, gateways, and row-level security.
- Support month-end and periodic reporting cycles.