Senior Power BI Architect - Enterprise Dashboards

Ascentt

Plano (TX)

Hybrid

USD 120,000 - 180,000

Full time

13 hours ago

Be an early applicant

Application generator

Don’t send a generic resume — generate a resume and cover letter tailored to this exact role.

Get past ATS filters

Job summary

Ascentt is building cutting-edge data analytics & AI/ML solutions for global automotive and manufacturing leaders. We turn enterprise data into real-time decisions using advanced machine learning and GenAI. Our team solves hard engineering problems at scale, with real-world industry impact.

We’re hiring passionate builders to shape the future of industrial intelligence. Ascentt seeks a Senior Power BI Developer in Plano, TX to own enterprise reporting end to end — from stakeholder conversations

Qualifications

Bachelor's or Master's in Computer Science, Information Systems, Analytics, or related field.
8+ years in BI development, including enterprise projects with direct stakeholder engagement.
Proficiency in DAX and Power Query (M).
Row-Level Security and Power BI performance tuning experience.
Advanced SQL — joins, CTEs, subqueries, window functions; able to analyze large existing procedures and functions.
Experience with large datasets in Snowflake, Redshift, BigQuery, Azure Synapse, or SQL Server.
Solid grasp of data modeling and visualization principles; comfortable in Agile teams.

Responsibilities

Build in Power BI: Executive dashboards, interactive reports, KPI scorecards, and paginated reports with complex DAX measures and Power Query transformations.
Govern and secure: Implement Row-Level Security, tune dataset and report performance, and manage workspaces, refresh schedules, and gateway configuration in Power BI Service.
Translate requirements: Meet with business and department leaders, convert needs into technical specs and wireframes, and deliver on an Agile cadence.
Model: Maintain governed semantic layers with certified metrics, conformed dimensions, and hierarchies; support star/snowflake schemas on Snowflake, Databricks, or equivalent.
Write serious SQL: Complex joins, CTEs, window functions, and stored procedures—plus profiling and optimization of slow queries and pipelines.
Validate: Source-to-report reconciliation and regression testing to keep metrics accurate and consistent.
Support Tableau: Dashboards using LOD expressions, table calculations, parameters, and action filters; extract optimization and Tableau Server/Cloud publishing and permissions.
Lead: Mentor junior developers, set BI standards, and document architecture and data lineage.