Job Description
The Sr Programmer Analyst – MicroStrategy will provide technical expertise in developing and maintaining business intelligence applications. Create technical design specifications from business/functional requirements. Work with internal stakeholders to clarify system requirements as appropriate. Configure, program/create business intelligence functionality and unit test development work to ensure quality. Work within Darden’s SDLC methodology and adhere to technical architecture standards. Proactively identify potential problems and issues and actively communicate and manage issues to resolution. Work closely with multiple functional areas providing assistance to users to effectively leverage the Darden Data Warehouse and Business Intelligence platform.
ROLES AND RESPONSIBILITIES:
-Work closely with key stakeholders and other project team members to understand and prioritize functional requirements and information needs. Participate in the development of functional requirements and design specifications as appropriate.
-Develop, create and document technical specifications and designs from which applications and/or technical solutions can be developed that satisfy requirements and envisions potential future requirements and business needs to ensure solutions are flexible and extensible.
-Provide development and technical expertise to ensure business intelligence solutions (applications) function according to business and technical requirements.
-Ensure that all solutions, technical configurations and other work products are thoroughly unit-tested prior to delivery.
-Participate in system/integration testing as appropriate. Perform reviews and other QA steps as requested.
-Adhere to Darden SDLC and technology architecture requirements. Contribute to architecture design principles and standards as appropriate.
-Proactively identify and communicate potential problems and issues to project team members/leaders. Proactively identify alternatives and recommend/implement solutions as appropriate.
-Ensure accurate project status and work estimates (ETCs) are always reported /communicated to project leaders/managers in a timely fashion. Develop detailed project and task estimates as needed.
-Effectively communicate with stakeholders throughout the project lifecycle. Ensure issues are analyzed, discussed and resolved.
-Consistently enhance skills and job knowledge by researching new technologies, software products, analytical methods and trends.
-Provide for thorough and accurate MicroStrategy product and application administration to ensure the data warehouse platform is properly managed.
-Work closely with the end-user community in an internal customer support role, answering procedural and data questions, assisting users with report development and use of the MicroStrategy tools, and working with developers to trouble-shoot and support production systems. May include leading projects and investigating and resolving complex issues.
-Maintain and modify existing projects, applications and reports as required. This includes being on call to support production systems.
-Train functional users in use of MicroStrategy Web, Desktop, and Dossier as needed to effectively leverage the data warehouse and business intelligence platform.
REQUIRED TECHNICAL SKILLS:
-5+ years of programming/analysis experience
-Minimum of 3+ years’ experience with developing complex MicroStrategy data models and reports in a large organization
-Strong understanding of BI, reporting and data warehouse architecture.
-Hands-on experience with installing and upgrading MicroStrategy environment
-Familiarity with full-suite of MicroStrategy Administrator products – Object Manager, Command Manager, User Manager, Distribution services.
-Highly developed analytical, problem solving, with strong ability to quickly learn and comprehend business processes and problems in order to effectively develop technical solutions.
-Work with all levels of development from analysis through implementation and support.
-Experience programming in SQL, including analyzing and debugging
-Strong understanding of financial concepts and data analysis.
-Demonstrated competency in designing, developing and testing complex applications or components.
-Demonstrated competency in accurately identifying the scope of work and detailed schedule estimates.
REQUIRED EDUCATION:
-Bachelor’s degree in IT related discipline or equivalent experience (BS / BA in MIS, Computer Science, Business Analytics, Mathematics or Engineering)
OTHER KEY QUALIFICATIONS:
-Ability to work independently, take ownership of tasks and follow through to implementation/resolution.
-Resolve end user reporting problems through collaboration with both technical and functional personnel in a team environment.
-Exceptional verbal and written communications skills, with an ability to express complex technical concepts in business terms.
-Solid teamwork and interpersonal skills.
-Strong analytical, problem-solving skills.
PREFERRED SKILLS AND EXPERIENCE:
-Understanding of MicroStrategy architecture and application performance tuning
-Experience working with large datasets
-Experience with large database systems (Oracle preferred)
-Experience with PL/SQL Developer
-Experience with advanced analytics tools (Alteryx, R, Python)
-Knowledge of restaurant or retail business
