We are seeking a Data Analyst (Power BI & Data Modeling) to own the design, build, and maintenance of our Power BI reporting and the underlying data models that turn platform and business data into decisions. Working across the data platform (Azure Databricks / SQL / Postgres sources), you will model clean, well-documented datasets and deliver self-service dashboards, KPIs, and ad hoc analysis for business and operations stakeholders. This role is the dedicated owner of trustworthy self-service reporting and a single, consistent definition of key metrics across the business - enabling faster, data-driven decisions and reducing the ad hoc reporting burden currently carried by engineers and analysts.
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.