Business Intelligence Specialist/Data Modeler

Business Intelligence Specialist/Data Modeler

Business Intelligence Specialist/Data Modeler

Location:

Ithaca, New York
Category:

Data Warehouse
Type:

Direct Hire
Posted:

1/11/2012
Apply Now
Back to Job Listings

Modis has joined forces with Ajilon Consulting's leading IT staffing division to create an IT recruitment powerhouse! Modis has become one of the world's largest providers of information technology services and solutions by creating a culture where people and details are never averaged into a process. Our growth record and industry leadership is a result of our unique culture of treating every challenge as unique and delivering a solution that is perfectly suited. We listen. We innovate. We're accountable!

Direct hire talented Business Intelligence Specialist to join their team, will transfer H1B and green card sponsorship.

Our client offers great benefits including a comprehensive medical package, tuition reimbursement, shortened work hours during the Summer, and a beautiful new state of the art building just to name a few.

Position Description:
Assist with the development, maintenance and support of the college Business Intelligence technical environment. Develop, manage, and update BI data models, including physical and logical models. Work with the Business Intelligence Application Architect and the appropriate business users to develop and implement data models to meet the college's reporting and analytic needs. Document data models and standards for data usage; work with the DBA for BI and BI Application Architect to ensure that data models are optimized for best performance. Translate business needs to pragmatic data models that conform to overall technical architecture and best practice. Work with business users to develop advanced reports, provide report writing support, and assist with reporting tool training. Participate as a member of the college's strategic and operational BI teams as appropriate.
This position reports to the Business Intelligence Application Architect. This position has no direct supervisory responsibility.

REPRESENTATIVE DUTIES:
Duties may include, but are not limited to the following. Other duties may be assigned.

ESSENTIAL DUTIES:
1. Assist with the development, maintenance and support of the college Business Intelligence technical environment. Maintain a high level of expertise in the technologies that comprise our BI technical environment.
2. Interview business users to obtain analytical requirements. Effectively articulate and communicate with users to successfully translate business needs into appropriate and pragmatic enterprise level data structures and data modeling standards. Lead data modeling sessions, transform business requirements into conceptual, logical and physical data models and identify data sharing opportunities.
3. Perform detailed source data analysis and data profiling.
4. Design and develop dimensional and staging data models. Design and build data models using disparate data from internal and external sources to support business reporting and analysis.
5. Create and maintain custom Ithaca College data structures. Produce scripts for creating and maintaining data structures. Specify ETL requirements for populating dimensional data models.
6. Work with ETL Developers and BI Architects to fine tune dimensional models to support complex enterprise reporting and analytics. Work with the DBA/A for BI to ensure that data models are optimized for best performance.
7. Maintain and publish data definitions and business rules within a metadata repository. Install and maintain the semantic layer for reporting as appropriate.
8. Manage and promote standard data usage and adherence to data use standards by offices and developers. Document data models and standards for data usage.
9. Work with business users to develop advanced reports, provide report writing support, and assist with reporting tool training. Respond to users reporting needs. Assist with report troubleshooting and publishing.
10. Participate as a member of the college's BI teams as appropriate.
11. Other related duties as assigned.

QUALIFICATIONS:
Bachelor's degree in a technical field with a minimum of five years experience in the area of business intelligence and a minimum of two-plus years experience in data architecture and modeling for business intelligence or the equivalent combination of education and experience; strong dimensional modeling design skills; hands-on experience with data modeling and data profiling tools, preferably in an Oracle environment; good interpersonal, written and verbal communication skills and the ability to work as part of a team are required. Work experience in higher education is desired.
Skills:
* DW - Modeler
* DW - ETL
Apply Below!
Contact Information:
Note: All fields are required
s
First Name:Last Name:

E-mail:
City:State:-- Select State --AlabamaAlaskaArizonaArkansasCaliforniaColoradoConnecticutDelawareDistrict of ColumbiaFloridaGeorgiaHawaiiIdahoIllinoisIndianaIowaKansasKentuckyLouisianaMaineMarylandMassachusettsMichiganMinnesotaMississippiMissouriMontanaNebraskaNevadaNew HampshireNew JerseyNew MexicoNew YorkNorth CarolinaNorth DakotaOhioOklahomaOregonPennsylvaniaRhode IslandSouth CarolinaSouth DakotaTennesseeTexasUtahVermontVirginiaWashingtonWest VirginiaWisconsinWyomingDaytime Phone:

Preferred Location:Alberta - Modis CalgaryAlberta - Modis EdmontonArizona - Modis PhoenixBritish Columbia - Modis VancouverCalifornia - Modis BurbankCalifornia - Modis El SegundoCalifornia - Modis Foster CityCalifornia - Modis SacramentoCalifornia - Modis San DiegoCalifornia - Modis San FranciscoCalifornia - Modis San JoseCalifornia - Modis Walnut CreekColorado - Modis Colorado SpringsColorado - Modis DenverConnecticut - Modis HartfordDelaware - Modis DelawareFlorida - Modis Ft. LauderdaleFlorida - Modis JacksonvilleFlorida - Modis TallahasseeFlorida - Modis OrlandoFlorida - Modis TampaGeorgia - Modis AtlantaIllinois - Modis Oakbrook TerraceIllinois - Modis ChicagoIowa - Modis Cedar RapidsIowa - Modis Des MoinesKansas - Modis Kansas CityKentucky - Modis LouisvilleMaryland - Modis BaltimoreMaryland - Modis LaurelMaryland - Modis DC, MDMassachusetts - Modis BostonMassachusetts - Modis Government Services Group - BostonMichigan - Modis DetroitMichigan - Modis DetroitMinnesota - Modis BloomingtonMinnesota - Modis MinneapolisMissouri - Modis St. LouisNebraska - Modis OmahaNew Jersey - Modis PiscatawayNew York - Modis AlbanyNew York - Modis New YorkNew York - Modis RochesterNew York - Modis SyracuseNorth Carolina - Modis CharlotteNorth Carolina - Modis RaleighNorth Carolina - Modis CaryNova Scotia - Modis HalifaxOhio - Modis CincinnatiOhio - Modis ClevelandOhio - Modis ColumbusOntario - Modis OttawaOntario - Modis TorontoOregon - Modis PortlandPennsylvania - Modis HarrisburgPennsylvania - Modis MediaPennsylvania - Modis PhiladelphiaPennsylvania - Pittsburgh-Modis Solutions NEPQuebec - Modis MontrealSaskatchewan - Modis ReginaSouth Carolina - Modis ColumbiaTennessee - Modis ChattanoogaTennessee - Modis KnoxvilleTennessee - Modis NashvilleTexas - Modis AustinTexas - Modis DallasTexas - Modis Fort WorthTexas - Modis HoustonTexas - Modis HoustonTexas - Modis San AntonioVirginia - Modis McLeanVirginia - Modis RichmondVirginia - Modis ViennaWashington - Wasser StudiosWashington - Modis SeattleWisconsin - Modis Milwaukee
How did you hear about us?


I was referred by a friend
At a college job fair
At a general job fair
Link from another website
Internet Search
Other
Resume:
Option 1:Upload a Resume
We accept .doc, docx, .html, .htm, .txt, .rtf, .wps, .wpd, .pdf

Option 2:Enter Below
Questions or Comments:






Search Jobs



-- Select Job Category --Software/Web DeveloperProject ManagerAnalystData WarehouseQuality AssuranceSystem AdministratorDatabase AdministratorWeb Server AdministratorMiddleware/EAI/EDIContent/Document ManagementERPTechnical/Desktop SupportNetwork/TelecomCall CenterIT ManagementeCommerceDatbase DevelopmentProject AdministratorOther
Choose location and/or zip code:
-- Select State --AlabamaAlaskaArizonaArkansasCaliforniaColoradoConnecticutDelawareDistrict of ColumbiaFloridaGeorgiaHawaiiIdahoIllinoisIndianaIowaKansasKentuckyLouisianaMaineMarylandMassachusettsMichiganMinnesotaMississippiMissouriMontanaNebraskaNevadaNew HampshireNew JerseyNew MexicoNew YorkNorth CarolinaNorth DakotaOhioOklahomaOregonPennsylvaniaRhode IslandSouth CarolinaSouth DakotaTennesseeTexasUtahVermontVirginiaWashingtonWest VirginiaWisconsinWyoming



- Select Range -within 5 mileswithin 15 mileswithin 25 mileswithin 50 miles




Modis Locations:
- Select a location -PhoenixManhattan BeachGlendaleSan DiegoSan FranciscoSan JoseWalnut CreekDenverHartfordWashingtonFt. LauderdaleJacksonvilleOrlandoTampaAtlantaChicagoCedar RapidsDes MoinesKansas CityLouisvilleBalimore - LaurelWashington, tonDetroitBloomingtonMinneapolisSt. LouisOmahaPiscatawayNew YorkRochesterSyracuseRaleighCharlotteCincinnatiClevelandColumbusHarrisburgMedia/Delaware ValleyPittsburghPhiladelphiaColumbiaChattanoogaAustinDallasFort WorthHoustonSan AntonioTysons CornerRichmondSeattleMilwaukee
Share: