Senior Power BI Analyst

Wilson Sonsini is the premier legal advisor to technology, life sciences, and other growth enterprises worldwide. We represent companies at every stage of development, from entrepreneurial start-ups to multibillion-dollar global corporations, as well as the venture firms, private equity firms, and investment banks that finance and advise them. The firm has approximately 1,100 attorneys in 17 offices: 13 in the U.S., two in China, and two in Europe. Our broad spectrum of practices and entrepreneurial spirit allow our staff exceptional opportunities for professional achievement and career growth.

We are seeking a Senior Power BI Analyst to join the Finance Technology team at the firm. This position is available as a hybrid work schedule.

Essential Duties and Responsibilities:

• Power BI Development: Design, develop, and maintain advanced Power BI reports, dashboards, and data models that meet the needs of various stakeholders.
• Data Integration: Extract, transform, and load (ETL) data from various sources into Power BI, ensuring data accuracy and consistency.
• SQL Expertise: Utilize strong SQL skills to query and manipulate data from databases and other sources to support reporting requirements.
• SSRS Reports: Develop and enhance SSRS (SQL Server Reporting Services) reports to complement Power BI solutions when necessary.
• Data Modeling: Create and optimize data models in Power BI to ensure efficient data analysis and visualization.
• Mentorship: Act as a mentor to junior developers and analysts, providing guidance and training in Power BI best practices.
• Lead Implementation: Lead the end-to-end implementation of Power BI projects, from requirements gathering to deployment, ensuring successful outcomes.
• Performance Optimization: Identify and implement performance improvements in existing Power BI solutions to enhance efficiency and user experience.
• Collaboration: Collaborate with cross-functional teams to understand business requirements and translate them into effective Power BI solutions.
• Stay Current: Stay up-to-date with the latest Power BI features, trends, and best practices, and apply them to improve our reporting capabilities.

Education and/or Work Experience Requirements:

• Bachelor’s degree in Computer Science, Information Technology, or a related field (Master’s preferred).
• 6 years of proven experience as a Power BI Developer, with a strong portfolio of Power BI reports and dashboards.
• Expertise in SQL for data extraction and manipulation.
• Proficiency in SSRS (SQL Server Reporting Services).
• Strong data modeling skills.
• Excellent problem-solving and analytical abilities.
• Effective communication and mentoring skills.
• Experience leading and managing Power BI projects.
• Certifications in Power BI are a plus.

The primary location for this job posting is in Palo Alto, but other locations may be listed. The actual base pay offered will depend upon a variety of factors, including but not limited to the selected candidate’s qualifications, years of relevant experience, level of education, professional certifications and licenses, and work location. The anticipated pay range for this position is as follows:

San Francisco and Silicon Valley: $116,875 – $158,125 per year

The compensation for this position may include a discretionary year-end merit bonus based on performance. We offer a highly competitive salary and benefits package.

Equal Opportunity Employer (EOE).