Job Title: Technical Specialist 2/TS2
NFP Rate: $66.53
Interviews: On-site interviews
Position will close to new submittals: Friday 10/26 @ 10AM
Duration of project: Thru the entire fiscal year. extensions possible
Position Summary: The Business Intelligence (BI) Specialist I, is responsible for the design, development, implementation, management and support of mission critical enterprise BI reporting and Extract, Transform, Load (ETL) processes and environments. Working with the Database team, you will be required to gather, document, and approve business requirements for data analysis and reporting projects, as well as use BI and database tools to develop reporting solutions to meet business needs. Using your skills and experience as a BI Specialist, you will design, develop and implement ETL processes to transform structured, unstructured and disparate source data into the target data store(s)/ data warehouse(s) / data mart(s).
Essential Functions:
- Design SSIS Packages to transfer data from flat files, ftp, or other means to SQL Server using Business Intelligence tools.
- Extensively use SSIS transformations such as lookup, merge, derived column, data conversion and aggregate etc.
- Write T-SQL queries and Store Procedures to build packages.
- Generate Reports, drill down reports, drill-through reports and parameterized reports using Business Objects.
- Coordinate the testing and implementation of business intelligence systems.
- Work closely with end users to identify requirements for new systems and customizations.
- Initiate change control process for any and all changes to production systems.
- Develop and implement end-user tools for accessing Data Warehouse.
- Develop, implement and maintain documentation.
- Provide end-user training.
- Perform additional duties or assignments as required by management.
Qualifications:
- Bachelor’s degree in Computer Science, MIS or equivalent.
- Minimum of 3 years of Data Warehousing and SQL development with SQL Server 2012/2014/2016.
- Working knowledge utilizing Microsoft ETL/data integration tools (SSIS and T-SQL scripts) and examples of work.
- Demonstrated SQL skills with experience in developing stored procedures, views, functions, triggers, and advanced logical methods.
- Working knowledge of Microsoft suite of products, including Word, Outlook, and Excel.
- Knowledge of Microsoft Power BI product and documented examples of work.
- Demonstrated analytic, written, and oral communication skills.
