Sr. Database Developer / Business Intelligence Analyst @ Defined Clarity



Full-time Position, Onsite and based in the Philadelphia DMA. The Data Modeler / Database Developer will be responsible for the development and data architecture of multiple enterprise data management systems. The ideal candidate will have experience with data analysis, enterprise databases, business intelligence and reporting, metadata management and ETL. Candidate must be a team player and willing to travel.


Key Responsibilities:

- Assist with the development and architecture of an enterprise data warehouse.

- Perform ad hoc analysis, insight generation, and data migrations between legacy systems.

- Perform data integration techniques within diverse RDMS specifically SQL Server, DB2 and Netezza using SSIS, Cognos Data Manager, or any other ETL tools.

- Strong SQL skills with the ability to define and manipulate complex SQL scripts and functions.

- Perform enterprise data mart development and familiar with multiple schematics including star, snowflake, and 3rd NF.

- Ability to develop dashboards and reports in Cognos BI, SSRS


Required Qualifications:

- US Citizen

- Must be able to obtain a security clearance

- Bachelor's degree or higher in computer science / Master's degree preferred

- Experience in Object Oriented Analysis, User Interface Design, Dashboard Development, and advanced SQL Programming

- Experience with multiple relational, dimensional, and OLAP databases

- Excellent written and oral communication skills

- Self-starter and team oriented

- Ability to multitask and work within a diverse environment

- Travel is required

Required Skills:

At Least 5 Years Experience in:

- Advanced Data Modeling and Database Architecture Experience

- Cognos Business Intelligence - Report Studio, Analysis Studio, Query Studio, Workspace Advanced, and Cognos Framework Manager

- SQL Server 2012 R2, SSIS, SSRS

- IBM DB2 and Netezza

- Microsoft Office

Nice To Have:

-Power BI



This job is open at the following locations:

New Jersey

NJ- - Cherry Hill, New Jersey

New York

NYC, NY- - New York, New York


KNG OF PRUSSA, PA - 1ST AVE- 1150 1st Ave 1150 Frist Ave- Kng Of Prussa, PA, 19406


Philadelphia, PA- - Philadelphia, Pennsylvania


$90,000 - $100,00