Job Description
- The candidate will provide technical expertise in analysis, design, development, rollout and maintenance of data modelling, reporting & integration initiatives. This role will contribute to implementation of methodologies and best practices, as well as work on project teams to synthesize different sources of data into a single source whilst conducting data quality checks.
- Work with stakeholders to identify and define self-service analytic solutions, dashboards, actionable enterprise business intelligence reports. Responsible for deploying repeatable, lean and maintainable enterprise coding and documentation philosophy.
- Essential Duties :
- Design, develop, test, and deploy data validation processes (batch or real-time) using tools such as SQL, Microsoft SSIS, etc.
- Create functional & technical documentation - e.g. data integration architecture documentation, data validation specifications, data testing plans, etc.
- Provide a consultative approach with business users, asking questions to understand the business need and derive the data flow, conceptual, logical, and physical data models based on those needs
- Work with report team to identify, design and implement a reporting user experience that is consistent and intuitive across environments & reporting methods using tools such as Tableau, SSRS, SAP BO, etc.
- Identify business reporting and analytic needs by collaborating with end users, stakeholders and technology teams.
- Contribute to business intelligence competency best practices and implementation methodologies.
- Develop long-lasting, trusted advisor relationships with clients
- Assess customer needs, pain points, behaviors, activation levers, headroom for growth, value propositions, etc.
- Manage day-to-day project operations, serve as the functional and domain expert on the project team to ensure that they meet client expectations
- Develop visual reports, dashboards and KPI scorecards using Tableau desktop (preferred)
- Adept in developing, publishing and scheduling Tableau reports and to visualize various trends as per the business requirements
- Candidate Profile :
- Bachelor's/Master's degree in computer science/engineering, operations research or related analytics areas; candidates with BA/BS degrees in the same fields from the top tier academic institutions are also welcome to apply
- Strong understanding of data integration & validation best practices and concepts
- Experienced with data visualisation tools - Tableau/Power BI, etc., database platforms (e.g. SQL Server, SQL Data Warehouse, etc.).
- Development experience in decision support / business intelligence environments utilizing tools such as SQL Server Integration and Reporting Services, Tableau, SAP Business Objects etc.
- Insurance Industry knowledge preferred but not essential
- 3-6 years' relevant experience preferably in analytics
- Outstanding written and verbal communication skills
- Able to excel in a fast-paced, agile environment where critical thinking and strong problem solving skills are required for success
Job Responsibilities
- Knowledge and working experience with Data Integration processes, such as Data Warehousing, etc.
- Ability to analyse business requirements as they relate to the data movement and transformation processes, research, evaluation and recommendation of alternative solutions
- Ability to transform business requirements into technical requirement documents
- Can create documentation and presentations such that they "stand on their own"
- Demonstrates ability to create new and innovative solutions to problems that have previously not been encountered
- Ability to work independently on projects as well as collaborate effectively across teams
- Must excel in a fast-paced, agile environment where critical thinking and strong problem solving skills are required for success
- Comprehensive understanding of relational databases and technical documentation
- Strong team building, interpersonal, analytical, problem identification and resolution skills
- Can effectively utilise SQL and/or available BI tool to validate/elaborate business rules
- Demonstrates an understanding of EDM architectures and applies this knowledge in collaborating with the team to design effective solutions to business problems/issues
- Deals effectively with all team members and builds strong working relationships/rapport with them.
- Understands and leverages a multi-layer semantic model to ensure scalability, durability, and supportability of the analytic solution.
Location
Gurgaon, Haryana, India