Data Analyst / BI Developer Job at TrustedTech, Irvine, CA

cVpTTzZZTVZNTHM1NWhDT1Q1ZWZ0ZndNMlE9PQ==
  • TrustedTech
  • Irvine, CA

Job Description

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.

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 who excels 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.*

Job Tags

Similar Jobs

CBTS

Data Analyst Job at CBTS

 ...with valid Employment Authorization Documents (EAD). Applicants who do not meet these criteria will not be considered" Job Title: Data Analyst Location: Atlanta, GA/Washington DC Model: Hybrid Duration: Long Term J ob Description: Must Have... 

YDS Translation

Native Translator for Multiple Languages Job at YDS Translation

 ...Luganda Chichewa Chadian Arabic Sudanese Arabic Tswana Bemba NdebeleAsia Chinese (Mandarin) Cantonese Tibetan Hindi Bengali Punjabi Tamil Telugu Marathi Gujarati Urdu Malayalam Kannada Oriya Nepali Assamese Khmer Thai... 

Sares-Regis Group

Part-Time Maintenance Technician II Job at Sares-Regis Group

 ...bonuses, and rental discounts depending on location. Regular full-time employees who work between 30-40 hours a week are eligible for medical, dental, vision, other voluntary benefits and vacation accrual. Sick time accrual is provided in accordance with law. PLEASE... 

Creative Cove Inc.

Graphic Designer Job at Creative Cove Inc.

 ...Our Boston based client is looking for a Graphic Designer with 5+ years' experience; the clinet is looking for project based specifically for marketing design-ie email, banner ads, and social media campaigns. If you have previous experience as a Brand or Marketing Designer... 

LEARN Charter School Network

Assistant Principal Job at LEARN Charter School Network

 ...college preparatory, tuition-free public elementary and middle schools with the mission of providing children with the academic foundation...  ...earning a Exemplary school designation by the Illinois State Board of Education. LEARN also received a $7 million dollar gift from...