Trace3 Logo

Trace3

Senior Data Analyst | BI (Remote)

Posted 6 Days Ago
Remote
Hiring Remotely in Irvine, CA
126K-164K Annually
Senior level
Remote
Hiring Remotely in Irvine, CA
126K-164K Annually
Senior level
Provide technical consulting support in dashboard/report development, data prep, and client relationship building while optimizing data models using Azure and BI tools.
The summary above was generated by AI

Who is Trace3?

Trace3 is a leading Transformative IT Authority, providing unique technology solutions and consulting services to our clients. Equipped with elite engineering and dynamic innovation, we empower IT executives and their organizations to achieve competitive advantage through a process of Integrate, Automate, Innovate.

Our culture at Trace3 embodies the spirit of a startup with the advantage of a scalable business. Employees can grow their career and have fun while doing it!

Trace3 is headquartered in Irvine, California. We employ more than 1,200 people all over the United States. Our major field office locations include Denver, Indianapolis, Grand Rapids, Lexington, Los Angeles, Louisville, Texas, San Francisco.  

Ready to discover the possibilities that live in technology?


Come Join Us!

Street-Smart Thriving in Dynamic Times

We are flexible and resilient in a fast-changing environment. We continuously innovate and drive constructive change while keeping a focus on the “big picture.” We exercise sound business judgment in making high-quality decisions in a timely and cost-effective manner. We are highly creative and can dig deep within ourselves to find positive solutions to different problems.

Juice - The “Stuff” it takes to be a Needle Mover

We get things done and drive results. We lead without a title, empowering others through a can-do attitude. We look forward to the goal, mentally mapping out every checkpoint on the pathway to success, and visualizing what the final destination looks and feels like.

Teamwork - Humble, Hungry and Smart

We are humble individuals who understand how our job impacts the company's mission. We treat others with respect, admit mistakes, give credit where it’s due and demonstrate transparency. We “bring the weather” by exhibiting positive leadership and solution-focused thinking. We hug people in their trials, struggles, and failures – not just their success. We appreciate the individuality of the people around us.


Job Duties:

  • Provides technical consulting support to clients in the areas of dashboard/report development, data preparation, and supporting requirements gathering.
  • Participates in marketing and pre-sales efforts to win projects and build client relationships.
  • Creates reports and dashboards using data visualization and reporting tools such as Tableau and Power Business Intelligence (BI).
  • Develops and optimizes semantic models in analysis services tabular models and Power BI models with complex business logic.
  • Writes Data Analysis Expressions (DAX) to build business calculations for reporting and dashboard use.
  • Develops and maintains data pipelines using Azure native services like Azure Data Factory, Synapse, Spark, Python, Databricks.
  • Writes advanced SQL using Presto/Hive including structured, complex, and efficient queries on large data sets and to optimize queries.
  • Designs and develops scalable data warehousing solutions, building Extract, Transform, Load (ETL) pipelines in Big Data environments (cloud, on-premises, hybrid).
  • Leverages tools like R, Python, Hadoop & SQL to drive efficient analytics.
  • Establishes strong relationships with key stakeholders and decision makers in client organizations.
  • Develops complex reporting and analysis to provide leadership transparency to vendor, contract, and risk management priorities; providing recommendations to achieve cost savings and vendor risk management goals.
  • Leads cross functional/teams training to incorporate new methodology and streamline existing business processes and assists in creation of new business processes.
  • Position is for roving employee who will work in various unanticipated locations throughout the U.S. according to business need.

Requires:

    • Master’s degree or foreign equivalent in Information Systems, Computer Science, or a closely related field plus three (3) years of experience as a Data Analyst, or closely related business intelligence role.
    • Employer will also accept a Bachelor’s degree or foreign equivalent in Information Systems, Computer Science, or a closely related field plus five (5) years of progressive experience as a Data Analyst, or closely related business intelligence role.
    • Three (3) years of experience with querying data using SQL or other query and scripting languages to aggregate, gather, and manipulate data
    • Three (3) years of experience using reporting and dashboarding tools including Tableau.


    Additional skills to include:

    • Experience in Statistical Analysis packages such as R, SAS or MATLAB.
    • Experience in data mining and ETL and using databases in a business environment with large-scale, complex datasets.
    • Experience using Cloud Storage and Computing technologies such as AWS Redshift, S3, and Hadoop.
    • Experience designing and developing Power Platform applications.
    • Experience developing and integrating Power Apps, Canvas App, Model Driven Apps, Power Pages, Power Automate, Power BI, Report Builder, Dataverse, SQL Server Database, Azure Active Directory, and Microsoft Teams.
    • Experience serving as a Power Platform subject matter expert and providing knowledge transfer to the developers.
    • Experience developing Power Pages to create an external website or application.
    • Experience developing Power Automate flow for several approval processes/components of the Project Tracking Console.
    • Experience with design and Architecture in D365 and Power Platform solutions using Model Driven Apps, Dataverse, Cloud Flows, and Power BI.
    • Hands-on experience working with multiple data sources including Dataverse (CDS), SQL/Azure SQL, SharePoint, and other connectors.
    • Experience with Power Automate Desktop RPA, AI Builder technologies, PowerApps integration with Azure API Apps and REST services, Power Pages, Power Virtual Agents and its customization and deployment, Dynamics 365 customizations.

    Travel: Up to 20% domestic travel for client and business review meetings, and occasional onsite training.

Actual salary will be based on a variety of factors, including location, experience, skill set, performance, licensure and certification, and business needs. The range for this position in other geographic locations may differ. Certain positions may also be eligible for variable incentive compensation, such as bonuses or commissions, that is not included in the base salary.

Estimated Pay Range

$125,600$163,800 USD

The Perks:

  • Comprehensive medical, dental and vision plans for you and your dependents
  • 401(k) Retirement Plan with Employer Match, 529 College Savings Plan, Health Savings Account, Life Insurance, and Long-Term Disability
  • Competitive Compensation
  • Training and development programs
  • Stocked kitchen with snacks and beverages
  • Collaborative and cool culture
  • Work-life balance and generous paid time off


***To all recruitment agencies: Trace3 does not accept unsolicited agency resumes/CVs. Please do not forward resumes/CVs to our careers email addresses, Trace3 employees or any other company location. Trace3 is not responsible for any fees related to unsolicited resumes/CVs.

Top Skills

Azure Data Factory
Azure Databricks
Azure Synapse
Hadoop
Power BI
Python
R
SQL
Tableau

Trace3 El Segundo, California, USA Office

2120 E. Grand Ave, El Segundo, CA, United States

Trace3 Irvine, California, USA Office

7565 Irvine Center Drive, Irvine, CA, United States

Similar Jobs

8 Hours Ago
Remote
United States
85K-127K Annually
Mid level
85K-127K Annually
Mid level
Healthtech • Pharmaceutical • Manufacturing
The Senior Post Market Data Analyst analyzes post-market surveillance data, collaborates on project deliverables, and develops visualization tools in Power BI to drive insights and regulatory compliance.
Top Skills: ExcelMS OfficePower BISpotfireTrackwise
2 Days Ago
Remote
USA
95K-110K
Mid level
95K-110K
Mid level
Healthtech • HR Tech • Information Technology • Other • Software
As a Business Intelligence Analyst, you will leverage data to support teams, conduct ad-hoc analysis, deliver insights, and maintain robust data models, while partnering with stakeholders.
Top Skills: DbtLookerLookmlPostgresPythonSalesforceSQL
8 Days Ago
Remote
United States
105K-120K Annually
Mid level
105K-120K Annually
Mid level
Security
The Business Intelligence Analyst will leverage data to provide insights for strategic decision-making, develop visualizations, and collaborate with cross-functional teams.
Top Skills: AWSGoogle BigqueryLookerSQLTableau

What you need to know about the Los Angeles Tech Scene

Los Angeles is a global leader in entertainment, so it’s no surprise that many of the biggest players in streaming, digital media and game development call the city home. But the city boasts plenty of non-entertainment innovation as well, with tech companies spanning verticals like AI, fintech, e-commerce and biotech. With major universities like Caltech, UCLA, USC and the nearby UC Irvine, the city has a steady supply of top-flight tech and engineering talent — not counting the graduates flocking to Los Angeles from across the world to enjoy its beaches, culture and year-round temperate climate.

Key Facts About Los Angeles Tech

  • Number of Tech Workers: 375,800; 5.5% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: Snap, Netflix, SpaceX, Disney, Google
  • Key Industries: Artificial intelligence, adtech, media, software, game development
  • Funding Landscape: $11.6 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Strong Ventures, Fifth Wall, Upfront Ventures, Mucker Capital, Kittyhawk Ventures
  • Research Centers and Universities: California Institute of Technology, UCLA, University of Southern California, UC Irvine, Pepperdine, California Institute for Immunology and Immunotherapy, Center for Quantum Science and Engineering

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account