Data Analyst

Itech Solutions Philadelphia , PA 19103

Posted 4 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



upload resume icon
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.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon
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

Athena Global Advisors

Posted Yesterday

VIEW JOBS 1/17/2019 12:00:00 AM 2019-04-17T00:00 <p>Do you enjoy working with a top-notch team and being part of a growing, passionate, and forward-thinking company? Athena is becoming the best and most intensive high-touch consulting group in the country. Our exceptionally high standards and whole-brain, full spectrum approach has earned us an enviable reputation across multiple industries and fueled our impressive growth. Athena brings an artful mix of creativity and facts-based insight to make even complex matters engaging, memorable, and impactful.</p> <p><br></p><p>Athena is looking for a talented data analyst with a minimum of 1-2 years of experience who seeks an opportunity to add value by analyzing and reporting on metrics from a variety of data sources, enhancing data sets and creating and maintaining new datasets for clients. A key component of the job will focus on expanding our work around social media tracking and reporting. Opportunities to work with clients in a variety of sectors will arise.</p> <p></p> <p></p><p><strong>What you’ll be responsible for:</strong></p> <ul> <li>Interpret data, determine trends and come to new conclusions based on the findings</li> <li>Work with large amounts of data, facts, and figures</li> <li>Combine disparate data sets and provide meaningful reports</li> <li>Conduct research and integrate findings into databases and reporting</li> <li>Present findings and translate the data into an understandable document, easily communicating complex ideas</li> <li>Conduct all activities, including producing final presentations, with a high attention to detail</li> <li>Meet right deadlines in a fast-paced environment</li> <li>Multi-task on projects and initiatives</li> <li>Develop systems and identify tools to assist with ongoing initiatives (Google alerts, etc.)</li> <li>Contribute to reaching organizational goals by being flexible and working in a team environment</li> </ul><p><strong>Requirements</strong></p><p><strong>Skills and experience you should have:</strong></p> <ul> <li>Knowledge of relational database principles</li> <li>Strong analytical and problem-solving skills</li> <li>Ability to communicate clearly </li> <li>Highly organized and strong attention to detail</li> <li>Expert in Microsoft Excel and Access</li> <li>Working knowledge of SQL</li> <li>Tableau or other data visualization knowledge (preferred)</li> <li>Experience with social media monitoring and metrics (preferred)</li> </ul> <ul> <li>Bachelor's degree in a quantitative field such as information systems, computer science, or a directly related field</li> <li>1-2 years of professional experience as a data analyst (internship or co-op experience considered)</li> </ul> <p><br></p><p>You must also be willing to travel.</p><p><strong>Benefits</strong></p><ul> <li>Medical/Dental benefits including 1K Health Reimbursement Account</li> <li>Matching 401K</li> <li>Summer Friday remote work option</li> <li>Free snacks and wine socials</li> </ul> <p><br></p><p>Curious about your career path at Athena? This role is at the Analyst Level within Athena’s career-path structure for the Delivery Team. This team has the following levels of progression for growth and development.</p> <p></p><p><strong>Analyst </strong>--&gt; Sr. Analyst --&gt; Manager --&gt; Sr. Manager --&gt; Director --&gt; Sr. Director --&gt; Managing Director</p> <p><br></p><p>Oh, and our application process is open, easy, as transparent as we can make it, and painless. We need team members like you to join us. Ready to apply? <strong>Let’s get started.</strong></p> <p></p><p><br></p><p>Athena is an equal opportunity/affirmative action employer committed to a diverse and inclusive workplace. All qualified applicants will receive consideration for employment without regards to race, color, religion, sex, sexual orientation, gender identity, national origin, disability status, protected veteran status or any other basis prohibited by law. If you are an individual with a disability and need assistance in applying for a position, please contact us at 866.299.6040.</p> Athena Global Advisors Philadelphia PA

Data Analyst

Itech Solutions