**Summary**:
Role sits within the BI function and is key to the operation of the business. The position has responsibility for the development, maintenance, integration, data governance and data reporting of MFF business systems.
Position requires experience in BI and Object-Oriented development. Position must have experience working with Microsoft Business Intelligence Tools: SSRS, SSIS, SSMS and Business Intelligence Development Studio. MS SQL skills are essential as this role serves as the main support in the area.
**Essential duties and responsibilities**:
This position has responsibility for the development and maintenance of MFF business data systems, including:
Ø Design, develop and maintain business intelligence solutions.
Ø Crafting and executing complex queries for data
Ø Production and Data warehouse systems.
Ø Maintenance and update of SSIS packages.
Ø 3rd party data extract and integration with other satellite systems.
**Core duties and responsibilities include the following and other duties may be assigned**:
Ø Integration of 3rd party data which we have in our business using Microsoft tools.
Ø Effective Data Governance of MFF business data.
Ø Develop BI reports using data from our current systems / Data Warehouse.
Ø Deliver reports via Power BI, SSRS or other similar technologies.
Ø Translate business needs to technical specifications
Ø Design, build and deploy BI solutions or similar reporting tools.
Ø Create tools to store data (OLAP cubes)
Ø Develop XML files based of XSD schema files using SQL server tools.
Ø Collaborate with peers to integrate systems
**Supervisor responsibilities**:
Position will report to MIS Manager.
**Requirements**:
Ø Proven experience as BI Developer
Ø Manufacturing Industry experience is preferred
Ø Background in Data Warehouse design (dimensional modeling and data mining)
Ø In-depth understanding of Data Management, OLAP and ETL framework.
Ø Knowledge of SQL queries, Stored procedures, Triggers, SSRS, and SSAS, SSIS and Visual Studio.
Ø bachelor's Degree in Computer Science, Engineering, or relevant field with at least 5 years.
Ø Bilingual (English - Spanish)
**Skills**:
Ø Analytical
Ø Design
Ø Problem Solving
Ø Technical Skills
Ø Customer Service
Ø Written Communication
Pay: Up to $58,000.00 per month
Work Location: In person