Sr. BI Developer-West Chester, Pennsylvania

Sr. BI Developer

Location: West Chester, Pennsylvania

Position Type: Full Time

Salary: $100k-115k/yr. on W2 only

US Citizen, Green Card only

Core Responsibilities

• Design, develop, and maintain ETL interfaces between multiple disparate systems (e.g. OLTP, OLAP, Excel, Web Services) using SSIS, SSAS, SSRS. and any necessary scripting languages.
• Data warehouse design and modeling (star schemas, dimensional modeling) leveraging the in-house BI applications to include but not limited to MicroStrategy as well as Tableau.
• Perform statistical analysis, data mining and retrieval processes on a large amount of data to identify trends, figures and other relevant information.
• Design, Develop, and maintain the Operations Reporting Data Warehouse ecosystem.
• Develop Cubes in SSAS and SSRS Reports as the presentation layers.
• Performance tuning of Data Warehouse Parser and ETL, as well as ODS extracts for the building of cubes, reports, and extracts to other databases.
• Collaborates with project stakeholders to identify product and technical requirements.
• Conducts analysis to determine integration needs.
• Develops software update processes for existing applications.
• Assists in taking business intelligence to the next level to support business decisions and recommend best practices and policy in business intelligence implementation, maintenance, and data quality.
• Works cross-functionally to implement key projects. Interfaces with internal and external teams to improve accuracy of performance metrics trending and forecasting.
• Oversees the researching, writing, and editing of documentation and technical requirements, including software designs, evaluation plans, test results, technical manuals, and formal recommendations and reports.
• Keeps current with technological developments within the industry. Monitors and evaluates.
• Respond to production support issues and Is the primary contact on all nightly support activities that include troubleshooting and remediation of existing processing problems.
• Acts as a technical contact and liaison for outside vendors and/or customers.
• Presents and defends architectural, design, and technical choices to internal and external audiences.
• Consistent exercise of independent judgment and discretion in matters of significance.

Education Level

• Bachelor's Degree in Computer Science or Related Degree
• Field of Study; Computer Science, Engineering

Years' Experience

• Generally requires 11+ years related experience
• 7 + years of Data Warehouse and Business Intelligence design and development experience
• 7+ years of Advanced T-SQL knowledge; must have performance tuning experience
• 7-10 years of hands on experience with MS SQL 2008 R2 SSIS, SSAS, and SSRS (the complete SQL stack)
• SSIS experience is required
• Must have Performance Tuning experience on SSRS Reports
• Demonstrated successful working relationships with IT and Business customers
• Ability to present complex technical ideas in business-friendly language
• Knowledge of distributed networks
• Some SQL Administration experience required
• Excellent problem solving skills
• Flexibility of monitoring nightly support
• Net application experience is desired – C#, VB, ASP.Net, ADO.Net, Entity Framework