Duties and Responsibilities:
- Provide support for design development testing and deployment activities for a
comprehensive reporting module. The module will consist of the following components: - Scheduled Reports: Automatically generated and distributed reports based on predefined
schedules. - Adhoc Reports: Usergenerated reports created on demand supporting realtime data
queries and insights. - Drilldown Dashboards: Interactive dashboards with drilldown capabilities to explore data
at various levels of Detail
- Data Integration and Transformation
- The reporting module must integrate with existing data sources including structured semi1structured and
unstructured data. - Support for ETL (Extract Transform Load) and ELT (Extract Load Transform) processes
allowing efficient data
extraction transformation and loading. - The system should handle large volumes of data providing quick access and insights.
- Report Design
- Implement a draganddrop interface for report creation allowing users to design reports easily.
- Include visual elements such as graphs charts widgets and maps to enhance report readability and
impact. - Support both static and dynamic images animations and filters within reports.
- Ensure reports are pixelperfect reflecting the intended design accurately.
- Allow data filtering based on key performance indicators (KPIs) for targeted insights.
- Interactive Dashboards and Reports
- Develop interactive dashboards that allow users to manipulate data perform queries and personalize
their views. - Include features for automated reporting reducing the need for manual report distribution.
- Ensure dashboards and reports are responsive and adaptable to various devices including mobile.
- Report Types
- Adhoc Reports: Enable users to create reports onthefly particularly for fastpaced environments
like social media analytics and financial analysis. - Scheduled Reports: Generate and distribute reports at predefined intervals following a set format.
- Pivot Tables: Provide tools to summarize and analyze large datasets efficiently.
- Crosstab Reports: Display relationships between multiple variables in a matrix format.
- Informational Reports: Present data metrics asis offering a unified view of information.
- Analytical Reports: Provide insights interpretations and recommendations based on selected data.
- Transactional Reports: Capture and display detailed information about customer interactions.
- Mobile BI Reporting
- Develop mobilecompatible reporting applications with userfriendly interfaces and responsive
dashboards. - Include collaboration features within mobile reports supporting teamwork regardless of location.
- Implement push notifications alerts and offline mode capabilities to enhance productivity for
remote users. - Ensure robust security measures are in place to protect sensitive data
Education and Years of Experience:
- Bachelors degree in computer science Information Technology or a related field.
- 12 years of overall experience with 10 years working with the technologies required
Required and Desired Skills/Certifications:
- Extensive experience in programming in C#
- Recent experience with projects developed in an Azure Cloud environment
- Extensive Microsoft SQL experience
- Experience generating ad hoc reports and queries. Examples are:
Scheduled Reports: Automatically generated and distributed reports based on predefined schedules. - Adhoc Reports: Usergenerated reports created on demand supporting realtime data queries and insights.
- Drilldown Dashboards: Interactive dashboards with drilldown capabilities to explore data at various levels
of detail.
Additional Requirements:
Knowledge of Structured Query Language (SQL) and Stored Procedures with at least five (5) years of
handson experience.
Knowledge of using HTTPS with at least five (5) years of experience.
Evidence of using each of the above specialized experience within the last five (5) years.