Senior BI Engineer: Power BI, SQL & Data Modeling Lead

Risus Talent Partners LLC; Newtown Square (Delaware County); On-site; USD 120,000 - 150,000; Full time

Job summary

Risus Talent Partners LLC is seeking a Senior Business Intelligence Engineer to join our growing Data & Analytics team in Newtown Square, PA. This hands-on role requires turning business needs into scalable data and reporting solutions, with expert SQL and strong experience in modern data environments.

You'll design data models, build transformations with dbt, develop Power BI dashboards, and partner with stakeholders to translate operational needs into technical solutions, while ensuring data

Qualifications

• 4+ years of experience in BI, Analytics Engineering, Data Engineering, or similar role.
• Hands-on experience with dbt or similar data transformation tools.
• Strong experience with Power BI and working knowledge of DAX.
• Experience with modern data platforms such as Snowflake, Postgres, or SQL Server.
• Strong understanding of data modeling and data warehousing concepts.
• Experience with data pipelines and ELT processes.

Responsibilities

• Design, build, and maintain scalable data models and reporting solutions.
• Write and optimize complex SQL queries.
• Build data transformations using dbt.
• Develop dashboards, KPIs, and reporting solutions in Power BI.
• Work with cloud data warehouses and multiple enterprise data sources.
• Support data pipelines, ELT processes, and data quality initiatives.
• Troubleshoot issues across pipelines, models, queries, and reporting layers.
• Partner with business stakeholders to translate operational needs into technical solutions.
• Support reporting and analytics projects around operational efficiency, on-time delivery, inbound analysis, KPI development, and more.
• Leverage AI tools to improve productivity and enhance data products while critically evaluating and validating outputs.

Skills

SQL

Data modeling

Analytical thinking

Problem solving

Independent work

Tools

dbt

Power BI

DAX

Snowflake

Postgres

SQL Server

Job description

Risus Talent Partners LLC is seeking a Senior Business Intelligence Engineer to join our growing Data & Analytics team in Newtown Square, PA. This hands-on role requires turning business needs into scalable data and reporting solutions, with expert SQL and strong experience in modern data environments.

You'll design data models, build transformations with dbt, develop Power BI dashboards, and partner with stakeholders to translate operational needs into technical solutions, while ensuring data