Senior Data Analyst | BI (Remote)

TieTalent; Irvine (CA); Remote; USD 125,000 - 164,000; Full time

Job summary

A dynamic technology consulting firm is seeking a Data Analyst to provide technical consulting and develop insightful data visualizations. This role requires a solid background in SQL and business intelligence tools including Tableau and Power BI, along with experience in developing data pipelines. The ideal candidate will join a thriving culture that values teamwork and continuous innovation while contributing to impactful client relationships.

Benefits

Comprehensive medical, dental and vision plans

401(k) Retirement Plan with Employer Match

Stocked kitchen with snacks and beverages

Work-life balance and generous paid time off

Training and development programs

Qualifications

• Master's or Bachelor's degree with significant experience in data analysis.
• Three years experience with SQL querying and business intelligence tools.
• Experience with statistical analysis tools like R and Tableau preferred.

Responsibilities

• Provides technical consulting support in dashboard/report development.
• Creates reports and dashboards using Tableau and Power BI.
• Develops and maintains data pipelines using Azure services.

Skills

SQL

Tableau

Power BI

Python

R

Education

Master's degree in Information Systems

Bachelor's degree in Computer Science

Tools

Azure Data Factory

Hadoop

Job description

Get AI-powered advice on this job and more exclusive features.

Pay found in job post

Retrieved from the description.

Base pay range

$125,600.00/yr - $163,800.00/yr

About

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.
  
  

Nice-to-have skills

• SQL
• Tableau
• Power BI
• Azure Data Factory
• Spark
• Python
• Hive
• R
• SAS
• Matlab
• Hadoop
• S3
• Irvine, California
  
  

Work experience

• Data Analyst
• Business Intelligence
  
  

Languages

• English

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Information Technology

• Industries

  Technology, Information and Internet

Referrals increase your chances of interviewing at TieTalent by 2x

Enterprise Analytics Manager (Principal Business Intelligence Analyst Tableau)

Customer Remediation Data Analyst - Consumer & Business Banking Risk

Long Beach, CA $115,000 - $125,000 1 week ago

Senior Technical Business Analyst - Energy, Sustainability & Mobility

Senior Strategy & Business Development Analyst

Financial Services - Consulting - Guidewire - Business Analyst - Senior

Senior Business Tax Analyst - Work From Home

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.