Invent Consulting Ltd is a software development company offering enterprise software solutions, CRM solutions, Business Intelligence solutions and custom web and mobile solutions that help organizations operate efficiently, profitably and productively.
We are seeking a talented and driven Data Analyst to join the team. The developer will be required to design and develop robust Business Intelligence solutions that will provide data, analytics and reports which include but are not limited to performance metrics, KPIs, reports and dashboards.
Job Description- Build models to identify trends, forecast performance, and identify improvements to company strategy, products, and operations
- Design and run data analyses to guide decision-making
- Design and prepare dashboards and reports
- Design and develop automation tools to streamline day-to-day activities
- Ensure consistency, accuracy, and overall integrity of business metrics
- Develop and maintain documentation, training materials, best practices, and overall data toolkit
- Experience working with Microsoft SQL Server
- Experience working with Stored Procedures, Functions and Dynamic SQL Queries
- Experience working with SSAS in creating Cubes, views, named queries, dimensions and deploying of SQL Server Analysis Services Projects
- Proficient in the design, testing and development of multi-dimensional OLAP Cubes using Microsoft SQL Server Analysis Services (SSAS)
- Ability to translate business requirements into logical data models
- Experience working with Microsoft Power BI will be an added advantage
- Strong analysis skills and excellent attention to detail
- Ability to collaborate across the team to build solid and clean code as well as close on projects in a timely manner
Skills Required
- Experience working with Microsoft SQL Server
- Experience working with stored procedures, functions, and dynamic SQL queries
- Experience creating cubes, views, named queries, dimensions, and deploying SQL Server Analysis Services projects using SSAS
- Proficiency designing, testing, and developing multidimensional OLAP cubes using Microsoft SQL Server Analysis Services
- Ability to translate business requirements into logical data models
- Experience working with Microsoft Power BI
- Strong analysis skills and excellent attention to detail
- Ability to collaborate across teams and deliver clean code and projects on schedule
What We Do
Invent Consulting Limited is a software development and data consulting company offering enterprise software, customer relationship management, business intelligence, and custom web and mobile solutions. Its services help organizations operate more efficiently and profitably through analytics, reporting, dashboards, automation, data visualization, migration, integration, and digital transformation. The company serves organizations seeking practical, data-driven improvements to business performance and decision-making.
