Business Intelligence Architect - Utah Jazz (Salt Lake City, UT)
The Larry H Miller Sports & Entertainment Group has an immediate opening for a BI Architect. The Individual must demonstrate deep knowledge of an Active Data Warehousing environment. Candidate will be responsible for designing, developing, testing implementing and supporting complex ETL processes. Must be able to understand and analyze requirements and develop, deploy and configure ETL packages. The developer will use their experience to implement robust, maintainable solutions that meet business requirements.
Solidify and extend existing ETL Processes and Framework.
Design ETL jobs, and reusable components to implement specified business requirements
Troubleshoot and optimize ETL code; interpret ETL logs, perform data validation, dissect code, understand the benefits and drawbacks of parallelism, apply best practices using change data capture, expressions, scoping of variables, commonly used transforms, event handlers and logging providers, understand and optimize the surrogate key generation and inconsistent data type handling.
Create technical specifications documents and design process diagrams.
Process design according to current industry best practices
Establish standards to be used by the team members.
Collaborate with other team members to develop and enhance deliverables.
Develop functional specifications for data acquisition, transformation and load processes.
Stay abreast of architectural/industry changes.
Develop scripts for data file processing and process integration tasks.
Conduct code reviews and participate in technical design.
Conduct performance analysis and optimize scheduled jobs, custom SQL and T-SQL jobs.
Prepare unit test, integration test plan documents and perform unit test, system integration test; document test results.
Support BI Team during functional, UAT, regression, and performance testing.
Manage data replication from various data sources.
Create jobs that will pull data from a variety of databases and flat files
All other duties as assigned
5 years' experience implementing ETL for Data Warehouse and Business Intelligence solutions
10 year experience in RDBMS design and development, and performance tuning
Deep familiarity with database technologies
Minimum 3 years with ETL tool (SSIS, Informatica, Etc.)
5 years' experience with scheduling ETL jobs using a scheduling tool
Ability to read and write effective, modular, dynamic (parameterized) and robust code, establish and follow already established code standards, and ETL framework
Excellent troubleshooting & optimization skills: interpreting ETL logs, performing data validation, dissecting code, understanding the benefits and drawbacks of parallelism, experience with change data capture, using expressions, scoping of variables, commonly used transforms, event handlers and logging providers, ability to understand and optimize the surrogate key generation and inconsistent data type handling.
Understanding fuzzy grouping, fuzzy lookup transforms, term extraction and term lookup transforms, import and export column transforms
Experience in performance tuning, deploying and administering ETL packages, proficient in utilizing scripting.
Experience to design jobs that can be easily promoted from one (Dev) environment to another (Test or Prod) seamlessly, without modification.
Ability to create ETL specifications, unit, and system integration test cases
Clear understanding of ETL best practices
Error handling, error propagation and email notification
Ability to capture and research issues and bugs, build sample test jobs that recreate a bug, and troubleshoot the ETL until successful issue resolution.
Strong analytical and problem solving skills
Ability to work independently and as part of a team
Bachelor Degree in Information Systems or related discipline preferred. (Or equivalent work experience)
Industry-related certifications (MCITP, MCSE, MCDBA, etc.) a plus
Experience writing ETL jobs from Oracle, SQL Server, MySQL, Postgres, and CSV files
Concessions Chef and Director of Concessions Operations - Utah Jazz (Salt Lake City, UT)
All-Star Catering, a division of Larry H. Miller Sports and Entertainment, has a Senior Management position available in food concessions. All-Star Catering is the in house food and beverage provider for the Utah Jazz, Salt Lake Bees (LA Angels Triple-A Team) and Vivint SmartHome Arena.
Responsibilities will include, but not be limited to:
Protect the moral, legal and financial well-being of the Company
Continually teach associates new and better ways of doing business with and emphasis on STEWARDSHIP, ACCOUNTABILITY, LEADERSHIP and GUEST SERVICE.
Develop new food concepts, menu items and recipes
Create a safe, high quality experience for our associates
Create standards for guest experience and employee training
Provide a high quality food and beverage experience for our guests
Closely manage inventories and cash controls
Evaluate marketing and operational opportunities to maximize percaps and profitability
All other duties as assigned
Qualifications will include:
5 years of culinary experience as a chef
Certification/Degree in Business, hospitality or related field
Knowledge of profit and loss statement, cost analysis and P.O.S. systems
Knowledge of health and safety codes
Alcohol server training
5 years in high volume concession food service operation
To perform the job successfully, an individual should demonstrate the following competencies to perform the essential functions of this position:
Customer Service -the individual understands his/her role in providing service.
Oral Communication - the individual clearly identifies and expresses issues in positive or negative situations.
Planning/Organizing - the individual prioritizes and plans work activities and uses time efficiently.
Quality- the individual demonstrates accuracy and thoroughness and monitors own work to ensure quality.
Dependability - the individual is consistently at work and on time, follows instructions, responds to management direction and solicits feedback to improve performance.
Safety and Security - the individual observes safety and security procedures and uses equipment and materials properly.
Firewall Engineer - Utah Jazz (Salt Lake City, UT)
Firewall Engineers install, run, maintain, configure, troubleshoot, and repair network infrastructure. We are looking for experienced and enthusiastic network engineers with the skills needed to provide a stable production environment. We are seeking candidates that understand the importance of maintaining availability and stability within the production environment and are willing to use and implement processes and procedures that will prevent impact to the business while work is being performed. The emphasis on this position will be maintaining a series of Palo Alto Firewalls and other security related systems, but the candidates will need to be able to support VOIP, Switch\Route, Security Systems, and WLAN.
Specific Accountabilities and Responsibilities:
Protect the moral, legal and financial well-being of the Company (LHMSE)
Continually teach associates new and better ways of doing business with an emphasis on STEWARDSHIP, ACCOUNTABILITY, LEADERSHIP and GUEST SERVICE.
Implement and maintain enterprise level network systems in a 24 X 7 data center
Manage all network engineering and security aspects of our corporate environment from the edge of the network down to the endpoints
Have security on the forefront of every project and implementation.
Manage Palo Alto firewalls and Aruba Clearpass
Manage software integrations with Palo Alto and other systems
Maintain Cisco VOIP Systems
Manage WLAN implementations in multiple locations
Bring a wealth of knowledge from your experience with an ability to execute
Other duties as assigned
Knowledge and Skills
Bachelor's Degree in a technical discipline such as Computer Science, Information Systems or related field, or an up to date CCNP certification is a plus.
At least 7 years of experience in a hands-on Network Engineering with in-depth experience in multiple platforms and devices, namely Cisco routers, switches, firewalls, VPN devices, etc.
Solid understanding of TCP/IP, OSI, SAFE network design, network lifecycle, network analysis and troubleshooting techniques
Strong understanding of networking protocols and technologies: BGP, EIGRP, MPLS, IPSec/SSL VPN, Dot1q, WIFI, NAT, RSTP, SNMP, DHCP, DNS, TACACS, Syslog, WAAS, etc.
Knowledge and experience with VOIP systems
Strong understanding of Network Management and Monitoring Systems (Solarwinds, Accelops, Cisco Prime Infrastructure, etc.)
Must be able to pass a pre-employment background and drug screening
The employee must regularly lift and\or move up to 25 pounds, frequently lift and/or move up to 50 pounds, and occasionally lift and\or move up to 100 pounds.
Exposed to continuous walking, standing, twisting
Exposed to intermittent bending, squatting, kneeling and climbing stairs
Must be able to work in outside conditions, including snow, rain, wind and heat
Apply for Future Notification Only: Future Notification
Future Notification Only - NBA/WNBA/D-LEAGUE TEAMS (Various Locations, --)
If you would like to be notified of positions in the future with NBA/WNBA/D-League teams and NBA China, please press "apply" below and fill out the entire application, specifically including the name of the city (ies) (of a NBA/WNBA/D-League Team) where you would like to work. Make sure your email is correct and you check off the notification boxes, otherwise we cannot send you notifications. Once you receive notification of a job, you must come back to the site to reapply. Entering your record here does not make you an applicant to any position. If you need to update, edit, modify or delete your record, please go to “My Account-TeamWork Online” above and put in your email address and password.
When you apply for this job online, you will be required to answer the following questions:
1. List any NBA / WNBA cities in which you want to work -i.e. Philadelphia, New York, Miami, Orlando, Boston, New Jersey, Washington, Charlotte, Milwaukee, Cleveland, Toronto, Detroit, Indiana, Atlanta, Chicago, Utah, San Antonio, Dallas, Minnesota, Denver, Houston, Memphis, New Orleans, Sacramento, LA Lakers, LA Clippers, Portland, Phoenix, Seattle, SF