Reporting Architect MySQL, Perl

A unique opportunity for a Reporting Architect to design and implement a
new reporting system.  The Reporting Architect will revamp the current
reporting system by designing, implementing and maintaining data
warehouse and reporting tool to support the reporting needs for ITA's
internal and external customers.  The ideal candidate is expected to
have strong Perl, database, and SQL skills, data warehousing background
and experience with front-end reporting applications.

The Reporting Architect will be involved in design of extracting,
gathering and distributing data; serve as a contact for data validation
and interpretation; develop, maintain and administer databases to
support reporting and informational needs as well as archiving, recovery
and implementation; monitor database performance, write SQL code for
data retrieval; and managing security for reporting databases.

The position will provide functional and technical leadership for the
Reporting team, including solution architecting, and identification and
implementation of future reporting strategies.  This will require close
work with Billing/Accounting, Account Managers, System Integration
Engineers and developers in the overall solution design.

Responsibilities:

• Gather requirements that will meet the reporting needs of users.
• Design and lead the implementation of data warehouse and reporting solution.
• Accurately estimate the size and scope of the development effort as measured.
• Provide complete documentation in the form of commented code, problem status information, and design documents.
• Define the functional specification of program modules ensuring functionality, quality and ease of maintainability.
• Perform thorough testing as required to provide a quality product.
• Perform thorough problem analysis that results in resolution of problems according to standards.
• Complete code and other deliverables on schedule.
• Other duties are required.
  

General requirements:

• 8+ years experience in full lifecycle design and development of relational database and applications
• 6+ years experience architecting data warehouse and reporting solutions
• Perl skills to be able to extract necessary information to put into database
• Ability to clearly identify a project’s scope, objectives, and implementation strategy.
• Ability administer and tune SQL databases, and write SQL code
• Excellent customer service and communication skills.