Responsible for performing complex analysis and modeling. Utilizes a variety of systems including, but not limited to Excel, Access, Visual Basic, SAS, and InfoQuest at an intermediary level. Provides analytical support on various strategies to ensure company goals are met.
Create and maintain descriptions of data architecture, including data definitions, data models, data flow diagrams, metadata management, business semantics, data modeling and metadata workflow management.
In this role, the selected candidate will build SSAS multi-dimensional cubes and tabular models (this is a must); gather requirements and present solutions; this will be a client facing role when onsite.
This position is primarily responsible for designing, developing, and supporting new and existing reports, designing, programming, deploying Business Intelligence (BI) and developing BI dashboards to meet the company needs.
The Business Intelligence developer would be responsible for designing and building online reports using Tableau and at times MDX queries; responsible for modifying and optimizing existing SSAS cube based queries and reports.
Design, develop, test and debug highly complex SSIS packages and makes significant enhancements to existing packages and monitor and optimize database objects and SQL Server databases using industry-standard tools and practices (SQL, Profiler, Analyzer, Query Plans).
In this role, the selected candidate will work with Database Administrators, SQL Developers, Web Developers and end-users to create canned reports, prompted reports, dashboards and OLAP structures to analyze FCA data in multiple ways.
The BIRT Report Developer will design and configure customized BIRT reports for the Maximo Asset Management system used by the client. He or she will work closely with the functional and development teams to meet the business reporting requirements of the client.