Senior Data Analyst

Duration: 6 Months Contract-to-Hire
Location: Westfield Center Ohio - HYBRID, must be onsite 3-days per week (T, W, Th)
Highlight 3-5 Must Have Skill Set
Consultant Data Analyst
Candidate must have 10 + years of experience as a Data Analyst.
BA/ BS Degree is required.
Client is seeking a highly experienced, analytical and highly resourceful Data professional with extensive experience in Data Analysis, Business analysis, Data Warehouse, ETL, Data Modeling, Data migration, Data integration and Data Profiling.
Selected candidate will be spending 80% of their time performing Data Analysis and 20% of their time performing Design & Data Modeling.
Candidate must have Insurance Industry Policy & Claims experience – specifically with Property & Casualty.
Candidate must have other less experienced Data Analyst team members with determining data options.
Candidate must have Experience in Python, SQL scripting, SQL Server and ErWin or other modeling tools.
Candidate experience with Snowflake is a nice to have.
Candidate must have Agile development experience.
Certifications: Data Analyst Certified or other industry certifications (Nice to have)
Additional Desired Qualifications:
1. Must have 10 + years of experience as a Data Analyst.
2. Must have 10 + years of experience understanding business requirements, translating them into data requirements, analyzing and designing data processes and assisting in building a solution to support the business requirements.
3. Must have prior experience systematically applying logical reasoning techniques to query, inspect, cleanse, profile, and study data in structured, semi-structured, and unstructured formats for the purpose of deriving knowledge to support business decision-making and mapping data between source and target systems to support application integrations.
4. Must have prior experience developing SQL Programming with the ability to perform the most complex queries against relational databases in an efficient manner.
5. Must have experience building conceptual, logical and physical data models which are visual representations of an enterprise's business data. Experience with ErWin or other modeling tools a plus. Able to build and modify simple data models.
6. Bachelor’s degree in Information Technology, Computer Science, Engineering, Mathematics or related field with commensurate experience.
DUTIES:
1. Performs data analysis, data profiling and data sourcing utilizing knowledge of data definitions, domain values, data relationships, business rules, data sources and the enterprise integrated data environment.
2. Gathers and documents functional and non-functional data requirements.
3. Creates, updates, and validates source to target mapping documents.
4. Analyzes impacts of planned new application development or enhancements to existing applications on legacy and other relational data stores and the enterprise integrated data environment.
5. Creates conceptual, logical, and physical data models in support of requested changes.
6. Loads and manages reference data in partnership with business customers.
7. Analyzes and identifies data quality concerns or cleansing opportunities to correct data quality anomalies and facilitate resolution between technical, business, and other stakeholders.
8. Ensures deliverables are compliant with data standards.
9. Serves as a peer mentor to less experienced data analysts.
AGAIN – Must be within 50 miles of Westfield Office.
Job Type: Contract
Application Question(s):

"This position requires candidates to be authorized to work in the United States. We are specifically seeking U.S. citizens or Green Card holders at this time due to government regulations and client needs."
As per the client’s request, candidates must be located within 50 miles of the client’s location Westfield Center Ohio - HYBRID, must be onsite 3-days per week (T, W, Th). If you are willing to work HYBRID, must be onsite 3-days per week (T, W, Th), please apply.
Data Analysis, Business Analysis, Data Warehouse, ETL (Extract, Transform, Load), Data Modeling, Data Migration, Data Integration, Data Profiling with 12-15 years of experience.
Experience in Python
Experience in SQL Scripting
Experience in SQL Server
Experience in ErWin or other modeling tools
Experience in Agile Development
•
• Must Insurance Industry (Policy & Claims – Property & Casualty)
•
• Experience in Data Quality Analysis and Cleansing
Experience in Mentoring and assisting less experienced Data Analysts

Education:

Bachelor's (Required)

Work Location: Hybrid remote in Westfield Center, OH 44251