SQL BI Developer - Clearfield, Utah ( GC or Citizens )
Skal:SAPData
Company Description
IT
Job Description
Role: SQL BI Developer Location: Clearfield, Utah Duration: 6+ Months
BGV will be done for the selected candidates.
JD:
- 5+ years developing BI reports/dashboards using Microsoft BI/SQL Server technology stack (SSRS, SSIS, SSAS) with data from ERP systems.
- 3+ year of experience leading own projects.
- 3+ year developing ERP interfaces with external systems.
- 3+ year administering servers in a virtualized Windows Server environment.
- Experience with IFS, SAP, or Ross ERP systems preferred but not required. We will train the right person on the necessary knowledge.
- Experience developing with PL/SQL and XML preferred but not required.
- Create Data Warehouses using SSAS cubes, MDX, and Tabular data models.
- Builds data transformations with SSIS including importing data from files, moving data from one database platform to another; builds star schema data marts.
- Collaborates with business analysts, subject matter experts, and other team members to determine data extraction and transformation requirements.
- Gathers business requirements and works with data analysts on physical database design and modeling.
- Performs code reviews, analyzes execution plans, and re-factors inefficient code.
- Follows data standards, resolves data issues, and completes unit testing and system documentation for Extract Transfer Load (ETL) processes.
- Conducts system tests and root cause analysis, troubleshoots issues and corrects database defects, responding quickly to bug fixes and enhancement requests.
- Microsoft SQL Server Integration Services SSAS SSIS, SSRS and Power BI
- Has strong knowledge of relational databases, as well as skills in SQL query design and development.
Please respond with your word resume and requested details:
Full Name : Work Authorization: Contact Number : Email ID : Skype ID: Current location: Willing to relocate : Rate/hr :
Additional Information
All your information will be kept confidential according to EEO guidelines.