Sr. Business Systems Analyst

job summary:

Day to Day responsibilities:

• BI Foundation Tables is source-of-truth for the team's analytics and this role requires someone to assess team needs on the BI Foundation Tables and decide on how to best support the needs. The needs include table schema design and best practice field naming convention.
• Responsible for code deployment and ETL implementation.
• Drive Table architect design and best practice.

location: Mountain View, California

job type: Contract

salary: $39 - 49 per hour

work hours: 8am to 5pm

education: Bachelors



responsibilities:

• Monitor and report any data source discrepancy to internal team and Corp IT.
• Assist in writing complex SQLs and performance tunings of current-state in Teradata SQL, future-state in Snowflake.
• Review Change Request or New Request to BI Foundation Tables and determine design, develop, and enhancement to dept BI Foundation tables.
• Timely releases/publication of enhancement to BI Foundation Table.
• Monitor bi-weekly ETL jobs, troubleshoot failures, and ensure BI Foundation tables are refreshed accordingly.
• Email Notification of changes and releases to the team.
• Diagnose and Identify problems (performance, data discrepancy) and resolve issue within 24-48 hours.
• Partner with IT Dept and/or Dept Team to review/enhance data pipelines and reporting effectiveness.

qualifications:

• Participation in dept bi-weekly BI Foundation Touchbase meeting to review outstanding requests.
• Report, track, and monitor bugs and enhancement of EDW data quality.
• Meeting with IT Dept to review system access setup
• Compelling Story & Candidate Value Proposition

skills:

• This role allows creativity and flexibility. All feedback is welcome.
• Team collaboration and partnership is a must amongst our dept.
• We share best practices and recommendations on sources, technology, and short-term solutions.
• Support growth and encourage innovation based on available technical software.

Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.

At Randstad Digital, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact

Pay offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad Digital offers a comprehensive benefits package, including health, an incentive and recognition program, and 401K contribution (all benefits are based on eligibility).

This posting is open for thirty (30) days.


It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability.



Qualified applicants in San Francisco with criminal histories will be considered for employment in accordance with the San Francisco Fair Chance Ordinance.



Qualified applicants in the unincorporated areas of Los Angeles County with criminal histories will be considered for employment in accordance with the Los Angeles County's Fair Chance Ordinance for Employers.



We will consider for employment all qualified Applicants, including those with criminal histories, in a manner consistent with the requirements of applicable state and local laws, including the City of Los Angeles' Fair Chance Initiative for Hiring Ordinance.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.