PowerBI Architect/Developer

Maximus Partners, LLC; Radnor (Delaware County); On-site; USD 120,000 - 160,000; Full time

Job summary

Maximus Partners, LLC seeks an experienced Architect to design and develop scalable, enterprise-grade semantic models for self-service Power BI analytics in Radnor, PA area.

The role collaborates with Data Architects and ETL teams to ingest, transform and prepare large models for analytics, implement governance, optimize DAX and data modeling, monitor Fabric capacities, and lead BI standards and metadata initiatives across the organization.

Qualifications

• Bachelor’s or Master’s degree in CS/IS/data analytics or related field.
• 5+ years BI architecture and data engineering; 10+ years IT experience.
• Expert Power BI with DAX, Power Query, data modeling and Fabric Capacities.
• Expert SQL across Oracle, PostgreSQL, MySQL, SQL Server, Redshift.
• Expert AWS Cloud architecture and RDS databases.
• Experience with Informatica IDMC Cloud Data Catalog and Governance.
• Strong knowledge of cloud-based data warehousing and ETL/ELT.
• Experience designing large-scale self-service semantic models for diverse users.
• Excellent analytical and communication skills.

Responsibilities

• Architect, design, and develop scalable, enterprise-grade semantic models for Power BI analytics.
• Collaborate with Data Architects and ETL teams to ingest, transform, and prepare semantic models.
• Implement and manage data governance, access controls, and security policies.
• Translate business requirements into effective BI and reporting solutions.
• Ensure Power BI report and dataset performance via data modeling and DAX optimization.
• Monitor Fabric Capacities to ensure efficient solutions.
• Troubleshoot reports and dashboards that render slowly.
• Establish standards and best practices for Power BI development across the organization.
• Lead initiatives around metadata management, data lineage, documentation, and data quality.
• Provide technical leadership and mentorship to IT staff and users.
• Support enterprise reporting strategies, ensuring scalability and reliability.
• Perform other duties as assigned by management.

Skills

BI architecture

Data engineering

Power BI (DAX)

SQL proficiency

AWS cloud & RDS

Data governance

CI/CD with Git/Azure DevOps

Informatica IDMC

Cognos experience

Vibe Coding IDEs

Education

Bachelor's or Master's in CS/IS/Data Analytics or related field

Tools

Power BI

Informatica IDMC

AWS

Git / GitHub / Azure DevOps

SQL (Oracle/PostgreSQL/MySQL/SQL Server/Redshift)

Cognos

Vibe Coding IDEs (AWS Kiro)

Job description

**Must live within a commutable distance to Radnor, PA.

• Architect, design, and develop scalable, enterprise-grade Semantic Models for self-service Power BI analytics.


• Work extensively with Data Architects and ETL Team to ingest, transform, and prepare large and complex Semantic Models for analytics consumption.


• Implement and manage data governance, access controls, and security policies.


• Collaborate closely with business stakeholders to understand analytical requirements and translate them into effective BI and reporting solutions.


• Ensure optimal Power BI report and dataset performance through efficient data modeling, DAX optimization, and query tuning best practices.


• Monitor Workspaces and Fabric Capacities to ensure solutions are efficient and performant.


• Troubleshoot Reports and Dashboards that don't render quickly.


• Establish and enforce standards, guidelines, and best practices for Power BI development across the organization.


• Lead initiatives around metadata management, data lineage, documentation, and data quality assurance.


• Provide technical leadership and mentorship to IT Staff and Business Users.


• Support enterprise reporting strategies, ensuring scalability, reliability, and consistency across analytics platforms.


• Perform other duties as assigned by management.

Minimum Education & Experience Requirements:

• Bachelor’s or Master’s degree in computer science, Information Systems, Data Analytics, or a related discipline (or equivalent practical experience)


• 5+ years of experience in BI architecture and data engineering, with 10+ years of overall IT experience


• Expert-level proficiency in Power BI, including DAX, Power Query, advanced data modeling techniques, and Fabric Capacities


• Expert-level proficiency in relational databases and SQL, including Oracle, Postgresql, MySQL, SQL Server, and Redshift


• Expert-level proficiency in AWS Cloud Architecture, Services, and RDS databases


• Experience with Data Governance tools like Informatica IDMC Cloud Data Catalog and Governance


• Strong understanding of cloud-based data warehousing, analytics platforms, and ETL/ELT processes


• Proven experience designing and managing large-scale self-service Semantic Models for diverse business user communities


• Excellent analytical, problem-solving, and troubleshooting skills


• Strong oral and written communication skills, with the ability to engage effectively with both business and technical stakeholders


• Demonstrated ability to collaborate across cross-functional teams in complex enterprise environments


• Experience with Power BI Source Control and CI/CD Pipeline deployments using Git Repos and Azure DevOps or GitHub


• Experience in IBM Cognos architecture and report development a plus


• Experience with Vibe Coding IDEs like AWS Kiro