Data Analyst

Itech Solutions Philadelphia , PA 19103

Posted 2 months ago

Data Analyst

Headquartered in Philadelphia, Our client connects lenders, homebuyers, investors and loan servicers using a suite of private mortgage insurance and related risk management products and services. We help promote and preserve the tradition of homeownership while protecting lenders from default-related losses on residential first mortgages.

We also facilitate the sale of low-down payment mortgages in the secondary market. Our commitment to homeownership is built on a foundation of evaluating credit risk; we help clients and investors expertly and prudently manage risk in any market condition.

Basic Purpose/Function: The Data Analyst proactively participates in developing artifacts that are consumed by the data engineering team such as source to target mappings, data quality rules, and data transformation rules for our data migration project.

The Data Analyst must be a critical thinker who can investigate an issue, review the results, and provide a suggested solution to the problem. The Data Analyst works closely with a variety of partners including the data architects, the data engineering team, the application development team, the QA team, and business partners. Therefore the Data Analyst must be able to effectively communicate to ensure others understand the information that is provided to them as well as any request that is made of them.


Primary Duties and Responsibilities:

Partner with business stakeholders to develop specifications for data integration & movement that includes performing data analysis, identify data related issues and provide a suggested resolution, create source/target mappings and transformation, load and data cleansing rules.
Support development troubleshooting of data defects with transactional system.
Champion data quality. Investigate data quality issues and develop improvement plans. Maintain metadata and support the firm's metadata platform
Actively participate in projects and complete duties as assigned by manager and project leadership

Knowledge:
Bachelor's degree in Math, Economics, Physics, Engineering, Computer Science, Statistics or other data analysis discipline.
Demonstrated experience considered in lieu of technical degree.
3+ years' experience with data migration and SQL required
2+ years' experience with SQL Server or Oracle is required
Understanding of data movement (ETL)
Knowledge and familiarity with current mortgage loans evaluations, gathering requirements, analyzing data, data mapping, and report/database development is a plus
Experience with Guidewire's Policy Center and/or Billing Center is a plus
Skills & Abilities:
3+ years' experience with a relational database preferably with Financial / Mortgage business acumens.
3+ years' experience with data migration
Ability to write mid-level complexity SQL code
3+ years' experience working with SQL Server Management Studio
High level proficiency with Excel. Able to effectively use Excel functionality to reduce te time spent doing routing documentation work. Examples include, but not limited to, macros, lookup functions, pivot tables, etc.
Experience creating and maintaining business glossaries.
Clear and concise understanding of data movement (ETL), Business Intelligence and industry trends.
Must be a team player with effective interpersonal, written and verbal communication skills to clearly and professionally interact with internal and external parties.
Understanding of query driven applications and reporting, and logical and physical data models.
Ability to work independently or in a team environment
Strong creative thinking, problem solving and analytical skills.
High commitment to excellent service levels and satisfaction with partners.
Strong organizational skills with the ability to multi-task are necessary.
Detail-oriented outlook coupled with ability to manage time effectively, plan ahead and meet deadlines.
Good business writing and presentation skills.
For more information please contact Brian Otten at .

Since 1995, iTech Solutions Inc., has been providing IT Consulting and Direct Hire Services to the Insurance, Financial, Communications, Manufacturing and Government sectors with local offices in Connecticut, Minnesota, Colorado, Massachusetts, Tennessee, North Carolina, and New Jersey / Pennsylvania area.

Our recruiting strategy is simple, if you want to find qualified IT professionals then use IT professionals to find them. So at iTech Solutions, our personnel are all career IT professionals with a wide range of IT experience. We can honestly say our staff understands the technologies, the complexities of finding and selecting the appropriate personnel and the pressures of running successful IT projects.

Employer will not sponsor applicants for any employment visas, at hiring or in the future, including but not limited to H-1B visas. Corp-to-Corp or subcontract personnel will not be considered for this position.

Skills:
(DATA ANALYST OR DATA ANALYSIS ) AND(SQL ) AND (VLOOKUP OR PIVOT TABLE OR PIVOT TABLE OR PIVOT-TABLE OR MACROS OR V-LOOKUP OR MACRO OR LOOKUP OR LOOKUPS ) AND(EXCEL ) AND (INSURANCE OR COMMERCIAL LIN
Contract
5 months



See if you are a match!

See how well your resume matches up to this job - upload your resume now.

Find your dream job anywhere
with the LiveCareer app.
Download the
LiveCareer app and find
your dream job anywhere
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Data Analyst

University Of Pennsylvania

Posted 1 week ago

VIEW JOBS 11/5/2018 12:00:00 AM 2019-02-03T00:00 Adam Naj's Lab, part of the Penn Neurodegeneration Genomics Center (PNGC), is hiring a data analyst to participate in ongoing research on the genetics of Alzheimer's Disease and other neurodegenerative disorders. Duties include (1) processing, management, and analysis of data from genome-wide association and high-throughput whole-genome/whole-exome sequencing studies for Alzheimer's disease and other neurodegenerative disorders; (2) collecting and processing functional genomic annotation data for enhanced genetic association analyses; and (3) contributing to the development and testing of novel genomics research software and resources, developed here and elsewhere, for application to genomic studies of Alzheimer's and other neurodegenerative diseases. The lab benefits from close collaboration with talented programmers, analysts, and lab technologists, in the Schellenberg and Wang groups in the PNGC, and offers opportunities for career development and academic advancement at PSOM.This position in particular will require management, processing, and review of analyses performed on large scale whole genome sequencing projects Position is contingent on continued funding. BE-Epidemiology Division University Of Pennsylvania Philadelphia PA

Data Analyst

Itech Solutions