Data Architect in Austin, TX at Scientific Games

Date Posted: 6/28/2018

Job Snapshot

Job Description



The Data Architect is responsible for maintaining the integrity of our data warehouse system across all products. This position will be required to work alongside different teams to help them meet their goals using best practices

Job Requirements



Essential Job Functions:
•Run SQL explains on queries for query optimization
•Recommends intermediate data sources for optimization of table access patterns
•Works with individual team members and their managers to optimize queries and table schemas
•Integral member of the team in standardized query maintenance and approval process
•Responsible for maintaining documentation on new data sources, available intermediate structures, and best access practices
•Resolves S3 data ingestion issues, and is proactive in recommending long-term solutions to prevent future issues
•Responsible for the availability of all Redshift game data
•Acts as a liaison with third party provider, on behalf of timely S3 hourly data availability

Qualifications:

Education:
•Bachelor’s degree or higher in Computer Science, MIS, or equivalent experience

Required Experience:
•Minimum 3-5 years of experience with Big Data analytics and querying Big Data
•Minimum 2 years of experience with Amazon AWS

Knowledge, Skills, & Abilities:
•Advanced SQL/HQL/MySQL
•Expert on use and management of Redshift tables, schemas, and functions
•Intermediate knowledge of querying Kinesis, ability to guide the teams when needed on this
•Experience with security and administration of database users
•Experience working with Linux
•Experience with developing, scheduling, and maintaining ETL processes, especially in an AWS environment
•Experience working with 3rd party data reporting packages and ability to leverage Redshift or AWS products
•Clear and effective communication of complex ideas and analysis
•Ability to work with little direction, self-directed
•Active learner, motivated to learn without guidance
•Solutions oriented attitude of customer service
•Critical thinking and creative problem solving

Physical Requirements: Office environment

Work Conditions:  May require weekend and/or evening hours and travel

#LI-MF1
SG is an Equal Opportunity Employer and does not discriminate against applicants due to race, ethnicity, gender, sexual orientation, veteran status, or on the basis of disability or any other federal, state or local protected class. If you’d like more information about your equal employment opportunity rights as an applicant under the law, please click here EEOC Poster.

CHECK OUT OUR SIMILAR JOBS

  1. Architect Jobs
  2. Systems Engineer Jobs