Sorry, this job is no longer accepting applications. See below for more jobs that match what you’re looking for!

Data Modeler

Expired Job

Turnberry Solutions Philadelphia , PA 19103

Posted 2 months ago

Sr. Data Modeler in Philadelphia, PA 19103

Interview Logistics:

Phone Interview then Face to Face

Required Skills Set:

Years of Experience: 5+ years of experience with advanced SQL query techniques, 5+ years of proven experience in Data Modeling

Education Required: Bachelors Degree

Highly skilled in ERwin, including but not limited to: Diagraming, Complete Compare, Reverse Engineering, Forward Engineering

Demonstrated ability to recognize, elicit and/or decompose complex business requirements. A solid understanding of the following is required:

Software Development Life Cycle (SDLC)

Agile Methodology

Logical and Physical data modeling

Levels of Normalization

Abstraction and Generalization

Subtyping and Classification

Relational model design

Dimensional model design (Star Schemas, Snowflake designs)

Inmon & Kimball methodologies

Master Data Management (MDM)

Data Profiling

Metadata Management

Data security and protecting information

ETL processes, BI processes

Additional Preferred Skills:

Demonstrated ability to perceive patterns and relationships in data

Demonstrated ability to design models which integrate data from disparate sources

Demonstrated ability to design data models for complex and ragged hierarchies

Demonstrated ability to design data models for complicated historical perspectives

Understanding of data warehousing and decision support tools and techniques

Strong ability to multi-task with several concurrent issues and projects

Project Description:

The Senior Data Modeler is responsible for developing advanced Erwin data models associated with the Active Enterprise Data Warehouse (AEDW), IBC operational systems and IBC data exchange, with limited management oversight. Primary job function entails gathering and assessing business and technical requirements to create/update database objects.

Delivery items include Erwin data model diagrams, DDL, and supporting documentation as needed. Additional job functions include identifying solution design options, advanced data profiling and providing subject matter expertise.

This role works closely with all development resources including Business Systems Analysts, Developers and Project Managers. The Senior Data Modeler works independently with minimal guidance and acts as a resource for colleagues with less experience.
Physical Environment and Working Conditions:

Must be able to work on a team.

(DATA MODELLING over 5 year(s) ) AND (SQL ) AND (SDLC ) AND (AGILE )
11+ mos

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

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
Sr Associate Data Modeler Financial Services


Posted Yesterday

VIEW JOBS 11/20/2018 12:00:00 AM 2019-02-18T00:00 Innovate. Collaborate. Shine. Lighthouse – KPMG's Center of Excellence for Advanced Analytics – has both applied data science, AI, and big data architecture capabilities. Here, you'll work with a diverse team of sophisticated data and analytics professionals to explore the solutions for clients in a platform-diverse environment. This means your ability to find answers is limited only by your creativity in leveraging a vast array of techniques and tools. Be a part of a high-energy, diverse, fast-paced, and innovative culture that delivers with the agility of a tech startup and the backing of a leading global consulting firm. For you, that translates into the chance to work on a wide range of projects – covering technologies and solutions from AI to optimization – and the power to have a real impact in the business world. So, bring your creativity and pioneering spirit to KPMG Lighthouse. KPMG is currently seeking a Sr. Associate, Data Modeler to join our KPMG Lighthouse - Center of Excellence for Advanced Analytics to work with our Financial Services team. Responsibilities: * Work in multi-disciplinary and cross-functional teams to translate business objectives into artificial intelligence approaches and objectives; strong aptitude for quickly learning business operational, process, delivery, and revenue models * Work in a fast-paced and dynamic environment with both virtual and face-to-face interactions; utilize structured approaches to solving problems, managing risks, and documenting assumptions; communicate results and educate others through insightful visualizations, reports, and presentations * Assess, capture, and translate issues and requirements into structured analytics use case, including rapid learning of industry/domain/client dynamics and development of effective work stream plans * Build ingestion processes to prepare, extract, and enrich a variety of structured and unstructured data sources (social media, news, internal/external documents, images, video, voice, emails, financial data, and operational data) * Utilize a hypothesis-driven, problem-solving approach to design, construct, and rapidly test/iterate exploratory models that will reveal insight and opportunities for the client; proactively broaden and deepen client relationships by working with varying levels of client team members * Deliver on engagement milestones by following analytics processes to mitigate risks in data, modeling, validation, and delivery; manage assumptions, and risks, and work with others to clear issues Qualifications: * Minimum of three years of work experience involving: modeling (regression, machine learning, feature selection, dimension reduction, validation); data (extracting, preparing, munging, validating); building analytics pipelines; analytics and data science landscape; minimum of one year of training specific to artificial intelligence, and two plus years of experience leading work streams with two plus data scientists, engineers, and other data & analytics professionals * Bachelor's or Master's degree from an accredited college/university in an applied quantitative discipline, such as Data Science, Analytics, Computer Science, Engineering, or Mathematics * Strong knowledge in design and building of machine learning pipelines, including data extraction, feature engineering from structured and unstructured data; the entire software development lifecycle; and software development methodologies (frameworks, tools and technical architecture) * Ability to apply artificial intelligence techniques to achieve concrete business goals; work with the business to understand available resources and constraints around data (sources, integrity, and definitions), processing platforms, and security * Proficiency with sophisticated analytics tools and programming languages (SAS, R, Python, Java, Spark, Hadoop, Alteryx, SQL); data visualization tools (Tableau, QlikView, and others) * Ability to travel up to eighty percent of the time; Applicants must be currently authorized to work in the United States without the need for visa sponsorship now or in the future KPMG LLP (the U.S. member firm of KPMG International) offers a comprehensive compensation and benefits package. KPMG is an affirmative action-equal opportunity employer. KPMG complies with all applicable federal, state and local laws regarding recruitment and hiring. All qualified applicants are considered for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, protected veteran status, or any other category protected by applicable federal, state or local laws. The attached link contains further information regarding the firm's compliance with federal, state and local recruitment and hiring laws. No phone calls or agencies please. Kpmg Philadelphia PA

Data Modeler

Expired Job

Turnberry Solutions