Business Intelligence Developer loc: Moorestown, NJ
100,000 - 200,000
Job Description:
- Gather requirements and design Business Intelligence solutions which incorporate dashboards and reporting.
- Create and manage:Interactive dashboards for embedding Internal and Client-Facing applicationsETL systems for data warehouses & data marts which integrate multiple domainsAnalytical (OLAP) cubes, complex SQL stored procedures and other database objects
- Enterprise reports like Crystal Reports & Jasper ReportsEmbrace agile SDLC philosophy for all BI projects with high user-touch across phases of: requirements, design, develop, developer test, user test, releaseCollaborate with Software Developers regarding application framework for hosting reports and dashboards and repository (GitHub) environmentCollaborate with IT Infrastructure Team & IT Project Management for BI server planning & maintenanceCollaborate with IT Analysts to fulfill ad hoc requests by writing SQL Scripts & Excel chartsAdminister Salesforce CRM environment and the ETL for Salesforce CRM data to warehouseResearch new technologies for BI, both in open-source and closed-source arenas; conduct proof-of-concept evaluations for these new technologies
- BS in Computer Science or related field
- 3+ years as Business Intelligence Professional, preferably with Health Care experience
- Excellent relational database experience and understanding of Dimensional Modeling (Kimball Star Schema)Understanding of data visualization techniques and best practicesStrong analytical abilities, organizational skills, problem-solving skills, and attention to detailExcellent communication skills
- Ability to work independently in a self-directed manner and collaboratively as a team memberFirst-rate time management skills including the ability to effectively prioritize and execute tasksExcited to learn new technologies, open-source and closed-sourceSkills SQL Server Enterprise 2008 or higher (3 years)SQL Server Integration Services (SSIS)SQL Server Analysis Services (SSAS)T-SQL complex stored proceduresProfiling and Tun inEnterprise Reporting Tool Experience (1-2 years)Such as Crystal Reports, iReport (Jasper Reports), SQL Server Reporting ServiceData Visualization Tool (1-2 years)Such as Logi Analytics, Qlikview, Tableau, SAP Dashboard DesignExcel Power-UserPivot Tables, Charts, VBA AutomationProficient: MDX, MySQL, JavaScript, Word, PowerPoint, VisioDesired: ASP.NET, C#, CSS, HTML, NoSQL (MongoDB)