• Share this Job

Sr. BI Analyst & Developer

Location : Horsham, PA
Job Type : Direct
Hours : Full Time
Required Years of Experience : 4+
Required Education : BS
Travel : No
Relocation : No

Job Description :


Develop, maintain and automate BI solutions to support operational and online reporting needs. Operate as SME for reporting and analysis needs throughout the organization. Work closely with business leaders to identify gaps and areas for improvement in reporting processes.  Analyze emerging trends and make recommendations for potential opportunities to enhance the use of data, reporting and analysis processes.


Job Responsibilities 

· Develop automated BI tools and reports to support decision making across the enterprise

· Perform data analysis and provide recommendations to improve online sales performance

· Deliver ad-hoc analysis for various stakeholders for regular business inquiries

· Proactively leverage BI tools to deliver new programs to meet business needs 

· Creates logical and physical data models to ensure high data quality

· Triage and resolve issues for customers in a timely, efficient manner

· Ability to build strong working relationships in and outside the organization including within IT, and the analytics team and 3rd party vendors

Required Qualifications :


· 4+ years as BI Data Analyst preferably in the Financial Services industry   

· SAS experience and fluent in SAS Macro language

· Excellent SQL skills and expert data management and data cleansing skills

· Hands-on Unix or Linux shell scripting experience

· Proficient in large data warehouse environment: Oracle, SQL Server, etc.

· Knowledgeable in logical modeling, data management and data mart creation

· Comfortable analyzing complex problems

· Ability to work independently with strong attention to detail

· Strong written and verbal communication skills

· BS in quantitative or related field (Math, Engineering, Computer Science, etc.)


Preferred Qualifications

· Familiarity with Hadoop, Podium, EC2 or RDS

· Knowledgeable in enterprise data architecture principals

·  Automation mindset a must 

·  Master's degree preferred

Powered by AkkenCloud