Senior Data Analyst | BI (Remote)

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.

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.