Power BI Analyst — Finance Dashboards (Remote)

United Tech; United States; Teletrabalho; USD 70 000 - 110 000; Tempo integral

Vantagens oferecidas por esta oferta de emprego

Vacation days and leave

100% medical insurance coverage

Sports reimbursement

Team building events and merch

Professional development support

Ukraine-related social initiatives

Resumo da oferta

United Tech is seeking a Power BI Analyst to turn complex financial and operational data into clear dashboards. You will own analytics that connect Microsoft Dynamics 365 and other systems, replacing manual spreadsheet work with automated reporting for finance and cross-functional teams.

Collaborate with senior financial controlling and product stakeholders, build scalable models, implement RLS security, and automate reporting.

Qualificações

• 3+ years of experience as a Power BI Analyst, BI Analyst, or Data Analyst.
• Hands-on experience building dashboards and analytical reporting in Power BI.
• Strong knowledge of Power BI: Power Query, DAX, data modeling, relationships, measures, calculated columns, RLS.
• Understanding of data modeling principles, ETL processes, and system integrations.
• Practical experience automating reporting and optimizing manual processes.
• Strong command of Excel (Power Query, Pivot Tables, Lookup formulas).
• Experience configuring access roles and security models in Power BI.
• Experience documenting analytical solutions, calculation logic, and data sources.
• Basic understanding of SQL for working with and validating data.
• English at Upper-Intermediate level or higher.

Responsabilidades

• Develop and maintain financial and operational dashboards based on data from Microsoft Dynamics 365 and other internal systems.
• Automate management reporting, including P&L, Cash Flow, Balance Sheet, AP/AR Aging, Budget vs Actual, and intercompany reports.
• Build scalable, user-friendly dashboards for monitoring financial, operational, and business metrics.
• Prepare ad-hoc analytics and reports for management and cross-functional teams.
• Design and maintain data integrations between Microsoft Dynamics 365, Excel, and Power BI.
• Develop and optimize complex data models, table relationships, and reporting structures.
• Automate manual reporting processes and reduce reliance on Excel files.
• Set up regular data refreshes and ensure the stability and timeliness of analytical reporting.
• Analyze data quality across ERP and adjacent systems, identify inconsistencies, and support data quality initiatives.
• Configure access roles and security models in Power BI, including RLS/OLS.
• Document report logic, data sources, business rules, and calculations.
• Partner closely with product analysts and business stakeholders to align metrics and unify reporting approaches.
• Independently drive analytical tasks from requirements gathering through to final delivery.

Conhecimentos

Power BI

DAX

Data modeling

SQL

Excel

RLS access control

Analytical thinking

Formação académica

Bachelor's degree in related field

Ferramentas

Power BI Desktop

Power Query

DAX Studio

Descrição da oferta de emprego

United Tech is seeking a Power BI Analyst to turn complex financial and operational data into clear dashboards. You will own analytics that connect Microsoft Dynamics 365 and other systems, replacing manual spreadsheet work with automated reporting for finance and cross-functional teams.

Collaborate with senior financial controlling and product stakeholders, build scalable models, implement RLS security, and automate reporting.