PhiladelphiaRecruiter
the smart solution for Philadelphia jobs

Sr Business Intelligence (BI) Architect

Company: Hamilton Technical Personnel
Location: Plymouth Meeting
Posted on: May 19, 2019

Job Description:

A major corporation, located in Plymouth Meeting, in suburban Philadelphia PA, is seeking a very experienced Business Intelligence (BI) Architect to join their technical staff. The Senior BI Architect is responsible for performing business intelligence functions related to data warehouse, ETL and reporting designs, business intelligence infrastructure and delivery of business intelligence service to end users, in accordance with company policies and procedures. Participate in the analysis and design of enterprise data warehouse andor databases by applying current data warehouse methodologies and data modeling techniques. Design, develop, optimize, maintain and support ETL processes using Stored Procedures and data integration tools such as Microsoft SSIS. Develop the ETL andor reporting application code based on documented requirements Create, execute, and document unit test plans for ETL and data integration processes and programs. Design and implement the data loading (ETL) and publishing processes within the databaseData warehouseBusiness Intelligence environment. Maintain and ensure integrity of data through SQL transformations, cleansing and constraints Routinely propose improvements to database processes andor structures to improve supportability or usability and system performance. Responsible for on-call rotation to monitor alerts and re-mediate any occurrence of database or data system outage. Work with business users for continuous improvement of existing reporting and analytics to drive effective business improvement. Provide end-user support, including direct interaction with users, service desk support, and development of documentation, job aids and training guides. Translate business requirements and any changes or additions to business intelligence framework into technical design specifications for implementation and documentation purposes. Develop Oracle BI Repository (RPD) logical columns, hierarchies, subject areas. Develop and configuration of Kourier server for importing data from our ERP into data warehouse. Qualifications Understanding of relational database theory, principals and industry leading practices. Familiarity with data warehousing and relationaldimensional modeling. Mastery of ETL processes and concepts. Experience in database performance optimization. Expertise in MS SQL SSISSSAS Technologies as well as SSRS. Strong background in writing SQL scripts, complex queries and aggregate functions. Experience with Oracle BI or other reporting tools. Experience with cloud architecture and complex data structures. Design experience in data model, Star Schema and Oracle BI RPD is preferred. OBIEE, BICS or OACS interface experience is preferred. Experience with Kourier (Kore) ETL tool preferred. Strong knowledge in data analytics. Education, Training, Experience Required Bachelor s Degree in Information Technology or related field and 3-5 years of experience in ETL development, or an equivalent combination of education and experience. 5 years experience PLSQL, MS SQL SSIS , T-SQL. 2 years in data warehouse conceptsarchitecture in high volume, real-time transactions and batch ETL jobs. Experience working with high volume data exchange and integrating large structured and unstructured data in multiple formats, character sets, and delivery methods. Experience working with a relational database using SQL (MS SQL or Oracle preferred). Preferred College degree or equivalent Experience with Oracle ERP cloud, OBIEE, RPD, OACS BICS Candidates should be U.S. citizens or permanent residents and live locally. Excellent candidates with H1b visas that can be transferred will also be considered.

Keywords: Hamilton Technical Personnel, Philadelphia , Sr Business Intelligence (BI) Architect, Professions , Plymouth Meeting, Pennsylvania

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category
within


Other Professions Jobs


TRUCK DRIVERS: Guaranteed Miles, Top Pay, Home Weekends
Description: Quick Apply Call Now: 855 445-6365 Guaranteed Miles that Get You Home Weekends CLASS A CDL Truck Driver Dedicated Freight Home Weekends - Harrisburg, PA BCB Transport has an opportunity for company (more...)
Company: BCB Transport
Location: Harrisburg
Posted on: 05/24/2019

Flatbed Truck Driving Job
Description: 5,000 Sign On Bonus paid out within the first 6 months At least 6 months flatbed experience required. br br JLE Industries: Hiring Flatbed Company Drivers br br OVER THE ROAD FLATBED DRIVER
Company: JLE Industries
Location: Lancaster
Posted on: 05/24/2019

CDL- A OTR DRIVERS WANTED! NEW $40,000 TEAMING BONUS!
Description: Team truck driving jobs availableCovenant Transport is excited to announce starting February 1, we are offering OTR CDL-A Team Drivers a 40,000 Teaming Bonus With our new 40,000 Teaming Bonus, each (more...)
Company: Covenant Transport
Location: Harrisburg
Posted on: 05/24/2019


Owner Operators: Excellent Revenue with Weekly Guaranteed Miles
Description: Quick Apply Call Now: 855 445-6365 CLASS A CDL Owner Operators Dedicated Freight - Excellent Revenue - Home Weekly - Lancaster, PA Dedicated Lane Rates: 10148 Contractor Rate 1.46 all in 10148 (more...)
Company: BCB Transport
Location: Lancaster
Posted on: 05/24/2019

Reefer Driver - 95% No Touch Freight!
Description: Contractor - DriverWestern Flyer Xpress- REEFERMost carriers pay a higher CPM to reefer drivers because miles are generally not as high. Well,at WFX, you get the best of both worlds. Higher Pay and Strong (more...)
Company: Western Flyer Express
Location: Harrisburg
Posted on: 05/24/2019

Truck Driving Jobs - OTR Driver - Up to 50 CPM Starting Pay & 2 Pay Ra
Description: br br Job Description: br Truck Driving Jobs - OTR Driver - Up to 50 CPM Starting Pay 2 Pay Raises in your first year Up to 50 CPM Starting Pay, Up to 1200 Minimum Weekly Pay Guarantee,
Company: The Dart Network
Location: Harrisburg
Posted on: 05/24/2019

Local CDL A Drivers
Description: Call 855 686-7379 to find out more about our FANTASTIC OPPORTUNITIES or APPLY BELOW Become a part of the Dana Companies team today and gain the respect
Company: Dana Companies
Location: Harrisburg
Posted on: 05/24/2019

Reefer Driver
Description: Contractor - DriverWestern Flyer Xpress- REEFERMost carriers pay a higher CPM to reefer drivers because miles are generally not as high. Well,at WFX, you get the best of both worlds. Higher Pay and Strong (more...)
Company: Western Flyer Express
Location: Harrisburg
Posted on: 05/24/2019

CDL-A Lease Purchase Truck Driver - Lancaster
Description: Flatbed CDL-A Lease Purchase Truck Driver Jobs 8K Elite Bonus, Zero Money DownAt Boyd Bros., we are bound by values that reinforce your success. Theres a reason one
Company: Boyd Bros. Transportation
Location: Lancaster
Posted on: 05/24/2019

Class A CDL Lease Purchase Truck Drivers
Description: CDL-A Lease Purchase OpportunitiesCDL-A Lease Opportunities Make the living you ve always dreamed of at J R Schugel Our CDL-A lease opportunities provide professional truck drivers like you with the (more...)
Company: J&R Schugel Trucking
Location: Harrisburg
Posted on: 05/24/2019

Log In or Create An Account

Get the latest Pennsylvania jobs by following @recnetPA on Twitter!

Philadelphia RSS job feeds