myTV is seeking to hire a SQL/Crystal Reports BI Developer
Responsibilities
- Understand business requirements, determine implementation strategy and translate into reports, portals, or dashboards that improve the business, meet strategic goals and conform to best practices and standards
- Forecast and analyze data and trends to create reports that highlight areas needing improvement
- Collaborate with Development department members and subject matter experts to establish technical vision and analyze tradeoffs between usability and performance needs
- Assist in project planning and preparing project documentation such as change requests and user manuals.
- Create technical design specification and develop analytical reports using Crystal Reports, MS SQL server, or other application development tools.
- Design create and maintain multi-dimensional models, including the construction of data views, dimensions, measures, filters, hierarchies, cubes, SQL queries, data stores, stored procedures, triggers and events while adhering to development methodologies
- Design data marts and develops scheduled and ad hoc parameterized queries and reports from a variety of data sources and provides on going analytical support.
- Create a standardized reporting infrastructure
- Develop web applications in ASP.NET as needed
- Design , develop and/or integrate applications using other technologies as required by the company
- Develop test plans and perform testing including unit and development level integration testing
- Test and evaluate information and reconcile any differences from expected results
- Troubleshoot and resolve technical issues, debug, tune and optimize performance
- Develop and manages configurations, procedures and guidelines for selecting, installing and deploying new technology, integrated solutions and platforms
- Administration of various reporting environments including but not limited to Business Objects, Crystal Reports, and Microsoft SQL Server Reporting Services (SSRS) including installation, security, troubleshooting, support and maintenance
- Provide end user training as required
- Support day to day reporting and Business Intelligence processes
Requirements
- Bachelor's degree in computer science or related field.
- 3+ years’ experience in the IT Industry with hands on continuous work experience in developing reporting solutions (data marts, reports, dashboards, scorecards) using Microsoft SQL Server 2005/2008
- 3+ years of writing complex reports using drill downs, charts, views and cubes
- 3+ years of SQL database and scripting
bousaleh@my-tv.us
