Data Analyst
Location: Columbia, SC
Duration: 12 Months
Job Summary: Engage with business and IT stakeholders to help derive requirements for Business Intelligence Solutions and to work with the Data Scrum/Agile teams to translate those requirements into accurate technical specifications. Responsible for performing data analysis in the areas of data management inclusive of relational data modeling, dimensional modeling, data movement and data quality to provide support of execution of SQL queries, stored procedures, functions and other database objects in multiple environments within the Data Team. Will import, cleanse, transform, validate and perform data mappings with the purpose of identifying data patterns to recommend process improvements to gain data efficiencies. Ensure that all data integration points are implemented in a manner that efficiently satisfies the business and/or technical requirements.
Principal Duties & Responsibilities
§ Elicit and document data and business requirements
§ Helps to define Enterprise Information requirements
§ Examines existing business models and flows of data and designs functional specifications for new systems to meet client's needs
§ Collaborates with the Data Architecture Team to provides a view to BI solution elements relating to analytical reporting
§ Identifies data quality issues and supports data governance initiatives by participating in necessary activities including data profiling
§ Participates in technical design sessions, working with technical resources, to provide insight during solution development
§ Utilizes a range of Analysis Techniques to elicit and present requirements towards solutions
§ Reviewing Corporate Information exploitation, the effectiveness of their Informational Systems and gaps between their information requirements and capabilities
§ Works with the Data Teams to ensure that the technical specifications have been successfully delivered and meet the requirements
§ Liaison with internal/external customers in order to analyze business processes, clarify clients‟ requirements and to define the scope of existing software, hardware and network provision
§ Responsible for the design, development and administration of transactional and analytical data constructs/structures
§ Performs other duties as required
Education & Experience
§ Bachelor's degree in Computer Science, Information Systems, or other related field and six to eight years of related work experience or an equivalent combination of education and experience
§ Experience in working in a SCRUM/Agile work environment
§ Experience in working with industry models for either insurance, banking, capital markets, financial regulation or compliance (preferred)
§ Experience in some type of analysis role (preferred)
Job Knowledge & Skills
§ Ability to design and build data input and data collection screens
§ Ability to understand the reason for each data driven business process and the basic concepts of designing a business report, dashboard, KPI, etc. to meet the business need
§ Experience of knowledge of integration issues and technologies including data profiling and data quality
§ Experience of working with industry models for either insurance, banking, capital markets, financial regulation or compliance.
§ Knowledge and understanding of how Big Data is currently impacting the Insurance sector
§ Ability to work with structured and unstructured data – batch and real time
§ Ability to articulate and present different points-of-views on various technologies and analysis techniques
§ Verbal and written communication including facilitation, presentation, and documentation
SQL Data Queries | Intermediate | Hadoop | Basic |
SDLC processes and methodologies (RUP, Agile, Waterfall) | Intermediate | MongoDB | Basic |
Data Analysis | Intermediate | Software Development processes | Advanced |
Conceptual & Logical Data Models | Intermediate | Data Warehouse Development Cycle | Advanced |
Core Organizational Competencies
Competency | Description |
Action Oriented | Enjoys working hard; is action oriented and full of energy for the things he/she sees as challenging; is not fearful of acting with a minimum of planning; seizes more opportunity than others. |
Customer Focus | Is dedicated to meeting the expectations and requirements of internal and external customers; drives to resolution of customer issues; gets first-hand customer information and uses it for improvements in products and services; acts with customers in mind; establishes and maintains effective relationships with customers and gains their trust and respect. |
Adaptability | Can effectively cope with change; can shift gears comfortably; can decide and act without having the total picture; isn't upset when things are up in the air; can multi-task, handle multiple objectives; can comfortably handle risk and uncertainty. |
Listening | Practices attentive and active listening with colleagues and customers; has the patience to hear people out; can accurately restate the opinions of others even when he/she disagrees. |
Ethics and Values | Adheres to an appropriate (for the setting) and effective set of core values and beliefs during both good and bad times; acts in line with those values; rewards the right values and disapproves of others; practices what he/she preaches. |
Integrity and Trust | Is widely trusted; is seen as a direct, truthful individual; can present the unvarnished truth in an appropriate and helpful manner; keeps confidences; admits mistakes; doesn't misrepresent him/herself for personal gain. |
Functional Competencies
Competency | Description |
Business Acumen | Knows how businesses work; knowledgeable in current and possible future policies, practices, trends, and information affecting his/her business and organization; knows the competition; is aware of how strategies and tactics work in the marketplace. |
Intellectual Horsepower | Is bright and intelligent; deals with concepts and complexity comfortably; described as intellectually sharp, capable, and agile. |
Perspective | Looks toward the broadest possible view of an issue/challenge; has broad-ranging personal and business interests and pursuits; can easily pose future scenarios; can think globally; can discuss multiple aspects and impacts of issues and project them into the future. |
Planning | Accurately scopes out length and difficulty of tasks and projects; sets objectives and goals; breaks down work into the process steps; develops schedules and task/people assignments; anticipates and adjusts for problems and roadblocks; measures performance against goals; evaluates results. |
Problem Solving | Uses rigorous logic and methods to solve difficult problems with effective solutions; probes all fruitful sources for answers; can see hidden problems; is excellent at honest analysis; looks beyond the obvious and doesn't stop at the first answers. |
CONTACT:
Ibrahim (Abraham) Khaleelullah
Ph: +1-678-720-3170
WhatsApp: +91-95973 92178
Skype: abraham_vdart
Email: abraham@vdartinc.com
9:02:00 AM
