Senior BI & Analytics Developer

Armanino; San Ramon (CA); On-site; USD 118,800 - 161,800; Full time

Benefits offered by this job

Medical, dental, vision

Generous PTO plan and paid sick time

Flexible work arrangements

401K with Profit Sharing

Wellness program

Generous parental leave

11 paid holidays

Job summary

Armanino in San Ramon is looking for a skilled data analyst to bridge analytics needs and warehouse implementation. You will work with data modeling using Microsoft Fabric and Power BI, providing insights to stakeholders.

The ideal candidate should possess 3–5+ years of relevant experience and strong skills in SQL and Python. Benefits include generous PTO, flexible work arrangements, and health coverage.

Qualifications

• 3–5+ years experience in analytics, BI, data engineering, or a related field.
• Strong hands‑on experience with Microsoft Fabric, Power BI, SQL, and Python.
• Solid understanding of dimensional modeling, fact vs dimension design, and governance-friendly model design.

Responsibilities

• Serve as a technical bridge between analytics needs and warehouse implementation.
• Design and maintain Power BI semantic models.
• Act as an analytics partner to stakeholders and facilitate sessions.
• Follow and contribute to established modeling patterns and governance standards.

Skills

Microsoft Fabric

Power BI

SQL

Python

Education

3–5+ years experience in analytics or related field

Tools

DAX

PySpark

Job description

At Armanino, you determine your career path. This means it's possible to pursue challenges you are passionate about, in industries you care about.

Armanino is proud to be Among the top 20 Largest Accounting and Consulting Firms in the Nation and one of Best Places to Work. We have a community of resources that are ready and willing to support your ideas, build your skills and expand your professional network. We want you to integrate all aspects of your life with your career. At Armanino, we know you don’t check-out of life when you check-in at work. That’s why we’ve created a unique work environment where your passions, work, and family & friends can overlap. We want to help you achieve growth by giving you access to a network of smart and supportive people, willing to listen to your ideas.

Job Responsibilities

Hands‑On Fabric & Transformation Work

• Serve as a technical bridge between analytics needs and warehouse implementation decisions, working closely with the Data Warehousing team to design and implement data models in Microsoft Fabric.
• Contribute directly to data model development (SQL / Python), building and maintaining Fabric notebooks for transformations, enrichment, and business logic.
• Validate data outputs, logic correctness, and alignment with business rules before models are surfaced for reporting.
• Partner on refresh sequencing, dependencies, and data readiness for analytics consumption.

Semantic Modeling & Power BI Enablement

• Design and maintain Power BI semantic models on top of curated Fabric tables, ensuring models follow best practices for:
• Schema design
• Reusability across reports
• Clear metric definitions and transparency
• Support the shift from reporting to insights, enabling enhanced and efficient self‑service capabilities to end users.

Stakeholder Translation & Collaboration

• Act as an analytics partner to stakeholders submitting reporting and data requests, translating business questions into actionable information.
• Facilitate working sessions between stakeholders and technical teams to align on definitions, assumptions, and outputs.

Process, Standards & Change Management

• Follow and contribute to established modeling patterns, naming conventions, and governance standards.
• Use Git for version control, peer review, and controlled changes.
• Help test, validate, and document changes before they are released to production.
• Support continuous improvement of analytics processes, handoffs, and communication between teams.

Requirements

• 3–5+ years experience in analytics, BI, data engineering, or a related field.
• Strong hands‑on experience with:
• Microsoft Fabric (Lakehouse/Warehouse, notebooks, pipelines)
• Power BI (semantic models, datasets, basic DAX)
• SQL (advanced querying, transformations, performance considerations)
• Python for data transformation (ideally PySpark)
• Solid understanding of:
• Dimensional modeling
• Fact vs dimension design
• Slowly changing dimensions
• Governance‑friendly model design

Armanino provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability or genetics. In addition to federal law requirements, Armanino complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.

Armanino expressly prohibits any form of workplace harassment based on race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, genetic information, disability, or veteran status. Improper interference with the ability of Armanino employees to perform their job duties may result in discipline up to and including discharge.

Armanino does not accept unsolicited candidates, referrals, or resumes from any staffing agency, recruiting service, sourcing entity, or third‑party paid service at any time. Any referrals, resumes, or candidates submitted to Armanino or any employee or owner of Armanino without a pre‑existing agreement signed by both parties covering the submission will be considered the property of Armanino and not subject to any fees or charges. For existing agreements, a role must be approved and open to external search; otherwise, unsolicited and unapproved submittals and referrals will be considered Armanino property and free of fees. In addition, Talent Acquisition is the sole point of contact, and contacting others in our organization without Talent Acquisition’s knowledge will result in termination of contract.

Certain states require us to disclose the pay range and benefits summary for job openings. The compensation range for Colorado is $103,300 – $140,700. The compensation range for Southern California, New York, Washington, and Illinois is $113,600 – $154,800. The compensation range for Northern California is $118,800 – $161,800. Compensation may vary based on skills, role, and location. Eligible employees at certain levels can participate in a discretionary long‑term financial incentive plan, subject to plan participation rules.

Armanino has a robust offering of benefits, including:

• Medical, dental, vision
• Generous PTO plan and paid sick time
• Flexible work arrangements
• 401K with Profit Sharing
• Wellness program
• Generous parental leave
• 11 paid holidays

For positions based in San Francisco, consistent with the SF Fair Chance Ordinance, an arrest and conviction record will not automatically disqualify a qualified applicant from consideration.

For Individuals who would be working within the City of Los Angeles, Armanino will consider for employment all qualified applicants, including those with criminal histories, in a manner consistent with the requirements of applicable state and local laws, including the City of Los Angeles’ Fair Chance Initiative for Hiring Ordinance.

To view our Consumer Notice at Collection for job applicants, please visit: https://www.armanino.com/terms/ccpa-employee-notice/