Job DescriptionResponsible for the advanced design, development, optimization, and governance of business intelligence solutions. This role provides strategic guidance, leads complex BI initiatives, and ensures the reliability, scalability, and performance of BI tools that empower leadership to make informed, data-driven decisions
Responsibilities- Leads the design, coding, testing, debugging, and enhancement of BI tools and solutions using industry-leading best practices and architectural standards.
- Performs advanced analysis and documentation of complex business processes, data flows, and operational practices, recommending strategic improvements.
- Partners with business stakeholders to translate high-level business strategies and analytical needs into robust BI architectures, models, and automated solutions.
- Oversees and performs advanced maintenance, monitoring, and performance tuning of BI reporting, analytics, and data pipeline environments.
- Develops sophisticated analytical models, KPIs, and multi-dimensional data structures that support forecasting, what-if analysis, and predictive capabilities.
- Designs and implements solutions that transform raw data into high-value insights through dashboards, self-service analytics, data visualizations, and reporting frameworks.
- Leads the development of solutions that identify patterns, trends, and opportunities using advanced analytics and automation.
- Provides mentorship, technical leadership, and training to BI team members; reviews code and promotes standardized methodologies across the BI practice.
- Creates and maintains detailed technical documentation, including architectural diagrams, system design specifications, data lineage, and governance standards.
- Establishes and enforces BI development standards, data quality practices, and agile methodologies to drive team efficiency and solution reliability.
- Leads large-scale, cross-functional BI and reporting projects, ensuring alignment with organizational goals and accountability for timelines, quality, and delivery.
- Serves as a subject matter expert (SME) for BI tools, data architecture, data warehousing, ETL/ELT processes, and analytics best practices.
- Performs other job-related duties as assigned.
SUPERVISORY/MANAGEMENT AUTHORITYLeads complex BI initiatives and mentors other developers but does not have direct supervisory responsibility. Guides technical direction, solution design, and best practices across the BI function.
QualificationsEDUCATION AND EXPERIENCEBachelor's degree in computer science, MIS, or related field, and a minimum of five (5) to seven (7) years of experience in BI development, data warehousing, or advanced analytics; or an equivalent combination of education, technical training, and progressively responsible BI experience. Experience with enterprise project management tools such as Azure DevOps or Jira required.
KNOWLEDGE, SKILLS AND ABILITIES- Knowledge of Data Analysis Expressions (DAX).
- Expert-level knowledge of DAX, SQL, data modeling, and BI solution architecture.
- Advanced experience with visualization tools such as Power BI, Tableau, or others.
- Advanced knowledge of SQL Server, SSMS, SSIS, SSRS, and enterprise BI platforms, with a working understanding of cloud-based analytics and Databricks (Delta Lake, Unity Catalog, and Spark-based ETL).
- Deep expertise in ETL/ELT design, orchestration, and automation.
- Strong knowledge of data warehouse design principles and cloud-based data storage solutions (e.g., data lakes, data factory, and distributed processing environments).
- Excellent ability to document complex systems, data structures, design specifications, and BI governance playbooks.
- Ability to create, optimize, and manage complex SQL structures including stored procedures, views, and performance-tuned queries.
- Ability to mentor junior and mid-level BI developers and support enterprise-wide analytics training.
- Strong analytical, problem-solving, and critical-thinking skills with the ability to translate ambiguous needs into structured BI solutions.
- Ability to obtain and maintain licensing by the appropriate gaming authority.
- Must have and maintain a valid driver's license.
WORK ENVIRONMENTWork is primarily performed in a hybrid environment of remote and a climate-controlled office setting. Work may require travel, including overnight stays. Work will require varied shifts including, weekends and holidays, as needed (on call).
Company:Cherokee Nation Entertainment
