IT
Job DescriptionRole: 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 :
All your information will be kept confidential according to EEO guidelines.
Skills Required
- 5+ years developing BI reports/dashboards using Microsoft BI/SQL Server technology stack
- 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 developing with PL/SQL and XML
- Create Data Warehouses using SSAS cubes, MDX, and Tabular data models
- Builds data transformations with SSIS
- Collaboration with business analysts and subject matter experts
- Perform code reviews and optimize SQL queries
- Conduct system tests and root cause analysis on database issues
What We Do
Infoways specializes in providing comprehensive consulting, implementation, migration, upgrade, solution development, customizations, functional testing, user training, interface development, and support services for Infor solutions. Our expertise extends to Extensibility, ION, and Report Designer, enabling us to tailor solutions precisely to your requirements. We pride ourselves on our client-centric approach, ensuring that your needs are at the forefront of everything we do. Our services include functional and technical support, admin support, system availability management, incident support, trend analysis, and ticket reduction, among others, all aimed at enhancing your experience and maximizing the value of your Infor investments. Furthermore, our software development capability is at the forefront of innovation. For instance, we are currently enhancing applications in the Financial Services sector using Blockchain technology, showcasing our commitment to leveraging the latest technologies to drive meaningful change for our clients. Infoways offers flexible engagement models and has cultivated a robust talent pool of global resources with expertise in various technologies, including BaaN/LN, M3, Lawson S3, and more. Our team is well-versed in Agile methodology and SDLC best practices, ensuring that projects are delivered on time and within budget. If you are interested in knowing more about how Infoways can support your business and enhance your Infor experience, please let us know. We would be delighted to schedule a meeting with our team at your convenience to discuss Let's Connect We believe in the power of collaboration. Whether you're a client, partner, or future team member, let's embark on this journey together. 📧 [email protected] ☎ 609-718-0720 Join us at Infoways as we navigate the digital landscape, create meaningful solutions, and build a future where innovation knows no bounds.
