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