Jet Analytics/SQL Server Consultant Needed

@tangramua

Dear ,   We carefully studied the description of your project and we can confirm that we understand your needs and are also interested in your project. Our team has the necessary resources to start your project as soon as possible and complete it in a very short time.   We are 25 years in this business and our technical specialists have strong experience in SQL, ERP, Dynamics, Database Administration, Microsoft SQL Server, Database Development, Data Warehousing, Business Intelligence, ETL, Data Modeling and other technologies relevant to your project.   Please, review our profile https://www.freelancer.com/u/tangramua where you can find detailed information about our company, our portfolio, and the client's recent reviews.   Please contact us via Freelancer Chat to discuss your project in details.    Best regards, Sales department Tangram Canada Inc.     

@Appworldz

Hi, This is exactly the kind of Dynamics NAV and BI infrastructure troubleshooting I handle. I've worked with NAV 2016, LS Retail, Jet Analytics/Jet Data Manager, SQL Server, SSAS cubes, ETL pipelines, and SQL Agent jobs where intermittent cube failures were impacting reporting reliability. My approach is to perform a structured diagnostic of Jet configuration, warehouse loads, cube processing, SQL performance, job history, and custom NAV data flows to identify the true root cause rather than treating symptoms. I can also provide long term fractional support after stabilization. Rate: $125 USD/hour Initial Diagnostic: 12 to 16 hours ($1,500 to $2,000) Timeline: 3 to 5 business days Sahanaj

@skalogir

Hello, I understand you need a backend Jet Analytics / Jet Reports consultant to diagnose and stabilize an unreliable SQL Server and SSAS cube environment connected to a heavily customized Dynamics NAV 2016 system with LS Retail. I have experience troubleshooting SQL Server Agent jobs, ETL refresh failures, SSAS/OLAP cube processing, data warehouse issues, Jet Analytics or Jet Data Manager configurations, and NAV/Navision data structures. I will start with a paid diagnostic covering Jet configuration, job schedules, logs, cube processing history, refresh dependencies, and failure patterns, then provide root-cause findings, stabilization recommendations, remediation estimate, and optional fractional support. Q1: Do you have recent SQL Agent, SSAS, and Jet failure logs available? Q2: Is the cube failure intermittent, schedule-based, or tied to specific NAV/LS Retail tables? Q3: Do you need support during Pacific/Mountain business hours only? Best regards.

@waqarinfo

Hello, I understand that you are looking for an experienced consultant to diagnose and stabilize your Jet Analytics / Jet Reports / SQL Server / SSAS cube environment connected to a heavily customized Microsoft Dynamics NAV 2016 system. I have extensive expertise in Microsoft SQL Server, SQL, Database Administration, and ERP systems, making me well-equipped to handle the complexities of your project. I propose to thoroughly review your Jet Analytics / Jet Data Manager configuration, SQL Server jobs, SSAS cube processing, and identify the root cause of the instability issues. I will then recommend effective stabilization steps and provide estimates for remediation and ongoing support. I am confident that my skills and experience align perfectly with the requirements of your project. Let's initiate a chat to discuss your project in detail. Best regards, Waqar H.

@edwarddzi8f

Hi there, I can help you with diagnosing the Jet Analytics cube environment. I've worked extensively with Dynamics NAV 2016 and SSAS cubes, including LS Retail setups. The periodic failures you're seeing are often tied to SQL Server Agent job timing conflicts or cube processing memory thresholds. I can review your logs, job schedules, and Jet Data Manager config to pinpoint the root cause. I'm Edward, a database developer with over a decade of experience in SQL Server and BI environments. Happy to start with a diagnostic and go from there.

@mobasherreza10

With your project's pressing need for an experienced consultant, I'm confident that my multifaceted skills perfectly align with your requirements. My strong background in Business Intelligence and Database Administration makes me well-equipped to diagnose, stabilize, and optimize your intricate Jet Analytics / Jet Reports / SQL Server / SSAS cube environment seamlessly integrated with Dynamics NAV 2016. I've successfully handled similar projects like yours before, troubleshooting complex ETL processes, streamlining data warehouses, and resolving OLAP cube issues. I'm fully conversant with the intricacies of Jet Analytics and Jet Data Manager as well as the full range of SQL Server components such as SQL Server Agent jobs. With strong experience in Dynamics NAV data structures complemented by a solid competency in LS Retail embedded solutions, I assure you that I will swiftly identify the root cause of your cube instability and propose effective stabilization steps.

@Hubready

Hello! I am a US-based senior software engineer with extensive experience in SQL, data warehousing, and business intelligence solutions. I’ve carefully read your project description regarding the Jet Analytics/SQL Server consultant role and understand the importance of stabilizing your analytics environment for optimal performance. With over 15 years in the industry, I've tackled similar challenges, ensuring robust database administration and effective ETL processes. My approach involves diagnosing issues thoroughly and implementing tactical solutions to ensure your reporting is accurate and efficient. Could you please clarify the following questions to help me better understand the project? 1. Are there specific performance issues you've identified in Jet Analytics that need immediate attention? 2. Do you have existing documentation on your current data models and ETL processes? I have worked on projects involving complex data pipelines and analytics frameworks. For example, I developed an analytics dashboard for a financial service and optimized database performance for a retail platform. I’m committed to delivering results that meet your expectations and drive your business forward. Let’s connect to discuss how I can help stabilize and enhance your Jet Analytics setup. Looking forward to your response! Best, James Zappi

@technologiesit

Having spent over a decade in Full Stack Development and Digital Solutions field, I've had ample exposure to the technologies integral to your project - Jet Analytics / Jet Reports / SQL Server / SSAS cube environment and Dynamics NAV 2016 system. My skills in Data Modeling, ETL, and SQL have allowed me to design and troubleshoot complex systems just like the one you're facing. I understand the criticality of a reliable and properly-refreshed cube environment for report generation, which sets me up well to diagnose faults, offer tailored stabilization steps, and ensure long-term support. While my geographic location may not be centred in your requirements, I ensure extensive time-zone overlap with California and Utah that would enable seamless collaboration with your IT team. Having personally executed 100+ successful projects, I recognize the value of fast delivery, clear communication, and long-term support; qualities that are central to your project's needs. Choosing me doesn't mean opting for someone who merely has the skillset; it also means gaining a partner in turning your vision into reality - with scalability and reliability at the core. Let's reconnect dynamic NAV data structures by addressing any issues encompassing Jet Analytics / Jet Data Manager configuration, SQL Server jobs & schedules as well as SSAS cube processing. Let my experience merge seamlessly with your customized NAV environment for a robust solution!

@toriquldev123

Hello Dear! Greetings from Toriqul Global Solutions! We are pleased to introduce our company as a reliable and experienced provider of Web Design & Development services. Founded and led by Engineer Toriqul Islam, a B.Sc. graduate in Computer Science & Engineering from Rajshahi University of Engineering & Technology (RUET), our team brings over 10 years of industry experience. At Toriqul Global Solutions, we specialize in building modern, user-friendly, and high-performance websites that help businesses grow and stand out in the digital world. Our design approach focuses on simplicity, elegance, and functionality to ensure maximum user engagement. I have some question-- Please start a conversation to discuss your project. Technologies We Use: Custom Websites Development Using ======>Full Stack Development. 1. HTML5 2. CSS3 3. Bootstrap4 4. jQuery 5. JavaScript 6. Angular JS 7. React JS 8. Node JS 9. WordPress 10. PHP 11. Ruby on Rails 12. MYSQL 13. Laravel 14. .Net 15. CodeIgniter 16. React Native 17. SQL / MySQL 18. Mobile app development 19. Python 20. MongoDB We would be honored to discuss your project requirements and help bring your ideas to life. Thank you for your time and consideration. Warm Regards, Toriqul Global Solutions

@smitk9999

Hello, I can help diagnose and stabilize your Jet Analytics, SQL Server, SSAS, ETL, and Dynamics NAV 2016 cube environment. This sounds like a backend reliability issue, likely around Jet Data Manager jobs, SQL Agent schedules, cube processing failures, customized NAV tables, or resource/locking problems during refresh. I’ll start with a paid diagnostic covering Jet configuration, SQL Server Agent history, ETL logs, SSAS processing, data warehouse structure, and NAV/LS Retail customizations. Then I’ll document the root cause, stabilization plan, remediation estimate, and support options. I have strong SQL Server, data warehousing, backend systems, and production troubleshooting experience. I’m comfortable working with customized ERP data structures and can overlap with Pacific/Mountain Time as needed. I am ready to start with the diagnostic. Best regards, Smit

@purealmaz

Regarding your project, I have a quick question: Are the SSAS cube processing failures happening during the `Process Full` stage, or are they incremental processing failures? Also, what specific error messages are you seeing in the SQL Server Agent job history logs? I plan to approach this by using SQL Server Profiler and Extended Events, alongside the SSAS and Jet Data Manager logs, to trace the entire ETL process. This systematic diagnostic will allow us to pinpoint the exact point of failure and diagnose the root cause of the instability. I previously tackled a similar challenge in this project: https://dev.telepie.ai. There, I engineered a high-scale backend, performing deep diagnostics to stabilize the infrastructure under heavy load and implementing robust monitoring to ensure uptime—principles directly applicable to stabilizing your data warehouse environment. Let's connect to discuss the architecture. Regards, Philip O.

@MIndlabsAi6

Hey there, I'm Vishal Maharaj, a seasoned SQL expert with 25 years of experience in Database Development, Microsoft SQL Server, Data Modeling, Database Administration, and ETL based in Perth, Australia. I understand the complexities of your project involving Jet Analytics, SQL Server, and Dynamics NAV 2016. I would approach this by conducting a thorough diagnostic, identifying root causes, recommending stabilization steps, and providing ongoing support for a reliable solution. Let's discuss further to address the issues and ensure a stable environment for your operations. Cheers, Vishal Maharaj

@trm66614

I can effectively diagnose and stabilize your Jet Analytics and SQL Server environment. With my experience in Data Modeling and Database Development, I understand the importance of reliable data processing. I will review your Jet Analytics and SQL Server configuration closely to identify root causes of the issues you've encountered. My understanding of Dynamics NAV 2016 and the specifics of OLAP cubes means I can recommend steps to stabilize your environment. I also bring expertise in troubleshooting SQL Server Agent jobs, which is vital in addressing the instability and failures in refreshing the cubes. How often do the failures occur? What error messages are you seeing during refresh failures? Can you share logs from SQL Server about the job history? Are there any specific times your environment is more unstable? I look forward to helping you create a reliable data structure.

@alyn48

Hello, there! I will perform a focused diagnostic review of your Jet Analytics / Jet Reports / SQL Server / SQL Server Analysis Services environment connected to your heavily customized Microsoft Dynamics NAV 2016 with LS Retail. The goal is to identify the root cause of cube instability and refresh failures. I will review Jet Data Manager configuration, ETL processes, SQL Server Agent jobs, SSAS processing logs, and NAV/LS Retail data structures to trace where breakdowns occur across the pipeline. Based on findings, I will provide a clear stabilization plan with prioritized fixes, along with architectural recommendations to ensure reliable cube processing and scheduled refreshes. The deliverable will include a diagnostic report, remediation roadmap, and option for ongoing fractional support if required. Best regards.

@PINESCRIPTERR

Hi, your project "Jet Analytics/SQL Server Consultant Needed" is clear, and I can take care of the implementation. I also noticed the listed skills include SQL ERP Dynamics Database Administration Microsoft SQL Server Database Development Data Warehousing Business Intelligence ETL Data Modeling. I will keep the delivery simple: confirm the setup, build the required part, test it, and hand it over clearly. My focus would be a clean technical setup around the database, API, and integration points. To set this up properly: - What data fields are required, and how should errors or missing values be handled? - What backend structure, database, user roles, and admin access should the implementation support? - Where should the completed work be deployed, and what hosting access will be provided? Best regards, Houssame

@muzammilf0

I can help diagnose the instability in your Jet Analytics + SSAS cube environment connected to Dynamics NAV 2016 and LS Retail. I have experience with SQL Server, SSAS OLAP cubes, ETL processes, and NAV data warehouse troubleshooting, especially around failing refresh jobs and broken cube processing. I’ll review Jet Data Manager, SQL Agent jobs, and SSAS logs to quickly identify the root cause and provide a clear stabilization plan with next steps. Available to start with a paid diagnostic and align with your time zone.