Logo
TrustedTech

Data Analyst / BI Developer

TrustedTech, Irvine, California, United States, 92620

Save Job

Who We Are: TrustedTech is a leading Microsoft Cloud Solution Provider (CSP) specializing in Microsoft Cloud services, Microsoft perpetual licensing, and Microsoft Support Services for medium and enterprise-sized businesses. Our robust team of in-house, U.S-based Microsoft architects and engineers are certified in all 6/6 Microsoft Solutions Partner Designations in the Microsoft Cloud Partner Program.

Be one of the first applicants, read the complete overview of the role below, then send your application for consideration.

Prioritizing a people-centric mission, TrustedTech has transformed the Microsoft software licensing experience, giving IT professionals complete confidence in the success of their Microsoft investment.

Overview: We are looking for a

Data Analyst / BI Developer

whoexcels at the crossroads of analytics, design, and business strategy. This hybrid role combines the curiosity of a Data Analyst with the technical expertise of a BI Developer to uncover anomalies, develop complex SQL queries, and deliver executive-ready Power BI dashboards that are both visually polished and highly actionable.

The ideal candidate pairs strong technical skills in SQL, dbt, and Power BI with a keen eye for modern dashboard design and user adoption, ensuring insights are not only accurate but also intuitive, engaging, and impactful across the business.

Responsibilities: Data Analysis & Anomaly Detection: Write advanced

SQL queries

to uncover anomalies, gaps, and inconsistencies in sales, finance, and operational data. Translate findings into actionable reports by building

Power BI dashboards or Google Sheets workflows

that allow business teams to review, validate, and correct data. Act as a proactive analyst, actively

hunting for insights and issues that impact

revenue and operations.

Dashboard & Reporting Automation: Develop and maintain intuitive, interactive Power BI dashboards that support strategic and operational decision-making. Ensure data accuracy, consistency, and integrity in all reporting outputs. Build tools and apps that simplify and automate manual workflows across departments.

Power BI Design Quality: Deliver visually compelling , executive-ready dashboards with modern layouts ,

storytelling, and intentional

use of typography, color, and interactivity. Benchmark against

industry-leading Power BI design standards to maintain

a high level of visual quality. Incorporate

interactivity, accessibility, and usability principles

so dashboards drive adoption across all levels of the business.

Data Infrastructure & ETL Development: Consolidate disparate data sources into a centralized warehouse to support real-time and executive reporting. Partner with data engineers to integrate new data sources and maintain robust, efficient workflows.

Performance Optimization & Governance: Optimize Power BI models, queries, and refresh processes for performance and scalability. Define and maintain consistent KPIs, data definitions, and documentation across dashboards and reports. Ensure governance standards are followed for data accuracy, version control, and accessibility.

Cross-Functional Collaboration: Act as the bridge between technical data solutions and business needs across Marketing, Product, Finance, and Operations. Translate complex technical insights into actionable recommendations for non-technical stakeholders. Support training and adoption initiatives to ensure dashboards are used effectively across the organization.

Required Skills & Qualifications (must-haves): Bachelor's degree in Computer Science, Data Science, Statistics, or a related field (or equivalent experience). 4+ years of experience in analytics, analytics engineering, or business intelligence in a cross-functional business environment. Expertise in:

Power BI

(dashboarding, DAX, visualization best practices),

SQL

(data modeling, query optimization),

Python

(data transformation, automation scripts), and

Azure Synapse

or similar cloud-based data platforms. Strong applied SQL skills for data investigation, anomaly detection, and root cause analysis. Experience working with

Salesforce

data and aligning insights with sales processes and metrics. Strong storytelling and communication skills; able to present insights in a clear, compelling way. Advanced Power BI design skills with a strong portfolio of dashboards that demonstrate polished aesthetics, modern layouts, and impactful storytelling.

Preferred Skills& Qualifications (nice-to-haves): Experience building or maintaining a

data warehouse . Exposure to

ETL automation frameworks

and orchestration tools. Demonstrated ability to work independently and manage multiple priorities. Previous experience developing

custom tools or internal applications

that drive efficiency. Knowledge of custom Power BI visuals or CSS-like styling to refine user experience Familiarity with design systems, UI/UX principles, and best practices in data visualization. Experience with dbt (data build tool) for managing SQL transformations, testing data quality, and maintaining version-controlled analytics workflows.

Benefits: 100% HMO Healthcare Coverage (CA employees only) PPO Healthcare Coverage Vision and Dental Insurance 401(k) plan with a 4% match by TT PTO + sick pay + paid holidays Pet Insurance Paid Parental Leave Microsoft Reimbursement Program Estimated Salary Range: $110K - $125K (*DOE)

*TrustedTech is an equal opportunity employer and does not discriminate on the basis of race, color, religion, sex, age, national origin, veteran status, disability, sexual orientation/gender identity, or any other characteristic protected by applicable law.*