Business Intelligence Analyst

SUMMARY:
The Business Intelligence Analyst is responsible for supporting complex business intelligence analytical solutions utilized to support the business analytical and reporting needs. This individual will use Data Warehousing concepts to improve MFCD data capabilities. Collaborate with business partners and team members to define data requirements and reporting specifications.
ESSENTIAL FUNCTIONS:
Consistently exhibits behavior and communication skills that demonstrate commitment to superior customer service, including quality, care, and concern with each internal and external customer.
Design and implement BI Data Warehouse.
Design and implement BI reporting applications.
Design, implement, and support a platform providing ad-hoc access to large datasets.
Translate business requirements into specification that will be used to implement required data marts, reports, and dashboards, created from potentially multiple data source.
Documents data systems, processes, and technical Meta data.
Strong analytical, problem solving, planning and prioritization skills.
JOB REQUIREMENTS:
Proficiency writing SQL
Technical knowledge of SQL queries, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Alteryx.
Understanding of database management systems, online analytical processing (OLAP) and ETL (Extract, transform, load) framework.
Experience building Reports, Scorecards and Dashboards w/ Power BI a plus.
Good project/time management and teamwork skills.
Must be a self-starter and able to work independently as needed.
Proven abilities to take initiative and be innovative.
Proficient in the use of MS Excel