Equipment Metrics & Analysis Consultant
Bachelors degree specializing in Mathematics or Information Systems, MBA preferred.
5 years wireless experience in Marketing or Information Technology.
5 Years Database/Data Mining Experience.
3 years dimensional Data Warehouse design and implementation.
3 years strong analytical experience in a similar environment.
2 years in Dashboard/User interface development.
Specific Knowledge in
- Database: TeraData, SQL Server 2008/2005, SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SSIS, Access.
- Business Intelligence tools and the BI space highly desirable.
- SharePoint development especially in Site definitions & Web Parts.
- MOSS 2007 and 2003. Designed and implemented a MOSS 2007 solution.
- Microsoft .NET platform like , , C#.NET, HTML, CSS, XML, XSL, XSLT, JavaScript, AJAX, Silverlight.
- JavaScript, HTML and XML.
- Silverlight (desirable).
Certifications: Masters in Business Intelligence Tools
Terradata Management
Microsoft SQL Server 2005 Business IntelligenceThis position will primarily provide tactical and strategic direction to Device Marketing through the design and execution of reports, analysis of results and building and maintenance of user-friendly data interfaces. The position will also respond to requests from a broad range of functional areas including: Legal (compliance requirements), Advertising (PR Releases), Marketing and Finance (special projects).
Duties & Responsibilities
- Update and enhance periodic equipment reports and Develop/Design reports to support the Device Group. Utilize the Data Warehouse, linking POS, Billing and Customer Account data.
- Perform special projects to support corporate initiatives involving equipment intelligence and metrics.
- Design Marketing and Financial Models to comply with user requirements.
- Develop and maintain templates for Ops reviews and Vendor presentations.
- Provide detailed reporting and analysis to identify areas of risk and opportunity.
- Analyze key business issues and trends and assist in developing plans to address.
- Prepare technical design of data models, screen design and report layouts.
-Further develop web reporting Dashboard that accesses consolidated central device reporting and business intelligence repository.
- Service information requests for strategic/tactical & operational decision support using atomic data warehousing architecture, leveraging internal/ external data sources and Sql server 2007.
- Create a simplified ETL process of transforming data from various formats into a database for data synthesis, cleansing, manipulation through process improvement, creation of MS Excel macros.
- Create data warehouse for multidimensional analytical processing, data mining, analytics, and dashboards using MS Access / Excel.
-Manage and administer company-wide equipment reporting standards.
- Responsible for developing/maintaining/updating handset feature reference databases used across UDM.
- Create new Product Names; assign full complement of features including Tier.
|
|
