SQL BI Developer - Clearfield, Utah ( GC or Citizens )

Info-Ways; Clearfield (UT); On-site; USD 82,656 - 110,208; Full time

Job summary

A technology solutions provider is seeking an experienced SQL BI Developer in Clearfield, Utah to build and maintain data analytics solutions. The ideal candidate will have over 5 years of experience developing business intelligence reports using Microsoft BI/SQL Server technologies. Responsibilities include collaborating with team members to determine data transformation requirements and conducting system tests. Preference for candidates with experience in ERP systems and data warehousing technologies. This role is contract-based for 6+ months.

Qualifications

• 5+ years developing BI reports/dashboards using Microsoft BI/SQL Server technology stack.
• 3+ years leading projects independently.
• Strong knowledge of relational databases.

Responsibilities

• Build and maintain data analytics solutions.
• Gathers business requirements for physical database design.
• Conducts system tests and troubleshoot issues.

Skills

Microsoft BI/SQL Server technology stack (SSRS, SSIS, SSAS)

Data Warehousing using SSAS cubes

PL/SQL and XML

SQL query design and development

Data transformations with SSIS

Job description

SQL BI Developer - Clearfield, Utah (GC or Citizens)

Contract | IT | Location: Clearfield, Utah | Duration: 6+ Months

Background Verification (BGV) will be performed for selected candidates.

Job Description

We are seeking an experienced SQL BI Developer to build and maintain data analytics solutions.

• 5+ years developing BI reports/dashboards using Microsoft BI/SQL Server technology stack (SSRS, SSIS, SSAS) with data from ERP systems.
• 3+ years of experience leading projects independently.
• 3+ years developing ERP interfaces with external systems.
• 3+ years administering servers in a virtualized Windows Server environment.
• Preference for experience with IFS, SAP, or Ross ERP systems (training provided if needed).
• Preference for experience developing with PL/SQL and XML (not required).
• Experience creating Data Warehouses using SSAS cubes, MDX, and Tabular data models.
• Builds data transformations with SSIS, including importing data from files, migrating data between database platforms, and building star schema data marts.
• Collaborates with business analysts, subject matter experts, and 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 refactors inefficient code.
• Follows data standards, resolves data issues, and completes unit testing plus system documentation for ETL processes.
• Conducts system tests, root cause analysis, troubleshoots issues and corrects database defects, responding swiftly to bug fixes and enhancement requests.
• Expertise in Microsoft SQL Server Integration Services, SSAS, SSIS, SSRS, and Power BI.
• Strong knowledge of relational databases and skill in SQL query design and development.

Application Information

Please respond with your resume and the requested details:

• Full Name
• Work Authorization
• Contact Number
• Email ID
• Skype ID
• Current location
• Willing to relocate
• Rate/hr

All your information will be kept confidential according to EEO guidelines.