Sr. BI Analyst

Brooksource

all cities, TN

JOB DETAILS
SKILLS
Alliance/Partner Marketing, Analysis Skills, Billing, Business Intelligence, Business Intelligence Software, Communication Skills, Computer Science, Consulting, Continuous Improvement, Cross-Functional, Data Analysis, Data Mapping, Data Mart, Data Mining Software, Data Modeling, Data Quality, Data Visualization, Data Visualization Tools, Data Warehousing, Database Analysis, Database Design, Database Programming, Database Technology, Desktop PC, Documentation, Identify Issues, Information Technology & Information Systems, Mainframe Computer, Mathematics, Microsoft Access Database, Microsoft Excel, Microsoft PowerPoint, Microsoft Word, Multitasking, Operational Improvement, Operational Strategy, Operational Support, Parts Sales, Presentation/Verbal Skills, Problem Solving Skills, Process Improvement, Purchasing/Procurement, Query Analysis, Relational Databases (RDBMS), Reporting Dashboards, Requirements Management, Root Cause Analysis, SAP BusinessObjects, SQL (Structured Query Language), Scripting (Scripting Languages), Statistics, Strategic Planning, Systems Administration/Management, Team Player, Technical Delivery, Technical/Engineering Design, Test Plan/Schedule, Web Programming, Writing Skills, eCommerce
LOCATION
all cities, TN
POSTED
Today
Aftersales Sr. Business Intelligence Analyst - ADAM BI Data Delivery Team

12 Month Contract to Hire

Duties and Responsibilities:

  1. Collaborate with business stakeholders to design and deliver technical solutions that align with functional needs by translating end-user requirements into effective data models, visualizations, and reporting solutions utilizing the Aftersales DataMart (ADAM). Actively participate in strategic planning and solution brainstorming with cross-functional teams.
  2. Leverage advanced reporting, analytics, dashboards, and business intelligence tools-primarily SQL, Snowflake, and SAP Business Objects-to extract, validate, and analyze data from ADAM and other approved data sources.
  3. Lead and coordinate end-user testing, develop database queries to evaluate system behavior, identify root causes, and resolve issues. Contribute to an iterative development process to continuously improve team deliverables.
  4. Partner with internal teams to gather and refine requirements for enhancements to existing systems supporting Nissan Aftersales operations, with a focus on streamlining workflows and improving operational efficiency.
  5. Develop and maintain comprehensive process documentation and an electronic data glossary to ensure standardization and data transparency.
  6. Conduct and document data analysis activities including data validation, data mapping, and data design by accessing and reconciling information across multiple source systems.
  7. Demonstrate the ability to manage multiple priorities simultaneously, transition effectively between projects, and work both independently and collaboratively in a team environment.
  8. Perform other related duties as assigned, consistent with the responsibilities outlined above.
  9. Collect and audit/adjust monthly dealer ecommerce business billing data (debits and credits) from third party eCommerce partner, then process files to correct format, then submit into client non vehicle billing system.
  10. Work with eCommerce team to audit and adjust monthly dealer ecommerce business data on ongoing basis.


Minimum Requirements:

Job Knowledge and Skill:
  1. Advanced analytical skills.
  2. Strategic data warehouse knowledge & capabilities
  3. Familiarization of scripts using SQL to troubleshoot query or reporting errors.
  4. Excellent written and oral communication skills.


Experience:
  1. Experience in designing effective data visualizations and data mining software.
  2. Proficiency in SQL required. Relational database modeling fundamentals required. Web Development is a plus.
  3. 5+ years of database experience and 7+ years of directly related professional-level experience required. Business, Aftersales, or Purchasing, experience is preferred.
  4. Technical automotive parts experience beneficial.


Education:

Bachelor's degree in Information Technology/Computer Science, Mathematics/Statistics, Analytics, Business Technology. Master's degree preferred.

Other Required Computer Skills:

Intermediate knowledge of data-related end-user desktop applications (e.g. Microsoft Access, Excel, Word and PowerPoint). Proficient with mainframe applications to resolve complex problems in day to day situations. Technical and/or programming experience preferred.

About the Company

B

Brooksource

Brooksource is an IT Services Company, specializing in the recruitment and placement of IT professionals across the nation. Our diverse client base covers all industries and provides us the opportunity to place you in positions that span the entire IT spectrum. We offer weekly pay, paid holidays (for New Year's Day, Memorial Day, Fourth of July, Labor Day, Thanksgiving Day, and Christmas Day), and health benefits.

COMPANY SIZE
500 to 999 employees
INDUSTRY
Staffing/Employment Agencies
FOUNDED
2000