IT Specialist Mid-level
Black Systems LLC Albany
Description
Database / Business Intelligence Developer. Candidate will function as a database and business intelligence developer performing duties as directed.
Provide a list of the day to day tasks to be performed by the Selected Candidate:
- Perform Data profiling on the source systems
- Design and review star schema dimensional model to support data warehouse and data marts
- Perform Source to Target Mapping between source system database and data warehouse target database
Develop analytics and reports using Tableau and SQL Server Reporting Services (SSRS)
Requirements- Qualification
36-60 Months, Candidate is able to work independently, without assistance.
- 36 months experience in building extraction and transformation of transactional data to drive data warehouse loads and end user BI as well as reporting requirements using SQL Server Integration Services (SSIS) or other similar ETL tool 2. 36 months experience in analytics and operational reporting using Tableau and SQL Server Reporting Services (SSRS
- 36 months experience in Star Schema / Dimensional Modeling to support data warehouse environments as well as OLTP environments.
- 48 months experience developing and tuning complex SQL and PL/SQL against Oracle (11g or newer) or SQL Server
- 36 months experience in complex SQL development leveraging analytics functions
- Bachelors’ degree (or higher) in Computer Science, Software Engineering, Computer Information Systems, or some related field.
Requested Documentation Proof of degree
No telecommuting allowed.
Candidate must participate in an on-site, in-person interview at the work office location listed above to be considered for the position
Black Systems LLCAlbany
Duration: 30 Months
Client: ITS
Requirements:
• 72 months experience performing Web Accessibility Audits using assistive or automated technologies, such as JAWS, WAVE from WebAIM, NVDA, ZoomText, Dragon Naturally Speaking, Adobe Acrobat, and...
Black Systems LLCAlbany
48 Months of experience troubleshooting and supporting Microsoft Windows XP and higher operating systems.
• 48 Months of experience working with and supporting Microsoft Office Suite 2007 and higher.
• 36 months experience writing scripts and...
Black Systems LLCAlbany
Requirements:
• 36 months of mapping and spatial analysis experience using ArcGIS Desktop or ArcGIS Pro
• 24 months of experience configuring and administering Esri-based web mapping applications for browser or mobile based solutions
• 12 months...