Buffini & Company
Junior Business Intelligence Analyst
Buffini & Company - Carlsbad, California, United States, 92002
Work at Buffini & Company
Overview
- View job
Overview
Join to apply for the
Junior Business Intelligence Analyst
role at
Buffini & Company Join to apply for the
Junior Business Intelligence Analyst
role at
Buffini & Company Get AI-powered advice on this job and more exclusive features. This range is provided by Buffini & Company. Your actual pay will be based on your skills and experience talk with your recruiter to learn more. Base pay range
$80,000.00/yr - $90,000.00/yr Direct message the job poster from Buffini & Company Human Resources Director at Buffini & Company
Job Purpose: Provide Business Intelligence insights to enhance strategic decisions as well as ensure SQL backend maintenance and integrity. Job Summary: The Junior Business Intelligence Analyst is responsible for reporting, data requests, ETL development and database maintenance. Duties:
(Additional Duties May Be Added as Needed) Collaborate with key Buffini and Company stakeholders to determine reporting/data needs Gain deep understanding of Buffinis data to create reports that will help drive business decisions Help improve query performance through indexing and refining query composition Develop and Deploy SSIS packages (ETL) to SQL Integration Services Catalog and create the respective SQL Job Troubleshooting SQL job failures Occasionally Develop SSRS Reports as well as troubleshoot existing SSRS reports Knowledge of Google Analytics is a plus Ensure server backups meet the Recovery Point Objectives (RPO) Periodically test the backups Document larger changes such as ETL deployment that replaces legacy processes such as linked server jobs Qualifications: To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Bachelor's degree from four-year college or university, preferably in Computer Science, Statistics or related discipline Minimum of 1 years experience working with databases Query composition and refinement Table creation including constraints (primary and foreign keys) Understanding of data warehouse concepts (Star vs Snowflake schemas) Understanding of backup software and best practices Minimum of 1 years experience working with Excel Exposure to Business Intelligence visualization software such as SSRS, Tableau or Power BI Advanced problem-solving skills Ability to shift between large scale projects and ad-hoc requests Self-starter who takes pride in the ownership of robust software solutions that meet specific, well-understood business needs Experience working directly with internal clients, departmental managers, and executive leadership High degree of professionalism and strong written and oral communication skills Strong business acumen Basic understanding of relational database concepts and best practices Desire to constantly improve in various professional facets through assisted and unassisted means Ability to learn quickly and to creatively solve new problems. Ability to negotiate and settle differences quickly and peacefully. Ability to act as a team player. Education and/or Experience 1+ years experience working with Microsoft SQL Server Experience with BI visualization software such as Tableau, Power BI or SSRS Bachelor's degree in Computer Science or related field Experience with Salesforce and/or Marketo a plus Physical Demands The physical demands described here are representative of those that must be met by a servant leader to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. Regularly required to sit and talk or hear while performing duties. Frequently required to use hands to finger, handle, or feel and reach with hands or arms. Occasionally required to stand and walk. Occasionally lift and/or move up to 20 pounds. The work environment characteristics here are representative of those a servant leader encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. The servant leader is subject to inside environmental conditions, such as in a typical office, with no hazardous or significantly unpleasant conditions. Seniority level
Seniority level
Entry level Employment type
Employment type
Full-time Job function
Job function
Analyst Industries
Professional Training and Coaching Referrals increase your chances of interviewing at Buffini & Company by 2x Inferred from the description for this job
Medical insurance Vision insurance 401(k) Disability insurance Get notified about new Business Intelligence Analyst jobs in
Carlsbad, CA . Strategic Business Operations Sr. Principal Analyst
Poway, CA $73,700.00-$128,780.00 2 days ago Poway, CA $81,080.00-$141,650.00 7 minutes ago Financial Services - Consulting - Guidewire - Business Analyst - Senior
Microsoft D365 Supply Chain Management Business Analyst - Senior - Consulting - Location OPEN
San Diego, CA $102,500.00-$187,900.00 23 hours ago Financial Services - Customer Tax Operations and Reporting - Tax Services Analyst-EDGE
Case Manager (Bachelors - BA) | Social Worker | Counselor
Americas Tax Technology Group - Business Analyst - Manager (SAP Implementation)
Financial Services - Consulting - Guidewire - Business Analyst - Manager
Financial Services - Global Compliance and Reporting - Real estate -Tax Senior Analyst-EDGE
Solana Beach, CA $86,000.00-$105,000.00 1 month ago Business Solutions Analyst II (Professional Services)
Solana Beach, CA $86,000.00-$105,000.00 1 month ago Finance Business Systems/Anaplan Lead Analyst - 132510
Finance Business Systems/Anaplan Lead Analyst - 132510
Financial Services - Customer Tax Operations and Reporting - Tax Services Senior Analyst-EDGE
Were unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI. #J-18808-Ljbffr
Junior Business Intelligence Analyst
role at
Buffini & Company Join to apply for the
Junior Business Intelligence Analyst
role at
Buffini & Company Get AI-powered advice on this job and more exclusive features. This range is provided by Buffini & Company. Your actual pay will be based on your skills and experience talk with your recruiter to learn more. Base pay range
$80,000.00/yr - $90,000.00/yr Direct message the job poster from Buffini & Company Human Resources Director at Buffini & Company
Job Purpose: Provide Business Intelligence insights to enhance strategic decisions as well as ensure SQL backend maintenance and integrity. Job Summary: The Junior Business Intelligence Analyst is responsible for reporting, data requests, ETL development and database maintenance. Duties:
(Additional Duties May Be Added as Needed) Collaborate with key Buffini and Company stakeholders to determine reporting/data needs Gain deep understanding of Buffinis data to create reports that will help drive business decisions Help improve query performance through indexing and refining query composition Develop and Deploy SSIS packages (ETL) to SQL Integration Services Catalog and create the respective SQL Job Troubleshooting SQL job failures Occasionally Develop SSRS Reports as well as troubleshoot existing SSRS reports Knowledge of Google Analytics is a plus Ensure server backups meet the Recovery Point Objectives (RPO) Periodically test the backups Document larger changes such as ETL deployment that replaces legacy processes such as linked server jobs Qualifications: To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Bachelor's degree from four-year college or university, preferably in Computer Science, Statistics or related discipline Minimum of 1 years experience working with databases Query composition and refinement Table creation including constraints (primary and foreign keys) Understanding of data warehouse concepts (Star vs Snowflake schemas) Understanding of backup software and best practices Minimum of 1 years experience working with Excel Exposure to Business Intelligence visualization software such as SSRS, Tableau or Power BI Advanced problem-solving skills Ability to shift between large scale projects and ad-hoc requests Self-starter who takes pride in the ownership of robust software solutions that meet specific, well-understood business needs Experience working directly with internal clients, departmental managers, and executive leadership High degree of professionalism and strong written and oral communication skills Strong business acumen Basic understanding of relational database concepts and best practices Desire to constantly improve in various professional facets through assisted and unassisted means Ability to learn quickly and to creatively solve new problems. Ability to negotiate and settle differences quickly and peacefully. Ability to act as a team player. Education and/or Experience 1+ years experience working with Microsoft SQL Server Experience with BI visualization software such as Tableau, Power BI or SSRS Bachelor's degree in Computer Science or related field Experience with Salesforce and/or Marketo a plus Physical Demands The physical demands described here are representative of those that must be met by a servant leader to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. Regularly required to sit and talk or hear while performing duties. Frequently required to use hands to finger, handle, or feel and reach with hands or arms. Occasionally required to stand and walk. Occasionally lift and/or move up to 20 pounds. The work environment characteristics here are representative of those a servant leader encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. The servant leader is subject to inside environmental conditions, such as in a typical office, with no hazardous or significantly unpleasant conditions. Seniority level
Seniority level
Entry level Employment type
Employment type
Full-time Job function
Job function
Analyst Industries
Professional Training and Coaching Referrals increase your chances of interviewing at Buffini & Company by 2x Inferred from the description for this job
Medical insurance Vision insurance 401(k) Disability insurance Get notified about new Business Intelligence Analyst jobs in
Carlsbad, CA . Strategic Business Operations Sr. Principal Analyst
Poway, CA $73,700.00-$128,780.00 2 days ago Poway, CA $81,080.00-$141,650.00 7 minutes ago Financial Services - Consulting - Guidewire - Business Analyst - Senior
Microsoft D365 Supply Chain Management Business Analyst - Senior - Consulting - Location OPEN
San Diego, CA $102,500.00-$187,900.00 23 hours ago Financial Services - Customer Tax Operations and Reporting - Tax Services Analyst-EDGE
Case Manager (Bachelors - BA) | Social Worker | Counselor
Americas Tax Technology Group - Business Analyst - Manager (SAP Implementation)
Financial Services - Consulting - Guidewire - Business Analyst - Manager
Financial Services - Global Compliance and Reporting - Real estate -Tax Senior Analyst-EDGE
Solana Beach, CA $86,000.00-$105,000.00 1 month ago Business Solutions Analyst II (Professional Services)
Solana Beach, CA $86,000.00-$105,000.00 1 month ago Finance Business Systems/Anaplan Lead Analyst - 132510
Finance Business Systems/Anaplan Lead Analyst - 132510
Financial Services - Customer Tax Operations and Reporting - Tax Services Senior Analyst-EDGE
Were unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI. #J-18808-Ljbffr