The technical consultant will be responsible to develop and maintain analytics solution to support business needs. The candidate should have experience in SQL server, .NET, Python development with knowledge of database, reporting and dashboards. The consultant will be responsible for extracting insights, developing reporting solutions and ensure decisions are data driven. The consultant will work closely with functional teams to deliver high-quality technical solutions, ensure seamless system performance, and maintain operational continuity.

ACCOUNTABILITIES

Development & Automation: Utilize .NET and Python for scripting, automation and development of custom analytics dashboards with predictive analytics

Integration & Management: Leverage SQL for data integration, database queries, and optimization to ensure seamless data exchange and system performance.

Solution Design: Collaborate with business and functional consultants to design technical solutions that align with business requirements.

Troubleshooting & Support: Provide technical support for data analytics related issues, diagnosing and resolving system errors, performance bottlenecks, and bugs.

System Upgrades & Patches: Implement system upgrades, patches, and new releases, ensuring minimal downtime and seamless integration.

Documentation: Create and maintain detailed technical documentation, on the changes

Stakeholder Communication: Work with cross-functional teams, Users, SAP consultants, Salesforce consultants for data migration, integration and reporting

EXPERIENCE & TECHNICAL KNOWLEDGE

• Strong experience in SQL Server database management and query optimization
• Hands on experience in .NET and Python for development & automation
• Knowledge of data lake technologies and best practices for data management
• Proficiency in creating dashboard using PowerBI, Tableau, any other analytics platform
• Strong analytics skills and ability to work with large datasets
• Proficiency in dot net C/AL (Client/Server Application language) and AL (Application Language) for custom developments
• Experience in SQL including querying, performance tuning and integration with third party systems
• Understanding of data models, database management and transactional workflows
• Knowledge of REST API and web services integration with other third party system is a plus.
• Troubleshooting and Problem Solving
• Excellent communication skills to liase with business users and internal team

EDUCATION & CERTIFICATIONS

Bachelor's Degree in Computer Science/Information Technology or related field

Additional certification in SQL will be a plus