Advantage Sales and Marketing Merchandising Jobs

Job Information

Advantage Solutions Database Analyst in East Irvine, California

Summary

Database Analyst

At our Company, we grow People, Brands, and Businesses! We are seeking adynamicDatabase Analyst (DA) to provide support for relational database systems. This role willserve as a primary interface for database-related issues and as a key member of the disaster recovery team. Will also be responsible for backup media necessary for database restoration.

Take this opportunity to join North America’s leading business solutions provider and build your career working with amazing people in a growing industry! Apply today!

What we offer:

  • Full-Time Benefits (Medical, Dental, Vision, Life)

  • 401(k) with company match

  • Training and Career Development

  • Generous Paid Time-Off

Qualifications:

  • Experience of 5+ years in data preparation, data gateway and data warehousing projects

  • Experience of 5+ years and familiarity with Microsoft Business Intelligence Stack having Power BI, SSAS, SSRS, SSIS

  • 3 to 4 years of experience working with Power BI

  • Experience working in an enterprise Power BI environment managing capacity, node, gateway etc

  • Should be familiar and experienced in SQL

  • 4 - 5 years of experience in working with relation databases like MSSQL Server etc

  • Must have experience with database cloud technologies

  • Bachelor's Degree or equivalent experience is required

  • Excellent written communication and verbal communication skills

  • Must have experience writing and modifying queries against relational databases

Responsibilities:

  • Supporting Power BI platform with development and administration for many users and business groups

  • Analyze data and develop visual reports, dashboards and KPI scorecards using Power BI

  • Connecting to data sources, importing data and transforming data in Power BI using different type of data sources

  • Excellent in analytical thinking for translating data into informative visuals and reports

  • Able to implement row level security on data and understand application security layer models in Power BI

  • Demonstrating new Power BI features to user groups and teaching business groups on how to use the tool efficiently

  • Proficient in making DAX queries in Power BI desktop

  • Adept in developing, publishing and scheduling Power BI reports as per the business requirements

  • Able to properly understand the business requirements and develop data models accordingly by taking care of the resources

  • Monitor and troubleshoot issues related to Power BI Reports and workspaces

  • Should have knowledge in Microsoft Azure, MS SQL Server, Snowflake etc

  • Identifying and implementing best practices for various Power BI reports and database connections

  • Contributes to custom database design and custom database interfaces, including writing interface programs

  • Conducts research pertaining to future growth and development of hardware and software

  • Installs and upgrades database software including Power BI Gateway servers

  • Writes custom queries and programs, which report or update the database

  • Develops and maintains system documentation and standards

Responsibilities

The Company is one of North America’s leading sales and marketing agencies specializing in outsourced sales, merchandising, category management and marketing services to manufacturers, suppliers and producers of food products and consumer packaged goods. The Company services a variety of trade channels including grocery, mass merchandise, specialty, convenience, drug, dollar, club, hardware, consumer electronics and home centers. We bridge the gap between manufacturers and retailers, providing consumers access to the best products available in the marketplace today.

Position Summary

The Database Analyst (DA) provides support for relational database systems.

Essential Job Duties and Responsibilities

  • Provides support for relational database systems including, utilization and performance monitoring backup and recovery, configuration and tuning, security, and user account management.

  • Contributes to custom database design and custom database interfaces, including writing interface programs.

  • Serves as primary interface for database-related issues.

  • Conducts research pertaining to future growth and development of hardware and software.

  • Installs and upgrades database software.

  • Writes custom queries and programs, which report or update the database.

  • Provides secondary support for systems, EDI interfaces, and Unibol print spooling software.

  • Develops and maintains system documentation and standards.

  • Serves as key member of the disaster recovery team. Responsible for backup media necessary for database restoration.

Supervisory Responsibilities

Direct Reports

This position does not have supervisory responsibilities for direct reports

Indirect Reports

This position does not have guidance or mentoring responsibilities for indirect reports

Travel and/or Driving Requirements

Travel and Driving are not essential duties or functions of this job

Minimum Qualifications

Education Level: (Required) Bachelor's Degree or equivalent experience

3-5 years of experience in a systems and/or training capacity

Skills, Knowledge and Abilities

  • Excellent written communication and verbal communication skills

  • Must possess an in-depth knowledge of necessary operating systems.

  • Must possess an in-depth knowledge of relational database including Informix, Oracle, and SQL Server.

  • Must possess an in-depth knowledge of database administration procedures.

  • Must possess an in-depth knowledge of SQL and stored procedure.

  • Must have experience writing and modifying programs, which access a relation database.

  • Must have some knowledge of LANs and WANs and be able to make recommendations as related to database access and performance.

Environmental & Physical Requirements

Office / Sedentary Requirements

Incumbent must be able to perform the essential functions of the job. Work is performed primarily in an office environment. Typically requires the ability to sit for extended periods of time (66%+ each day), ability to hear the telephone, ability to enter data on a computer and may also require the ability to lift up to 10 pounds.

Additional Information Regarding The Company Job Duties and Job Descriptions

Job duties include additional responsibilities as assigned by one’s supervisor or other manager related to the position/department. This job description is meant to describe the general nature and level of work being performed; it is not intended to be construed as an exhaustive list of all responsibilities, duties and skills required for the position. The Company reserves the right at any time with or without notice to alter or change job responsibilities, reassign or transfer job position or assign additional job responsibilities, subject to applicable law. The Company shall provide reasonable accommodations of known disabilities to enable a qualified applicant or employee to apply for employment, perform the essential functions of the job, or enjoy the benefits and privileges of employment as required by the law.

Any estimate, schedule, or guideline provided to associates in this job description or elsewhere in connection with their jobs is only intended to help describe job duties and for planning purposes. Regardless of any such estimate, schedule, or guideline, associates must always record all time worked for our company (which includes but is not limited to on-site work time in an assigned store, office, or other work location; required waiting time; administrative time; and work-related travel time).

Important Information

The above statements are intended to describe the general nature and level of work being performed by people assigned to this position. They are not intended to be an exhaustive list of all responsibilities, duties and skills required of associates so classified.

The Company is committed to providing equal opportunity in all employment practices without regard to age, race, color, national origin, sex, sexual orientation, religion, physical or mental disability, or any other category protected by law. As part of this commitment, the Company shall provide reasonable accommodations of known disabilities to enable an applicant or employee to apply for employment, perform the essential functions of the job, or enjoy the benefits and privileges of employment as required by the law.

Job Locations US-CA-East Irvine

Primary Posting Location : City East Irvine

Primary Posting Location : State/Province CA

Primary Posting Location : Country US

Requisition ID 2021-377465

Position Type Full Time

Category Professional: (IT, Finance, Legal, HR, Talent Acquisition, Administrative, Customer Service)

DirectEmployers