• US Citizen

• Green Card

• EAD (OPT/CPT/GC/H4)

• H1B Work Permit

• Corp-Corp

• W2-Permanent

• W2-Contract

• Contract to Hire

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 9th Jan 2024

Skills/Knowledge

The ideal candidate for this position should possess a high level of proficiency in handling complex SQL queries, showcasing expertise in analyzing data from diverse sources. A crucial aspect of the role involves creating meticulous mapping documents for deployment in ELT (Extract, Load, Transform) development and facilitating end-user reporting. This proficiency is essential for maintaining the integrity and efficiency of the Data Warehouse, ultimately contributing to effective data-driven decision-making processes within the organization.

Because facilitation is essential to data analysis, expert communication skills will be required.

? Minimum 10 years’ Experience working as a data analyst in business intelligence, analytics and Enterprise Data Warehousing environments

? Minimum 10 years’ Experience with design, development and support of normalized data structures 

? Minimum 10 years’ Experience analyzing, data profiling, data mining, data cleansing, data content, scrubbing data, and translating data via rules from one database to another 

? Minimum 10 years’ Experience with Data Warehouse tools and techniques

? Minimum 10 years’ Experience with theories, principles, and best practices, Data Governance, Data Quality Management, Metadata Management, and Conceptual and Logical Data Design

? Minimum 10 years Strong Data Analysis skills to include data quality, source systems analysis (DB2, Oracle, Snowflake, SQL Server etc.) business rules validation, source to target mapping design, prepare sample data example and data validation with ELT team 

? Ability to establish and maintain positive collaborative relationships with team members.

? Skill in the use of organizational tools & methods (MS Excel, MS Word, MS Outlook, MS Teams)

Nice to Have:

? Experience with MPP Databases (Snowflake, RedShift, etc.)

? Experience with Cognos/Tableau business intelligence tools

? Experience with Agile approaches such as Business Event Analysis and Modeling

? Knowledge of property and casualty insurance systems

? Knowledge of Ohio business processes

Education Required 

? Four-year college degree in Computer Science or similar form of study