Business Intelligence Architect

As a Business Intelligence Architect on the FP&A team, you will be the technical lead driving the architecture and data design strategy for the company with the opportunity to shape the overall design and direction of Potawatomi’s data and analytics platform, propose best practice data management principles, and design solutions using the latest technologies. While carrying out the job duties listed below you will contribute to our continued success by providing unsurpassed guest service, personal, and professional dedication to our Mission, Vision, and Values, and demonstrating a high level of integrity and ethical standards.

Principal Duties and Responsibilities (*Essential Functions)

1. *Lead the design, development, and analysis of data architecture and warehousing approaches. Ensure strategies meet operational requirements, such as scalability, maintainability, security, reliability, extensibility, flexibility, availability, and manageability.
2. *Take ownership for performance and usability of the business intelligence environment.
3. *Provide strategic input for the organization’s business intelligence roadmap. Develop plans for implementation, continued evolution, and ongoing operational support.
4. *Mentor, coach, motivate, and provide direction to team members.
5. *Recognize and adopt best practices in reporting and analysis, including data quality and integrity, test design, analysis, validation, and documentation.
6. Keep current with the industry’s latest trends and technologies and seek opportunities to bring advanced analytical techniques and solutions to the business intelligence space.
7. Provide back-up and support to management.
8. Ensure full compliance with departmental internal controls, policies, procedures, and regulations.
9. Perform other duties as assigned.

1. A Bachelor's degree in Data Analytics, Computer Science, Software Engineering, Information Technology, or related field and 5 years of business intelligence, business analytics, or data warehousing experience primarily utilizing the Microsoft SQL Server stack (SSIS, SSAS and SSRS) are required. Master’s degree preferred.
2. Experience leading a development team preferred.
3. Comprehensive data warehouse analysis and design experience, with full knowledge of data warehouse methodologies, data modeling, and ETL technologies.
4. Office skills must include the ability to use standard office equipment and the ability to demonstrate advanced knowledge of MDX, SQL, SSAS, SSRS, and Microsoft Excel. Intermediate knowledge of Microsoft Power BI, DAX, R, or Python preferred.
5. The ability to work with limited supervision, and work independently in a highly collaborative team setting.
6. The ability to communicate ideas in both technical and user-friendly language.
7. Knowledge of a formal project management methodology. Experience with agile development methodologies preferred.
8. Working knowledge of source control and use of a software development lifecycle system such as TFS or JIRA preferred.
9. The ability to maintain discretion in handling confidential information.  
10. The ability to interact and communicate with guests and team members at all levels of the organization professionally, in verbal and written form, including the ability to speak in front of small groups and work in a team environment.
11. The ability to work irregular hours and extended shifts including late nights, early mornings, weekends, and holidays.
12. While performing the duties of this job, the team member is required to talk, hear, stand, sit, walk, climb, balance, stoop, kneel, crouch, and move freely throughout the office and property for duration of scheduled shift.  The team member is frequently required to use hands to handle or feel objects, tools, or controls, and reach with hands and arms.   The team member must be able to operate a personal computer. The team member is required to lift, carry, push, pull, or move objects up to 10 pounds on a regular basis and up to 25 pounds occasionally.  Team member must wear all required Personal Protective Equipment (PPE) while performing job duties. Specific vision abilities required by this job include close vision, distance vision, color vision, peripheral vision, depth perception, and the ability to adjust focus.     

Working Conditions
The noise level is usually moderate. When on the casino floor the noise level increases. The work environment is smoke free, when on the casino floor it is not smoke free.

Disclaimer
The above statements are intended to describe the general nature and level of work being performed by people assigned to this job.  They are not intended to be an exhaustive list of all qualifications, responsibilities, duties, and skills required.