Sr. BI Developer-West Chester, Pennsylvania - Georgia IT Inc.
West Chester, PA
About the Job
Job Title: Sr. BI Developer
Location: West Chester, Pennsylvania
Position Type: Direct Hire
Salary: $110,000
F2F Interview Required
BI Stack (SSIS, SSRS, SSAS)
Core Responsibilities
Location: West Chester, Pennsylvania
Position Type: Direct Hire
Salary: $110,000
F2F Interview Required
BI Stack (SSIS, SSRS, SSAS)
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.
Source : Georgia IT Inc.