Cerebra Consulting Inc is a System Integrator and IT Services Solution provider with a focus on Big Data, Business Analytics, Cloud Solutions, Amazon Web Services, Salesforce, Oracle EBS, Peoplesoft, Hyperion, Oracle Configurator, Oracle CPQ, Oracle PLM and Custom Application Development. Utilizing solid business experience, industry-specific expertise, and proven methodologies, we consistently deliver measurable results for our customers. Cerebra has partnered with leading enterprise software companies and cloud providers such as Oracle, Salesforce, Amazon and able to leverage these partner relationships to deliver high-quality, end-to-end customer solutions that are targeted to the needs of each customer.
Hello
Please see the details for a Sr. Power BI Data Architect opening we have available for candidates in Radnor, PA.
Location: Radnor, PA
On-site: 5 days per week (no exception)
Duration: 6-12 month contract to hire
Senior Power BI Data Architect
We are seeking a Senior Power BI Data Architect to help lead a large-scale enterprise BI modernization initiative focused on migrating from IBM Cognos to Microsoft Power BI.
This role is ideal for someone who combines deep hands-on Power BI expertise with strong architectural experience across semantic modeling, enterprise data warehousing, cloud platforms, and analytics governance. The ideal candidate will play a critical role in building scalable reporting foundations that support self-service analytics across multiple business domains.
You will partner closely with Data Architects, Engineering teams, and business stakeholders to design and implement modern, high-performing BI solutions in a cloud-based environment.
This role requires a combination of technical depth, strong communication skills, and the ability to partner effectively across engineering, analytics, and business teams.
The ideal candidate is collaborative, solution-oriented, and passionate about building scalable analytics platforms that deliver long-term business value.
Key Responsibilities
- Architect, design, and develop scalable enterprise semantic models to support self-service Power BI analytics
- Partner with Data Architects and ETL teams to ingest, transform, and prepare complex datasets for reporting and analytics consumption
- Design and optimize star schemas, relational models, and enterprise reporting structures
- Develop and maintain high-performance Power BI datasets, dashboards, and reports using advanced DAX and data modeling techniques
- Monitor and optimize Power BI Workspaces and Fabric capacities to ensure scalability, performance, and reliability
- Troubleshoot and resolve report rendering, dataset refresh, and performance bottlenecks
- Establish and enforce enterprise standards, governance policies, and best practices for Power BI development
- Lead initiatives related to metadata management, data lineage, data quality, and reporting documentation
- Collaborate directly with business stakeholders to translate analytical requirements into scalable BI solutions
- Provide technical leadership and mentorship to both IT teams and business users
- Support CI/CD deployment processes and source control best practices across BI environments
Required Qualifications
- 10+ years of overall IT experience, including 5+ years in BI architecture, analytics engineering, or enterprise reporting
- Advanced hands-on experience with Power BI, including:
- Semantic modeling
- DAX
- Power Query
- Performance optimization
- Enterprise reporting architecture
- Fabric capacities
- Strong expertise in relational databases and SQL development, including complex query writing and optimization
- Experience working with cloud-based data warehousing platforms such as Amazon Redshift
- Strong understanding of enterprise data modeling, dimensional modeling, and star schema design
- Experience working within AWS cloud environments and related database services
- Strong understanding of ETL/ELT pipelines and analytics data architecture
- Excellent communication and stakeholder engagement skills with the ability to work across technical and business teams
- Proven ability to work collaboratively within large enterprise environments
- Experience with source control and CI/CD deployment processes using Azure DevOps or similar tools
Preferred Qualifications
- Experience with IBM Cognos architecture or migration initiatives
- Experience with Informatica IDMC Cloud Data Catalog and Governance
- Background supporting enterprise-wide self-service analytics initiatives
- Exposure to data governance, lineage, and enterprise reporting strategy initiatives
Best Regards
Satish Pochampally
Cerebra Consulting Inc
(Ext :- 165) /
