Role Proficiency
Independently provides expertise on data analysis techniques using software tools; streamlining business processes and managing team
Outcomes
- Managing and designing the reporting environment including data sources security and metadata.
- Providing technical expertise on data storage structures data mining and data cleansing.
- Supporting the data warehouse in identifying and revising reporting requirements.
- Supporting initiatives for data integrity and normalization.
- Assessing tests and implementing new or upgraded software and assisting with strategic decisions on new systems.
- Synthesize both quantitative and qualitative data into insights
- Generating reports from single or multiple systems.
- Troubleshooting the reporting database environment and reports.
- Understanding business requirements and translating it into executable steps for the team members.
- Identify and recommend new ways to streamline business processes
- Illustrates data graphically and translates complex findings into written text.
- Locating results to help the clients make better decisions. Get feedback from clients and offer to build solutions based on the feedback.
- Review the team’s deliverables before sending final reports to stakeholders.
- Support cross-functional teams with data reports and insights on data.
- Training end users on new reports and dashboards.
- Set FAST goals and provide feedback on FAST goals of reportees
Measures Of Outcomes
- Quality - number of review comments on codes written
- Accountable for data consistency and data quality.
- Number of medium to large custom application data models designed and implemented
- Illustrates data graphically and translates complex findings into written text.
- Number of results located to help clients make informed decisions.
- Attention to detail and level of accuracy.
- Number of business processes changed due to vital analysis.
- Number of Business Intelligent Dashboards developed
- Number of productivity standards defined for project
- Manage team members and review the tasks submitted by team members
- Number of mandatory trainings completed
Outputs Expected
Determine Specific Data needs:
- Work with departmental managers to outline the specific data needs for each business method analysis project
Management And Strategy
- Oversees the activities of analyst personnel and ensures the efficient execution of their duties.
Critical Business Insights
- Mines the business’s database in search of critical business insights and communicates findings to the relevant departments.
Code
- Creates efficient and reusable SQL code meant for the improvement manipulation and analysis of data.
- Creates efficient and reusable code. Follows coding best practices.
Create/Validate Data Models
- Builds statistical models; diagnoses validates and improves the performance of these models over time.
Predictive Analytics
- Seeks to determine likely outcomes by detecting tendencies in descriptive and diagnostic analysis
Prescriptive Analytics
- Attempts to identify what business action to take
Code Versioning
- Organize and manage the changes and revisions to code. Use a version control tool like git bitbucket. etc.
Create Reports
- Create reports depicting the trends and behaviours from the analysed data
Document
- Create documentation for own work as well as perform peer review of documentation of others' work
Manage Knowledge
- Consume and contribute to project related documents share point libraries and client universities
Status Reporting
- Report status of tasks assigned
- Comply to project related reporting standards/process
Skill Examples
- Analytical Skills: Ability to work with large amounts of data: facts figures and number crunching.
- Communication Skills: Communicate effectively with a diverse population at various organization levels with the right level of detail.
- Critical Thinking: Data analysts must look at the numbers trends and data and come to new conclusions based on the findings.
- Presentation Skills - reports and oral presentations to client
- Strong meeting facilitation skills as well as presentation skills.
- Attention to Detail: Making sure to be vigilant in the analysis to come to correct conclusions.
- Mathematical Skills to estimate numerical data.
- Work in a team environment
- Proactively ask for and offer help
Knowledge Examples
Knowledge Examples
- Database languages such as SQL
- Programming language such as R or Python
- Analytical tools and languages such as SAS & Mahout.
- Proficiency in MATLAB.
- Data visualization software such as Tableau or Qlik or Power BI.
- Proficient in mathematics and calculations.
- Spreadsheet tools such as Microsoft Excel or Google Sheets
- DBMS
- Operating Systems and software platforms
- Knowledge about customer domain and also sub domain where problem is solved
Additional Comments
Data Engineering (Quality and Governance) JOB SUMMARY AND RESPONSIBILITIES
- Leverage analytical skills, creative problem solving and project management skills to steer and uplift the existing Data Governance model.
- Organize discussions with key stakeholders to understand how our technology works, thereby empowering you to define specific data attributes and identify the relevant owners and source system(s) along with Data flows.
- Provide effective thought leadership to navigate the evolving financial regulatory landscape and help develop technological solutions to build appropriate architecture
- Improve the risk framework for data governance by documenting existing controls, analyzing their suitability, and recommending new controls for implementation
- Manage relationships with professionals from other teams and divisions by articulating recommendations in order to gain cross-divisional consensus
- Develop strong working relationships with Sales, Legal, Compliance, Controllers, technology and other groups in establishing the Data Governance model and keeping it up to date
- Proficiency in Business Intelligence & Low code Automation solutions to digitize the Data Governance framework and improve efficiency
- Engage with relevant stakeholders for Data remediation to support regulatory uplift or data clean up as an interim measure, while we work through the strategic solution. BASIC QUALIFICATIONS
- Strong analytical and project management skills
- Excellent communication skills both written and verbal
- Exceptional attention to detail and accuracy
- Ability to handle multiple projects, deadlines, personalities, and broad based coverage
- Knowledge and understanding of Excel, PowerPoint, Word and adaptability to other software products
- Ability to work in a fast-paced, team-oriented environment
- Experience with configuring and using Data Governance tools (e.g. Collibra) is preferred
- Knowledge of the investment management industry and GSAM is a bonus
- Business Intelligence experience & relevant certifications (Tableau/ Alteryx) are a bonus
Desired Skills and Experience
Collibra