Lead Assistant Manager - Data Analytics - Consulting Firm

Job Summary:

- 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

- Is able to understand cross cultural differences and can work with clients across the globe

Preferred Skills & Experience:

- 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.