CapB InfoteK
Technical Specialist with SQL Server & Python - Harrisburg, PA
CapB InfoteK, Harrisburg, Pennsylvania, us, 17124
The Technical Specialist is a senior level resource with specialized knowledge and experience in a specific technology. The Technical Specialist has an overall knowledge and understanding of application development and architecture that serves as a strong base for technical expertise in a specific product or program. The TS3 also has an advanced experience in the required technical subject matter.
The candidate will be expected to develop various items using SSRS, SSAS and SSIS. This role will also routinely perform data analysis, data modeling and data visualization tasks. This person is typically involved in performing complex and advanced queries in SQL. Familiarity with CSS and UI design is helpful. This role will occasionally be asked to assist with reporting, file manipulation and data visualization using tools such as Tableau, QlikView, iDashboards and Python. Finally, this person may also be expected to gather requirements, meet with stakeholder groups, write report specifications and document processes and procedures.
Requirements:
8 -10 years of relevant experience.
4 year college degree or equivalent technical study.
MCSA/E certification Required.
SQL Required 8 years.
SSRS (SQL Server Reporting Services) Required 5 years.
SSAS (SQL Server Analysis Services) Required 5 years.
SSIS (SQL Server Integration Services) Required 5 years.
Data Modeling Required 9 years.
Working with and cleansing data
Required 9 years.
Data Analysis Required 9 years.
Statistics Required 5 years.
Education Data (NCES, IPEDS, CEDS, CDS)
Desired
2 years.
.Net, HTML, Javascript, CSS Desired 2 years.
UI/Data Visualization Tools (Tableau, QlickView, iDashboards), Desired 1 year.
File Manipulation (Python) Desired 1 year.
The candidate will be expected to develop various items using SSRS, SSAS and SSIS. This role will also routinely perform data analysis, data modeling and data visualization tasks. This person is typically involved in performing complex and advanced queries in SQL. Familiarity with CSS and UI design is helpful. This role will occasionally be asked to assist with reporting, file manipulation and data visualization using tools such as Tableau, QlikView, iDashboards and Python. Finally, this person may also be expected to gather requirements, meet with stakeholder groups, write report specifications and document processes and procedures.
Requirements:
8 -10 years of relevant experience.
4 year college degree or equivalent technical study.
MCSA/E certification Required.
SQL Required 8 years.
SSRS (SQL Server Reporting Services) Required 5 years.
SSAS (SQL Server Analysis Services) Required 5 years.
SSIS (SQL Server Integration Services) Required 5 years.
Data Modeling Required 9 years.
Working with and cleansing data
Required 9 years.
Data Analysis Required 9 years.
Statistics Required 5 years.
Education Data (NCES, IPEDS, CEDS, CDS)
Desired
2 years.
.Net, HTML, Javascript, CSS Desired 2 years.
UI/Data Visualization Tools (Tableau, QlickView, iDashboards), Desired 1 year.
File Manipulation (Python) Desired 1 year.