Raising Cane's Business Intelligence Developer in Plano, Texas
Business Intelligence Developer
# of Openings
More information about this job
The Business Intelligence / Data Warehouse Developer develops Raising Cane’s BI systems and reporting functions, including responsibility for administration, documentation, support, and troubleshooting of these systems. This position participates in all phases of the software implementation process including package and custom development, requirements gathering and analysis, functional design, technical design, coding/report writing, testing, implementation, and post implementation support. We are seeking a hands-on developer and problem-solver with deep database design, ETL, report development, and ad hoc analysis skills. This person will contribute to efforts to ensure the business intelligence platform and tools are meeting the Company’s current objectives and future goals, and will re-engineer processes and re-architect solutions to maximize security, reliability, scalability, availability, and supportability. Must be highly collaborative with internal IT team members, business partners, external consultants and vendors to engage them in implementing BI solutions which deliver operational excellence.
Design and develop solutions using Microsoft’s BI Platform: SQL Server database, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS) and SharePoint.
Understand business needs, gather requirements, prepare development estimates, create specification, testing, and user documentation in collaboration with your team members.
Develop high quality ETL packages/processes using SSIS, reports using SSRS, and OLAP cubes using SSAS.
Raise critical technical issues with key stakeholders in a timely manner to ensure quality deliverables.
Provide technical application support to non-technical user community.
Assist in the evaluation and implementation of selected data mining and analysis tools.
Collaborate with your IT peers and business partners to ensure focus on production support, service requests and roadmap initiatives to ensure a balanced delivery of services and solutions aligned with business objectives.
Building strong relationships with platform providers and external development resources.
Analyze and predict BI platform and tool trends, focused on BI best practices, to maintain stability and agility of the enterprise’s BI infrastructure and systems.
Collaborate in team processes and procedures to ensure timely, high quality delivery and highly available systems.
Proactively research and implement courses of action to prevent system/security problems and maintain compliance where needed.
Communicate team and project status to Director BI and Raising Cane’s IT Leadership.
Architecture / Design:
Understand database concepts of referential integrity, indexes, keys and table metadata
Understand basic ETL concepts of data flow, data extraction, data consolidation, change data capture and transformation.
Perform data analysis and data profiling to assist with data warehouse / dimensional model design.
Familiar with data warehouse methodologies and their strengths and weaknesses e.g. Kimball/dimensional (OLAP, Star & snowflake schemas), Inmon/normalized, Linstedt/Data Vault
Familiarity with normalized and relational logical and physical data model creation
Platform / Development
Have hands-on development experience using SQL Server RDBMS including T-SQL, SSIS/DTS, SSRS, and SSAS/MDX.
Skilled at SQL coding including query optimization, stored procedures development, and performance tuning capabilities with SQL Server databases.
Capable database administration skills, particularly view creation and table optimization (indexing)
Knowledge of C#, asp.net, Visual Studio, DTS packages, Performance Point and XML
Nice to have: Data visualization (Power BI, Tableau, Cognos, Qlik) and DW platforms (Microsoft PDW, Netezza, Teradata)
Nice to have: Familiarity with mobile app development.
Testing, Troubleshooting and Support
Recognize data trends and correct data quality issues quickly, completely, and permanently.
Unit and system test SSIS ETL packages, SSRS reports, and SSAS cubes.
Participate and lead design reviews.
Troubleshoot SSIS, SSRS and SSAS processing problems.
Have a solid aptitude for our business and the role IT & BI play in it.
Present a collegial and confident “bedside manner” to IT and non-IT colleagues:
Function equally well in team settings as well as on an individual basis.
Establish and maintain good working relationships with internal and external customers.
Facilitate satisfactory communication and resolution of problems.
Learn new technologies and products quickly.
Have solid organizational skills and ability to multi-task in a fast paced environment.
Speak clearly and listen actively and effectively, including the ability to explain complex ideas to others with varying levels of expertise both inside of and outside of the organization.
Develop clear, effective, and business-user-oriented written documentation.
Attitude / Style: Accountability and Responsiveness:
- See It: Recognize and acknowledge the reality of situations, and be flexible and adaptive.Own It: Accept responsibility for the realities you create for yourself and others, and project a sense of quality through expertise, responsiveness, sense of urgency and action-orientation.Solve It: Find and implement new solutions to problems, and change reality through agile innovation.Do It: Demonstrate commitment, courage, follow-through, empathy, collaboration, and consultation
Education & Experience:
Bachelor’s Degree in computer science or related technical discipline or equivalent combination of education/technical certifications, training, or work experience.
Minimum six (6) years of IT experience focused on software development.
Minimum three (3) years of database design/development experience.
Minimum three (3) years of experience with business intelligence practices and software.
Minimum three (3) years of experience with each of SSAS, SSRS, and SSIS.
Minimum three (3) years of experience with data modeling, data validation and error reporting.
Restaurant and/or retail IT experience is a plus
The intellectual and physical demands described below are representative of what must be met by a Crewmember to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable Crewmembers with disabilities to perform the essential functions.
Champion Change - Challenges the status quo and champions new initiatives; acts as a catalyst of change and stimulates others to change; paves the way for needed changes; manages implementation effectively.
Seasoned Judgment - Applies broad knowledge and seasoned experience when addressing complex issues; defines strategic issues clearly despite ambiguity; takes all critical information into account when making decisions; makes timely, tough decisions.
Shaping Strategy - Develops distinctive strategies to achieve competitive advantage; translates broad strategies into specific objectives and action plans; aligns the organization to support strategic priorities.
Coach & Develop - Accurately assesses strengths and development needs of employees; gives timely, specific feedback, and helpful coaching; provides challenging assignments and opportunities for development.
Inspiring Trust - Earns the confidence and trust of others; shows consistency between words and actions; delivers on commitments; produces high-quality work; demonstrates high standards of ethical conduct; protects confidential information; does not omit controversial information or change information to suit others.
Drive for Stakeholder Success - Sets and pursues aggressive goals; drives for results; demonstrates a strong commitment to organizational success; works to do what is best for all stakeholders (customers, equity holders, crewmembers, etc.).
Foster Open Communication - Creates an atmosphere in which timely and high quality information flows smoothly between self and others; encourages the open expression of ideas and opinions. Attracting & Developing Talent - Attracts high caliber people; develops teams and talent with diverse capabilities; accurately appraises the strengths and weaknesses of others; provides constructive feedback; develops successors and talent pools.
Driving Execution - Assigns clear authority and accountability; directs change while maintaining operating effectiveness; integrates efforts across units and functions; monitors results; tackles problems directly and with dispatch.
Professionalism - Consistently treats individuals with dignity and respect, recognizing the importance of cultural differences. Has and maintains a positive sense of humor and uses humor appropriately. Embraces, communicates and demonstrates company values and ethics. Maintains reasonable expectations of self and others when balancing time and performance demands with personal and professional needs. Continually seeks new and creative approaches to work and solutions to problems.