Jet Analytics/SQL Server Consultant Needed
Budget: $100 – $225 USD
We need an experienced consultant to help diagnose and stabilize a Jet Analytics / Jet Reports / SQL Server / SSAS cube environment connected to a heavily customized Microsoft Dynamics NAV 2016 system.
The cube environment is unreliable and periodically goes down or fails to refresh properly. We need someone who can perform a paid diagnostic, identify root cause, recommend stabilization steps, and potentially continue with longer-term fractional support.
This is not basic Jet Reports report writing and not a general Power BI dashboard project. We need backend experience with Jet Analytics or Jet Data Manager, SQL Server, SSAS / OLAP cubes, SQL Server Agent jobs, ETL troubleshooting, data warehouse design, and Dynamics NAV / Navision data structures.
Current environment:
- Dynamics NAV 2016
- Heavily customized NAV environment
- LS Retail embedded
- Jet Reports / Jet Analytics
- SQL Server
- SSAS / OLAP cube environment
Initial scope:
- Review Jet Analytics / Jet Data Manager configuration
- Review SQL Server jobs, schedules, logs, and failure history
- Review SSAS cube processing and refresh failures
- Identify why the cube goes down or fails to refresh
- Recommend stabilization steps
- Provide estimate for remediation and ongoing support
Pacific or Mountain Time preferred because our IT team is in California and Utah. U.S.-based candidates preferred, but we may consider others with strong experience and good time-zone overlap.
The cube environment is unreliable and periodically goes down or fails to refresh properly. We need someone who can perform a paid diagnostic, identify root cause, recommend stabilization steps, and potentially continue with longer-term fractional support.
This is not basic Jet Reports report writing and not a general Power BI dashboard project. We need backend experience with Jet Analytics or Jet Data Manager, SQL Server, SSAS / OLAP cubes, SQL Server Agent jobs, ETL troubleshooting, data warehouse design, and Dynamics NAV / Navision data structures.
Current environment:
- Dynamics NAV 2016
- Heavily customized NAV environment
- LS Retail embedded
- Jet Reports / Jet Analytics
- SQL Server
- SSAS / OLAP cube environment
Initial scope:
- Review Jet Analytics / Jet Data Manager configuration
- Review SQL Server jobs, schedules, logs, and failure history
- Review SSAS cube processing and refresh failures
- Identify why the cube goes down or fails to refresh
- Recommend stabilization steps
- Provide estimate for remediation and ongoing support
Pacific or Mountain Time preferred because our IT team is in California and Utah. U.S.-based candidates preferred, but we may consider others with strong experience and good time-zone overlap.