Reports Developer

We are looking for a REPORT DEVELOPER to augment our high-visibility client's Finance Business Intelligence Services team. This is a highly motivated team dedicated to identifying, implementing, and supporting the best reporting and scorecarding solutions in order to create useful, timely decision support tools and processes for customers at the Corporate and Executive level.

We are looking for a strong individual who will support report development for scorecard, mid-year review, revenue, and P&L programs. As a Report Developer and technical resource you will be responsible for assisting in the design, implementation, and maintenance of new scorecards and financial reporting (revenue and P&L) solutions. You will also ensure the integrity, security, quality, and support of the toolsets as a whole.

The ideal candidate will be able to leverage his/her own resources as well as collaborate with other groups to deliver solutions within tight timeframes as well as having a solid understanding of financial business processes and the ability to translate that understanding using strong information worker development skills.

RESPONSIBILITIES:

- Assist with design, implementation, delivery, and maintenance of BI, scorecarding, and financial solutions
- Build relationships with product management teams, understand business needs and deliver on requirements as required
- Partner with other product managers and other development teams
- Participate in UAT and provide scorecard and report owner user support (post launch)
- Extensive use of Excel VBA, XML, and other Scripting technologies while performing configuration, security, and other needed tasks in support of the above - familiarity with HTML a plus
- Develop Excel Web Reports based on final business requirements
- Provide estimates for scope, schedule and resources, assess risk, and identify key assumptions
- Data analysis, scorecard and report validation along with troubleshooting existing processes and key workflows - proactively challenge where required and make necessary changes to optimize performance and user experience
- Understand the various dependencies and relationships across scorecarding and financial applications
- Develop and deliver user training materials and presentations as requested

QUALIFICATIONS:

- Experience with financial data warehousing systems such as MS Sales and Mercury, including extensive use of MSRA desired
- Experience with business scorecards or analytical reporting
- Advanced Excel skills - knowledge and experience in using macros and cubevalue functions a must have
- Intermediate to advanced OLAP, Access, SQL Reporting Services
- Understanding of relational database/SQL, RI implementation, query performance, SQL knowledge, T-SQL Programming, Stored Procedure and function design is a plus
- Great communication skills (written and verbal) along with the ability to collaborate internally
- Must be detail-oriented with strong problem solving ability
- Ability to utilize experience to improve processes and proactively drive opportunities to resolution without supervision and - or within stringent deadlines
- Working knowledge of the SDLC and associated processes
- Proven experience in working on and maintaining reporting and UX solutions
- Ability to multi-task, deal effectively with ambiguity, and prioritize under pressure