What are the responsibilities and job description for the IT, Database Analyst position at CHUCK E CHEESE?
At CEC Entertainment, we build careers around great food, family, and fun! Our purpose and our passion is to create the best place for kids and families to eat and play!
Job Description
The CEC Information technology portfolio is built around third-party service providers, SaaS solutions, and a small number of custom applications. Key systems include the NCR Aloha platform, the Workday platform, SEMNOX, and a Microsoft Azure and Microsoft O365. The solutions delivery approach is to maintain a lean IT organization and use a "flex staffing" strategy to assemble the skills and resources needed to successfully deliver projects and maintain the existing applications and platforms. These two characteristics combine to create a dynamic environment for project planning and execution involving internal and external resources, partners, and vendors.
We are seeking a talented Database Analyst to join our team. The ideal candidate will have a strong foundation in database design, development, and administration, with a particular focus on Microsoft SQL Server. This role involves working closely with software engineers, data engineers, data scientists, and business analysts to ensure data integrity, performance, and security.
Major Responsibilities include but are not limited to :
Design, develop, and maintain complex database schemas, including tables, views, indexes, and stored procedures.
Optimize database performance through query tuning, indexing, and partitioning strategies.
Develop and implement data integration solutions using Azure Synapse Analytics and Azure Data Factory.
Create and maintain data models, including conceptual, logical, and physical data models.
Collaborate with business analysts to understand data requirements and translate them into effective database designs.
Ensure data quality and consistency through data cleansing processes and validation.
Monitor database performance and identify and resolve issues proactively.
Utilize Azure DevOps to manage source control, build pipelines, and release pipelines.
Implement automated testing and deployment processes for database changes.
Implement and maintain database security measures, including user access controls, encryption, and auditing.
Ensure compliance with data privacy regulations (e.g., GDPR, CCPA).
Job Requirements :
Bachelor's degree in Computer Science, Data Science, Systems Engineering or relevant field of study, or equivalent work experience
10 years of IT and business industry work experience
Strong proficiency in Microsoft SQL Server and T-SQL.
Extensive experience with Azure Data Platform, including Azure Synapse Analytics, Azure Data Factory, and Azure SQL Databases.
Experience converting and optimizing legacy SSIS and SSRS.
Demonstrated ability in data modeling techniques and tools to deliver high performing solutions.
Understanding of data warehousing and data lake concepts.
Familiarity with Agile methodologies and DevOps practices.
Strong analytical and problem-solving skills.
Preferred Qualifications :
Experience with Azure ADFS and identity management.
Knowledge of scripting languages (e.g., Python, PowerShell).
Experience developing Azure PowerApps
If you are a passionate and skilled database analyst who enjoys working with data and solving complex problems, we encourage you to apply.
Physical Demands
To perform the duties of this position, the incumbent must have the ability to sit, walk, stand, bend, twist, reach, and carry, lift, pull, push between 1 - 25 lbs. Incumbent must use a computer, with repetitive movement of both hands. Incumbent must be able to work an 8-hour shift, with frequent overtime.
Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
Diversity #Equity #Culture
The Company :
CEC Entertainment, LLC ("CEC"), headquartered in Irving, Texas is the nationally recognized leader in family entertainment and dining with its Chuck E. Cheese, Peter Piper Pizza brands and virtual kitchen concept, Pasqually's Pizza & Wings.
As the place where half a million happy birthdays are celebrated every year, Chuck E. Cheese's goal is to create positive, lifelong memories for families through fun, food, and play and is the place Where a Kid Can Be a Kid. Committed to providing a fun, safe environment, Chuck E. Cheese helps protect families through industry-leading programs such as Kid Check. As a strong advocate for its local communities, Chuck E. Cheese has donated more than $19 million schools through its fundraising programs. Peter Piper Pizza features dining, entertainment and carryout with a neighbor-hood pizzeria feel and "pizza made fresh, families made happy" culture.
Peter Piper Pizza takes pride in delivering quality food and fun that reconnects family and friends. Created in 2020, Pasqually's Pizza & Wings offers a distinct, customized eating experience outside of a restaurant environment that amplifies classic pizza and wings and operates out of 400 ghost locations nationwide. The Company and its franchise operate a system of nearly 600 Chuck E. Cheese and more than 120 Peter Piper Pizza venues, with locations in 47 states and 17 foreign countries and territories. For more information, visit chuckecheese.com, pasquallyspizza.com, and peterpiperpizza.com.
Benefits :
CEC Entertainment offers a wide variety of benefits including medical, dental, vision, life, disability, and 401(k) retirement savings plan to eligible U.S. employees as part of their overall employment package. We also offer job training and career growth opportunities. Chuck E. Cheese is a "Work Today, Get Paid Tomorrow" employer.
At CEC Entertainment, we believe that our workforce should reflect the diverse backgrounds, experiences, and perspectives of many guests we serve. As an Equal Opportunity Employer, we do not discriminate against applicants due to race, ancestry, color, genetics, gender identity, gender expression, sexual orientation, national origin, religion, age, physical or mental disability, pregnancy, veteran status, or on the basis of any other federal, state or local protected class.
