Data Analyst (Power BI & Data Modeling)
J
JobgetherFinancial services
Fully remote position for candidates based in the United States.Full-Time
Salary not disclosed
Apply NowOpens the employer's application page
Job Details
- Required Skills
- PostgreSQLPythonSQLMicrosoft Power BI
Requirements
- Bachelor's degree or international equivalent is required.
- Demonstrated experience designing and maintaining Power BI reports and dashboards.
- Practical knowledge of DAX for creating and maintaining measures and calculations.
- Practical knowledge of Power Query (M) for transforming and preparing data for reporting.
- Experience administering Power BI, including refresh schedules, gateways, row-level security, workspaces, and publishing workflows.
- Experience designing dimensional and star-schema data models, including fact and dimension tables, relationships, granularity, and semantic models.
- Strong SQL skills, including writing and optimizing queries with joins, aggregations, and window functions against relational databases.
- Experience validating data, reconciling reported figures against source systems, and investigating data-quality issues.
- Ability to define consistent metrics and maintain documentation such as data dictionaries and report catalogs.
- Ability to translate unclear business questions into measurable KPIs and actionable insights.
- Communication and presentation skills for explaining data and analytical findings to non-technical audiences.
- Preferred: experience in finance or financial services, including revenue, cost, billing, AML, or compliance data.
- Preferred: familiarity with Azure Databricks and Spark SQL; Python for data analysis; Git and version control; or large-scale or regulated datasets.
Responsibilities
- Build, publish, and maintain Power BI dashboards and reports for business, operational, and leadership stakeholders.
- Develop self-service reporting solutions that make reliable data and key performance indicators accessible.
- Manage Power BI workspaces, publishing processes, refresh schedules, data gateways, and row-level security.
- Design and maintain dimensional and semantic data models using star-schema architecture, including fact and dimension tables.
- Create and maintain DAX measures and Power Query (M) transformations, documenting calculations and business definitions.
- Work with Azure Databricks, SQL, and PostgreSQL sources to build clean, reusable datasets.
- Reconcile reported figures against source systems and investigate discrepancies and data-quality issues.
- Maintain a data dictionary and report catalog, and establish consistent business metric definitions.
- Translate business questions into metrics and KPIs, produce ad hoc analysis, and present findings to non-technical stakeholders.
- Support month-end and other periodic reporting cycles.
View Full Description & ApplyYou'll be redirected to the employer's site