Job Description :
BI Specialist
Columbus ,OH
12+ Months

Required Skills / Exp Years of Exp Last Used
1. Bachelor’s degree in Computer Science, MIS or equivalent.
2. Minimum of 3 years of Data Warehousing and SQL development with SQL Server 2012/2014/2016.
3. Working knowledge utilizing Microsoft ETL/data integration tools (SSIS and T-SQL scripts) and examples of work.
4. Demonstrated SQL skills with experience in developing stored procedures, views, functions, triggers, and advanced logical methods.
5. Working knowledge of Microsoft suite of products, including Word, Outlook, and Excel.
6. Knowledge of Microsoft Power BI product and documented examples of work.
8. Demonstrated analytic, written, and oral communication skills.



Essential Functions:
1. Design SSIS Packages to transfer data from flat files, ftp, or other means to SQL Server using Business Intelligence tools.
2. Extensively use SSIS transformations such as lookup, merge, derived column, data conversion and aggregate etc.
3. Write T-SQL queries and Store Procedures to build packages.
4. Generate Reports, drill down reports, drill-through reports and parameterized reports using Business Objects.
5. Coordinate the testing and implementation of business intelligence systems.
6. Work closely with end users to identify requirements for new systems and customizations.
7. Initiate change control process for any and all changes to production systems.
8. Develop and implement end-user tools for accessing Data Warehouse.
9. Develop, implement and maintain documentation.
10. Provide end-user training.
11. Perform additional duties or assignments as required by management.
             

Similar Jobs you may be interested in ..