Amplytico ยท 1 month ago
Power BI Lead / Architect
San Francisco Bay Area
Full-time
Hybrid
Senior Level
$125K/yr - $195K/yr
7+ years expAmplytico is a specialized consulting firm helping energy companies transform data into business value. They are seeking an experienced Power BI Lead/Architect to design, develop, and implement sophisticated Power BI solutions for their energy sector clients, while providing technical guidance and translating complex business requirements into actionable insights.
AnalyticsData VisualizationGenerative AIMachine LearningNatural Language ProcessingSoftware
Responsibilities
Lead the architecture, design, and implementation of enterprise-scale Power BI solutions for energy sector clients, including data warehouse integration and multi-source data connections
Architect complex data models using star and snowflake schemas, implementing proper relationship cardinality, and optimizing for performance and usability
Create and maintain sophisticated data models, relationships, measures, and calculated columns using advanced DAX functions and Power Query transformations
Develop row-level security models and implement proper data governance controls to ensure compliance with client data security requirements
Design and implement incremental refresh policies and composite models to optimize performance for large datasets
Develop compelling dashboards and reports with interactive visualizations, drill-through capabilities, and actionable insights tailored to different user personas
Implement Power BI deployment pipelines across development, test, and production environments with proper version control integration
Configure and manage Power BI gateways for secure on-premises data access and scheduled refresh
Establish best practices, governance frameworks, standards, and documentation for Power BI implementation across the organization
Create reusable components, custom visuals, and templates to accelerate development and ensure consistency
Mentor junior team members on Power BI development techniques, advanced DAX concepts, and optimal data modeling methodologies
Lead client workshops to gather requirements and provide technical demonstrations of Power BI capabilities
Collaborate with client stakeholders to understand complex business requirements and translate them into scalable technical solutions with appropriate KPIs
Ensure data quality, security, and performance optimization in all Power BI deliverables through rigorous testing and validation
Troubleshoot and resolve complex performance issues through query optimization, data model refinement, and DAX improvements
Stay current with Power BI platform updates, industry trends, and Microsoft's Power Platform roadmap
Contribute to internal knowledge sharing and thought leadership in business intelligence and data visualization
Qualification
Required
7+ years of experience with Power BI, including architecture, development, and implementation
Strong understanding of data modeling concepts and best practices
Advanced proficiency in DAX, M, and Power Query
Experience with the Power Platform ecosystem (Power Apps, Power Automate)
Familiarity with Azure data services (Azure SQL, Azure Synapse, Azure Data Factory)
Excellent communication skills with the ability to explain complex technical concepts to diverse audiences
Strong problem-solving abilities and attention to detail
Legal authorization to work in the United States
Preferred
Experience in the energy sector strongly preferred
Company
Amplytico
Amplytico provides web analytics, dashboards, and data integration services for product and marketing teams.
51-200 employees
Funding
Current Stage
Growth StageCompany data provided by crunchbase