Advantage Solutions Database Analyst in East Irvine, California
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
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
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
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.
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.
This position does not have supervisory responsibilities for direct 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
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).
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)