Data Analytics Specialist
About The Position
Conduct software analysis, code analysis, requirements analysis, traffic analysis, site equipment determination, initial system design and dimensioning, coverage planning, site identification, evaluation and zoning support, software review, identification of code metrics, and system risk analysis. Develop and maintain Source Control, configuration, and release management of the Company's SSRS and Power Business Intelligence reports. Develop and support the many existing reports that are primarily based on information from our ERP and related databases including the Company's Financials, Sales/CRM, procurement, inventory management, B2B distribution and catalog-based retail sales data. Assist with the development of new ERP functionality and integrations with other systems as required. Create or assist with the creation of functional Requirements and Technical Specifications as well as documenting the enhancements to the Company's existing SSRS reports and Power Business Intelligence reports. Use Visual Studio and SQL Server Report Builder to modify and enhance the existing repository of SSRS reports or to develop new SSRS and Power BI reports from data in replicated MS Dynamics AX tables as well as custom tables, DII views and data files. Develop and/or assist with the development of API integrations with the Company's partners and vendors to access and consolidate information required for operational dashboards and reports. Work with the Company's other software .NET developers to add new functionality to various web-based portals. Provide advice and training as required to the IT team regarding Power BI reports, data warehousing and retention of the Company's information.
Requirements
- Bachelor’s degree or foreign equivalent in Computer Science, Information Technology, Engineering Management, or a related field.
- At least 2 years of experience as a Data Analytics Specialist, Developer, or related occupation.
- Experience with the following technologies:
- Microsoft Dynamics AX 4.0
- Microsoft SQL Server Reporting Services (SSRS)
- Microsoft Power BI Report Server (legacy)
- Microsoft Power BI services
- Microsoft SQL Server development and administration
- ANSI-compliant Structured Query Language (SQL)
- Relational data modeling
- JSON, XML, CSV document parsing
- Azure DevOps CI/CD task tracking and assignment
- VendEngine, TechFriends and CoreWarehouse data integration and reporting
Responsibilities
- Conduct software and requirements analysis
- Perform system risk analysis and design planning
- Maintain SSRS and Power BI reporting environments
- Develop and support ERP-based reporting solutions
- Create functional requirements and technical specifications
- Develop and enhance SSRS and Power BI reports
- Integrate data through APIs with partners and vendors
- Collaborate with .NET developers on web portal functionality
- Provide training and guidance to IT teams on reporting and data warehousing
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
Number of Employees
5,001-10,000 employees
