Choctaw Nation of Oklahoma
Senior Database Marketing Analyst
Choctaw Nation of Oklahoma - Durant, Oklahoma, us, 74702
Work at Choctaw Nation of Oklahoma
Overview
- View job
Overview
Job Description
Job Purpose or Objective(s):
The Sr. Database Marketing Analyst develops SQL code to retrieve data from the source systems, the construction of templated report shells, as well as the creation of automated reports for distribution. The Sr. Database Marketing Analyst also serves as the primary contact and support of the Player Development Department. You will report to the Marketing Analytics Manager.
Primary Tasks:
1. You will create Pro/Post Forma Analysis for the tracked database with a primary focus in evaluating Player Development impact on the business.
2. You will provide consolidated performance reports for database health with a primary focus on Player Development performance.
3. You will aid in the loading of event tracking data and sales goals into the player tracking software.
4. You will evaluate and make recommendations for players for inclusion in the Player Development hosting program.
5. You will develop complex SQL queries to retrieve information from source systems and create tables and views of data from multiple source tables.
6. You will perform query tuning and enhancements to speed the process of SQL reports.
7. You will create automation of reports using SSRS and RB3.
8. You will create monthly and ad hoc reports from the Accounting and Player Tracking Systems.
9. Other tasks as assigned.
Minimum Requirements:
•Bachelor's degree in marketing, accounting, finance, business administration, or related field and three (3) years of database marketing/analytics experience, OR seven [7] years of directly related experience in lieu of education.
•Advanced Microsoft Office skills including, higher level functions in EXCEL such as Pivot Tables, sumifs, Nested formulas, V/H lookups, Macros, Graphing, etc.
•Experience with computer report writing and database inquiry software such as ACCESS, SQL or equivalent.
•Ability to read, analyze, interpret and make recommendations based on statistical reports
About the Choctaw Nation
The Choctaw Nation is the third-largest Indian nation in the United States, with over 200,000 tribal members and more than 11,000 employees. The first tribe over the Trail of Tears, historic boundaries are in the southeast corner of Oklahoma. The Choctaw Nation's vision, "Living out the Chahta Spirit of faith, family and culture," is evident as it continues to focus on providing opportunities for growth and prosperity.
Benefits Free gym membership Free access to employee health clinic Free lunch for casino & resort associates Earned wages access once per week for hourly Associates Pet insurance Paid vacation / sick time Medical / Dental / Vision 401(K) with company match College tuition reimbursement Short-term disability, long-term disability, and family leave Employee assistance program Employee prescription program CNO Paid Life Insurance Teladoc On Site Dental Clinics (Jet Dental) On Site Mammogram Services Free diabetes and hypertension monitoring benefit (Livongo) Accolade- Concierge Benefits Program Wellness Program that equals savings on health insurance cost (Virgin Pulse) Maternity Care Program (Benefits provided by the Choctaw Nation are based on employment classification) CNO was selected as a winner in both HRDUS' and Forbes' 2022 "Employer of Choice" competitions:
Choctaw Nation of Oklahoma received recognition as one of six Best Places to Work in the United States as selected by HRDUS Choctaw Casinos & Resorts received recognition from Forbes as a Best Employer for Diversity in the Travel & Leisure category. Forbes also recognized the Choctaw Casino and Resorts as one of America's Best Employers for New Graduates.
#LI-onsite
Responsibilities
1. Create Pro/Post Forma Analysis for the tracked database with a primary focus in evaluating Player Development impact on the business. 2. Provide consolidated performance reports for database health with a primary focus on Player Development performance. 3. Aid in the loading of event tracking data and sales goals into the player tracking software. 4. Evaluate and make recommendations for players for inclusion in the Player Development hosting program. 5. Develop complex SQL queries to retrieve information from source systems and create tables and views of data from multiple source tables. 6. Perform query tuning and enhancements to speed the process of SQL reports. 7. Create automation of reports using SSRS and RB3. 8. Create monthly and ad hoc reports from the Accounting and Player Tracking Systems. 9. Perform other duties as assigned.
Qualifications
•Bachelor's degree in marketing, accounting, finance, business administration, or related field and three (3) years of database marketing/analytics experience, OR seven [7] years of directly related experience in lieu of education. •Advanced Microsoft Office skills including, higher level functions in EXCEL such as Pivot Tables, sumifs, Nested formulas, V/H lookups, Macros, Graphing. •Experience with computer report writing or database inquiry software such as ACCESS, SQL or equivalent. •Ability to make recommendations based on statistical reports •Ability to maintain organization, has integrity, and maintain confidential information.
Job Purpose or Objective(s):
The Sr. Database Marketing Analyst develops SQL code to retrieve data from the source systems, the construction of templated report shells, as well as the creation of automated reports for distribution. The Sr. Database Marketing Analyst also serves as the primary contact and support of the Player Development Department. You will report to the Marketing Analytics Manager.
Primary Tasks:
1. You will create Pro/Post Forma Analysis for the tracked database with a primary focus in evaluating Player Development impact on the business.
2. You will provide consolidated performance reports for database health with a primary focus on Player Development performance.
3. You will aid in the loading of event tracking data and sales goals into the player tracking software.
4. You will evaluate and make recommendations for players for inclusion in the Player Development hosting program.
5. You will develop complex SQL queries to retrieve information from source systems and create tables and views of data from multiple source tables.
6. You will perform query tuning and enhancements to speed the process of SQL reports.
7. You will create automation of reports using SSRS and RB3.
8. You will create monthly and ad hoc reports from the Accounting and Player Tracking Systems.
9. Other tasks as assigned.
Minimum Requirements:
•Bachelor's degree in marketing, accounting, finance, business administration, or related field and three (3) years of database marketing/analytics experience, OR seven [7] years of directly related experience in lieu of education.
•Advanced Microsoft Office skills including, higher level functions in EXCEL such as Pivot Tables, sumifs, Nested formulas, V/H lookups, Macros, Graphing, etc.
•Experience with computer report writing and database inquiry software such as ACCESS, SQL or equivalent.
•Ability to read, analyze, interpret and make recommendations based on statistical reports
About the Choctaw Nation
The Choctaw Nation is the third-largest Indian nation in the United States, with over 200,000 tribal members and more than 11,000 employees. The first tribe over the Trail of Tears, historic boundaries are in the southeast corner of Oklahoma. The Choctaw Nation's vision, "Living out the Chahta Spirit of faith, family and culture," is evident as it continues to focus on providing opportunities for growth and prosperity.
Benefits Free gym membership Free access to employee health clinic Free lunch for casino & resort associates Earned wages access once per week for hourly Associates Pet insurance Paid vacation / sick time Medical / Dental / Vision 401(K) with company match College tuition reimbursement Short-term disability, long-term disability, and family leave Employee assistance program Employee prescription program CNO Paid Life Insurance Teladoc On Site Dental Clinics (Jet Dental) On Site Mammogram Services Free diabetes and hypertension monitoring benefit (Livongo) Accolade- Concierge Benefits Program Wellness Program that equals savings on health insurance cost (Virgin Pulse) Maternity Care Program (Benefits provided by the Choctaw Nation are based on employment classification) CNO was selected as a winner in both HRDUS' and Forbes' 2022 "Employer of Choice" competitions:
Choctaw Nation of Oklahoma received recognition as one of six Best Places to Work in the United States as selected by HRDUS Choctaw Casinos & Resorts received recognition from Forbes as a Best Employer for Diversity in the Travel & Leisure category. Forbes also recognized the Choctaw Casino and Resorts as one of America's Best Employers for New Graduates.
#LI-onsite
Responsibilities
1. Create Pro/Post Forma Analysis for the tracked database with a primary focus in evaluating Player Development impact on the business. 2. Provide consolidated performance reports for database health with a primary focus on Player Development performance. 3. Aid in the loading of event tracking data and sales goals into the player tracking software. 4. Evaluate and make recommendations for players for inclusion in the Player Development hosting program. 5. Develop complex SQL queries to retrieve information from source systems and create tables and views of data from multiple source tables. 6. Perform query tuning and enhancements to speed the process of SQL reports. 7. Create automation of reports using SSRS and RB3. 8. Create monthly and ad hoc reports from the Accounting and Player Tracking Systems. 9. Perform other duties as assigned.
Qualifications
•Bachelor's degree in marketing, accounting, finance, business administration, or related field and three (3) years of database marketing/analytics experience, OR seven [7] years of directly related experience in lieu of education. •Advanced Microsoft Office skills including, higher level functions in EXCEL such as Pivot Tables, sumifs, Nested formulas, V/H lookups, Macros, Graphing. •Experience with computer report writing or database inquiry software such as ACCESS, SQL or equivalent. •Ability to make recommendations based on statistical reports •Ability to maintain organization, has integrity, and maintain confidential information.