at National Restaurant Association in Chicago, Illinois, United States
Job Description
The National Restaurant Association and National Restaurant Association Educational Foundation are proud to be part of a thriving and highly respected industry, providing hospitality, opportunity, and quality of life. And much like the industry we represent, we have a dynamic, diverse, and inclusive culture, grounded in trust, hospitality, collaboration, and innovation. These are the core values that inspire our work, and what we are looking for in a Senior Data Developer.
Data is at the core of what drives the success of the National Restaurant Association and National Restaurant Association Educational Foundation. We have a large constituent of restaurants, restaurant professionals, and supporting organizations, where effective management of our data allows us to deliver outstanding services, products, and advocacy for the industry.
As Senior Data Developer, you must be able to conceive and portray the data picture. You will be responsible for the solution design and development, and health and welfare of all corporate database environments both on-prem and cloud. Responsibilities also include creation/maintenance/architecture of database designs, coordination of system upgrades, and providing guidance/mentoring to junior staff. Working as part of the Database Services team, you will partner with Project Management, Business Solutions Architecture, and Application Development to ensure that projects are delivered to spec, on time, and within budget.
Ideal candidates bring proven experience and thought leadership in data modeling and database development, as well as data integration and analysis. Position requires a highly collaborative, analytical, and forward-thinking self-starter, who takes initiative and thrives in a fast-paced environment.
This is a Chicago based position with hybrid flexibility.
If this sounds like you, please see below for further insights. We look forward to hearing from you!
We are proud to offer our team members comprehensive benefits, designed to support their financial, professional, and personal well-being. In addition to outstanding healthcare coverage (medical, dental and vision), competitive salaries, generous vacation and leave time, we offer a matching 401(k) plan, a unique collection of corporate discounts and memberships, as well as programs to support career and skills development, including coaching, learning and tuition assistance, and so much more.
Responsibilities:
- Design and implement effective and scalable database solutions to store and retrieve organization data.
- Responsible for the architecture, modeling, design, development, testing, implementation, and maintenance of the data integration/ETL, procedures and structures which populate and grow our databases, data marts and tables.
- Provide direction to fellow data integration developers on solution design and implementation.
- Develop data flows that can leverage both on premise and cloud architectures.
- Partner with stakeholders including the business teams and architecture teams to assist with data-related technical issues and support data infrastructure needs.
- Monitor system performance by performing regular tests, troubleshooting, and integrating new features.
- Guide and coach staff members on standards, guidelines, best practices, and adherence to set standards.
- Manage requests, scheduling, and support for production reports.
- Work with Business Units to ensure accuracy of data and reports.
- Ensure data compatibility and compliance to appropriate regulations across all platforms.
- Provide input into and drafts IT policies and procedures as applicable.
- Work as independent contributor, dealing with scheduled activities and unforeseen problems and circumstances.
- Define requirements, perform analysis, and support application programming, testing and implementation tasks.
Requirements:
Essential Technical Skills/Experience:
- Bachelor’s degree in Information Systems, Computer Science, Data Processing or equivalent knowledge and/or work experience or other related advanced degree.
- Minimum five years of database development experience with Microsoft SQL Server on-prem, Azure SQL, Synapse Analytics.
- Minimum five years of data warehousing experience preferably utilizing the Microsoft BI Stack.
- Minimum of three years of Data Modeling experience in ERWin Data Modeler or similar tool.
- Experience with NetSuite is highly desirable.
- Experience with DevOps and Agile.
- Experience with Workato is highly desirable.
- Experience with Monitoring, Performance Tuning, Security, and Configuration of SQL Server environments 2008 R2, 2012 thru 2022 and Azure SQL and Synapse Analytics.
- Experience in SSRS and Power BI.
- Experience with Data Factories and Pipelines.
- Extensive experience in the use of the T-SQL Language and stored procedures, triggers, SSIS, SSRS, and data modeling.
- Ability to apply project management skills to coordinate and manage tasks with users, IT Infrastructure and IT Analysis and Development units.
- Experience working in an Agile environment (Scrum, Lean, Kanban) is a plus.
Essential Skills/Knowledge:
- Ability to persuasively communicate complex concepts and programs across technical and non-technical audiences.
- Highly effective time management, organizational, problem-solving and priority setting skills.
- Exceptional analytical and critical thinking skills.
- Strong interpersonal and diplomacy skills.
- Knowledge and experience in all phases of the development life cycle.
- Strong technical aptitude.
- Ability to work as part of a team and to work independently; a self-initiator, versatile and assumes risk with responsibility.
- Significant business and stakeholder relationship-building experience.
- Significant communication skills in written and verbal formats; showcases clear and concise manner.
We are an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, sexual orientation, gender identity, or national origin, age, disability status, genetic information and testing, family, and medical leave, protected veteran status, or any other characteristic protected by law. We strongly encourage women, people of color, people with disabilities and veterans to apply for our job openings. This commitment supports our policy of developing and capitalizing on the abilities of all our team members, as well as selecting, developing, and promoting those who are best qualified.
