Job posting has expired

Lead Data Analyst

American Multi-Cinema, Inc.
401(k)
United States, Kansas, Leawood
11500 Ash Street (Show on map)
Sep 17, 2024
Lead Data Analyst Job Summary The Data Analyst, Lead is a technical position that requires strong data architecture discipline as related to technical solution design, along with excellent communication skills. This position is responsible for gathering data requirements, designing, executing, and updating data models, performing data analysis, and ensuring data quality to support AMC's strategic information objectives. This position is based in Leawood, KS and is not eligible for relocation. Job Description Do you speak in movie quotes? Have a movie moment that changed your life? If you love all things movies, you may be a perfect fit for our team! AMC has propelled industry innovation since 1920, and we continue to innovate by delivering premium sight and sound, new and improved food and beverage options, and diverse content in our state-of-the-art theatres. What you'll be doing: Create and modify logical and physical database models for AMC's Enterprise Data Team. Produce Data Definition Language (DDL) to create, alter, and drop objects for on-premises SQL Servers, Azure SQL databases, and Azure Synapse Workspaces. Develop and refine Structured Query Language (SQL) queries, updates, inserts, and deletes. Create and maintain data objects (e.g., stored procedures, views). Analyze and profile data sources to inform data architecture decisions. Create source-to-target mapping documents that define transformations and business rules using tools like Erwin or equivalent. Support integration developers and Quality Assurance (QA) analysts in developing and testing Azure Pipelines and Data Stage pipelines. Ensure adherence to best practices and data governance policies, including utilizing provided enterprise toolsets. Define internal and enterprise data service standards and promote industry standards in data management. What we need from you: Bachelor's degree or equivalent combination of education and experience in related field. 7+ years of relevant experience with Data Modeling tools, source to target Data mapping and defining Extract, Transform, Load (ETL) processes, and hands-on SQL scripting. 5+ years of experience with Data profiling, Gap analysis, and Impact analysis. Working knowledge of relational, master data, and data warehouse database concepts. Proficient in data modeling for both transactional and dimensional databases. Expert ability to work with SQL databases, including working knowledge of SQL Server Database Management System (DBMS). Solid understanding of data quality and governance concepts, tools, and methods. Strong organizational and planning skills with the ability to prioritize tasks effectively. Ability to provide technical leadership, mentorship, and guidance. Effective verbal and written communication skills. Advanced analytical, critical thinking, and problem-solving skills. What we also value: Hands-on experience with Python programming. Knowledge of real-time analytics and Business Intelligence (BI) platforms such as Tableau. Hands on experience with Azure Cloud platform, including Azure SQL database, Azure Synapse, and Azure Data Factory. Working knowledge of Hadoop platforms and data components like Hive, Hbase, or Impala Openness to innovation and individual growth, with respect for self and others. AMC team members enjoy a very competitive benefits package including a hybrid (remote/in-office) schedule for most positions, accrued vacation/absentee time, medical/dental/vision coverage, 401(k) match, an open and casual work environment equipped with Coca-Cola Freestyle machines, half off eats and drinks at the theatre, and most importantly for us movie people...FREE movies at any of our 600+ theatres nationwide! AMC's company culture is focused on innovation and diversity to ensure that we provide the latest and greatest experience for our guests and associates. We lead by example in doing what is right and take responsibility for our own results and our company's success. Our open work environment promotes teamwork and unscripted conversations, resulting in fast solutions and therefore, better outcomes. We appreciate your interest in AMC and look forward to seeing you at the movies! AMC and its subsidiaries are committed to equal employment opportunity and complies with all applicable federal, state, and local employment laws. AMC strictly prohibits and does not tolerate discrimination and will provide equal employment opportunities to all applicants without regard to an applicant's race, color, religion, creed, gender, sex (including pregnancy), sexual orientation, gender identity or expression, national origin, age, disability, military status, veteran status, genetic information, or any other reason prohibited by applicable federal, state, or local law, regulation, or ordinance. This policy applies to all terms and conditions of employment, including, but not limited to, hiring, promotion, discipline, compensation, benefits, and termination of employment. Minimum Job Requirements 7+ years of relevant experience with Data Modeling tools, source to target Data mapping and defining Extract, Transform, Load (ETL) processes, and hands-on SQL scripting. 5+ years of experience with Data profiling, Gap analysis, and Impact analysis. Working knowledge of relational, master data, and data warehouse database concepts. About AMC AMC amazing. That's the promise we deliver to nearly 35,000 associates, 240 million guests domestically, and 350 million guests worldwide each year. AMC has propelled industry innovation since 1920, and we continue to innovate by delivering premium sight and sound, new and improved food and beverage options, and diverse content in our state-of-the-art theatres. We focus on delivering friendly, superior service to our guests. We lead by example, have fun, and give back to the communities in which we live and work. If you feel motivated and energized by our culture, and if you can name your three favorite movies in the next 30 seconds, then AMC may be the right place for you. We offer competitive compensation, excellent benefits, and an environment that encourages teamwork, inclusion, collaboration, and results. Department Information Management Systems Job Address 1 One AMC Way Job Address 2 11500 Ash Street City Leawood State Kansas Zip Code 66211 Employment Status Full Time Pay Rate Type SALARY Relocation Eligibility No Job ID 27131BR