Senior Business and Data Analyst (No Sponsorships or Recruiters)

Company: Trace3
Location: Irvine
Posted on: January 15, 2022

Job Description:

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 850 people all over the United States. Our major field office locations include Atlanta, Denver, Detroit, Indianapolis, Grand Rapids, Lexington, Los Angeles, Louisville, San Diego, San Francisco, and Scottsdale. Ready to discover the possibilities that live in technology?Come Join Us!Street-Smart- Thriving in Dynamic TimesWe 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 SmartWe 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.About the Role:Reporting to the Analytics and Insights Director, the Senior Business and Data Analyst will provide technical expertise and guidance to internal clients in the areas of report design, ad-hoc analytics, and be pivotal to developing and delivering NetSuite reports. This individual contributor role will oversee analytic reporting, research, and optimization efforts, bringing forward actionable insights to enable data-driven decision-making across Trace3. The SBDA will actively partner with leaders in Engineering, Sales and Corporate to address unanswered business issues and generate business insights to push Trace3 forward. This role will work closely with Data Warehouse Architects, Power BI Report Developers, Business Analysts and Business stakeholders to ensure successful delivery of user requests. This role will work across the Company to create presentations, reports, dashboards, and conduct analysis which will inform recommendations to various business units.What You'll Do:Job will lean heavily on work within NetSuite. Duties will include development of essential reporting and analytics, trouble shoot issues, validating data, giving input on system enhancement and integration regarding how they will affect reporting, and working with IT team.Create NetSuite datasets and prepare data for visualization and reporting tools using tools such as specialized data preparation tools or SQL code.Triage reporting issues and estimate effort and due datesModel and prepare data for ingestion into visualization and reporting tools, such as Power BI.Optimize and expand current reporting and ad-hoc data models.Manage requirement backlog.Write proof-of-concept SQL to generate data models to hand off to IT/Engineering.Expert ability to assess current raw data to ascertain whether it is sufficient to meet stakeholder reporting and analysis requirements and then normalize data for reporting and visualizationPartner with key business unit leaders across the company to provide strategic guidance on their custom and specific data needsEstablish strong and lasting relationships with key stakeholders and decision makers in client organizations.Strong ability to communicate with business stakeholders to generalize their requirements into current and forward-looking reporting.Ability to approach customer requests with a proactive and consultative manner; listen and understand user requests and needs and effectively deliver.Comfortable managing multiple and changing priorities, and meeting deadlines in an entrepreneurial environment.Highly organized, detail-oriented, excellent time management skills and able to effectively prioritize tasks in a fast-paced, high-volume, and evolving work environment.Deliver thoughtful recommendations through presentations to ultimately influence business decisionsMay perform other duties as assigned by supervisor.Qualifications & Interests:Minimum of 5 years of experience developing NetSuite Reports and Saved SearchesMinimum of 5 years of experience in data analysis and/or analytics (turning data into reports/insights, mining data for insights). Solid dimensional data modeling experience. Strong in optimization of dimensional modelingMinimum of 3 years writing SQL. Solid SQL skills (Microsoft SQL Server/Azure SQL Database) PreferablyMinimum of 2 year of experience using reporting and dashboarding tools (Tableau, Looker, Power BI etc.)Fluency in a high-level language (Python, R, t-SQL, SuiteSQL etc.) strongly preferredProficiency and minimum of 2 years developing in DAX or similar preferredBachelor's degree from an accredited university or equivalent amount of experienceExcellent communication skillsMust be able to quickly understand technical and business requirements and be able to translate them into technical implementationsMotivated self-starter who loves to troubleshoot and solve challenging problems and feels comfortable working directly with customersNice to have skills: Min of 2 years of experience with SQL Reporting ServicesFamiliarity with SDLCSupported Data and Analytics for Finance, Sales or Services teams. VAR or Distributor industry background.The Perks:Comprehensive medical, dental and vision plans for you and your dependents401(k) Retirement Plan with Employer Match, 529 College Savings Plan, Health Savings Account, Life Insurance, and Long-Term DisabilityCompetitive CompensationTraining and development programsStocked kitchen with snacks and beveragesCollaborative and cool office cultureWork-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.

Keywords: Trace3, Irvine , Senior Business and Data Analyst (No Sponsorships or Recruiters), Human Resources , Irvine, California