Data Modeler

2 weeks ago


Wilmington, Delaware, United States Spruce Infotech Full time
Company Description

Spruce InfoTech is the leading service provider in the fields of project management, architecture design, installation, implementation and administration of EPM and BI projects. Our team of experts provide with proven industry solutions that help our clients to have better understanding of the business and aides in decision making. We provide our clients with various services that help them to manage, control and transform their businesses by employing new age technology solutions that are cost effective and productive in nature. Our team members have huge experience in different types of enterprise solutions like that of Oracle Enterprise Performance Management (aka Hyperion), OBIEE and TIBCO.

Job Description

Title: Data Modeler (mid-level)

Location: Wilmington, DE

Duration: 1 year + 

Interview mode: phone then F2F  

Description: 

Required Skills:


• Minimum 3-5+ years' experience modeling complex databases using 3rd party modeling tools such as ERWin 9.2


• Experience designing and building large financial services data warehouses with very strong data analysis skills


• Have good knowledge of ER/Dimensional modeling and have extensive experience in developing logical and physical data models in complex, multi-application environments.


• years of hands-on experience in data management, data warehousing, data transformation, metadata and reference data management and business intelligence tools.


• years of experience with advanced SQL query techniques using TOAD, SQL Navigator. Basic UNIX would be a Plus.


• Previous experience as a hands-on Oracle DBA of large database is a plus.


• Must have good understanding of leading 3rd party products in the relevant areas (e.g. Datastage, Business Objects, Microstrategy).


• Significant experience with System Development Life Cycle (SDLC)

Responsibilities:


• Capture business requirements and rules, design the associated logical models, and create all required documentation to support, communicate, and validate the data model. 


• Design, build and maintain the logical and physical data models to support the business requirements in a dynamic, expanding business environment. 


• Map data elements of data sources into the domain data models. 


• Maintain documentation of data models, including relationships, constraints and metadata. 


• Publish and conduct model reviews with business and technical project teams. 


• Review database design changes with the team to determine the impact to the physical database and other systems. 


• Coordinate with development/implementation team to improve model formats and approaches with regard to implementation issues. 


• Participate in performance tuning activities including partitioning strategies, indexing strategies, and SQL optimization 


• Architect with an eye toward high performance, scalability, and high availability.

Qualifications

NEED TO BE LOCAL TO WILLINGTON,DELWARE(DE)

Additional Information

Title: Data Modeler (mid-level)

Location: Wilmington, DE

Duration: 1 year + 

Interview mode: phone then F2F  



  • Wilmington, Delaware, United States JPMorganChase Full time

    DescriptionBring your expertise to JPMorgan Chase. As part of Risk Management and Compliance, you are at the center of keeping JPMorgan Chase strong and resilient. You help the firm grow its business in a responsible way by anticipating new and emerging risks, and using your expert judgement to solve real-world challenges that impact our company, customers...

  • Data Architect

    6 days ago


    Wilmington, Delaware, United States Next Gen Software Solutions LLC Full time

    Title: Data ArchitectSnowflakeLocation: Wilmington, DE & Alpharetta, GA Onsite role (5day/week)Duration: Long termType: Contract W2Experience: 12+ yearsJob DescriptionKey Responsibilities:Data Architecture Design: Design, implement, and maintain enterprise-level data architectures to support business needs, with a focus on scalability, data governance, and...


  • Wilmington, Delaware, United States JPMorgan Chase Full time

    Are you passionate about leveraging artificial intelligence and machine learning solutions to solve real-world problems? As a Data Science Senior Associate, you'll develop scalable tools that integrate Large Language Models, predictive models and generative AI solutions with the Consumer and Community Bank Anti Money Laundering (AML) and Know Your Customer...


  • Wilmington, Delaware, United States JPMorgan Chase Full time

     As part of our team, you'll help modernize our data environment and unlock new opportunities for career growth and skill development.As a Domain Data Architect in the Finance Data Mart team, you will partner with Technology and Product teams to design and deliver data domains using Databricks. You will enable the Finance function to access and analyze...

  • Finance Data

    2 weeks ago


    Wilmington, Delaware, United States JPMorgan Chase Full time

    Join the Finance Data & Insights Team, to play a key role in driving the transformation in how we report and analyze financial information across Consumer and Community Banking.You are analytical, data-driven, and technical.   You have strong communication skills and are able to seamlessly interact with Finance, Technology and Operations professionals to...

  • Lead Data Engineer

    2 weeks ago


    Wilmington, Delaware, United States hackajob Full time

    hackajob*is collaborating withJ.P. Morgan*to connect them with exceptional tech professionals for this role.Base Pay/Salary: Wilmington, DE; Columbus, OH; Plano, TX; Jersey City,NJ $142,500.00-$185,000.00Job DescriptionJoin us as we embark on a journey of collaboration and innovation, where your unique skills and talents will be valued and celebrated....

  • Finance Data

    4 days ago


    Wilmington, Delaware, United States JPMorganChase Full time

    JOB DESCRIPTIONJoin the Finance Data & Insights Team, to play a key role in driving the transformation in how we report and analyze financial information across Consumer and Community Banking.You are analytical, data-driven, and technical. You have strong communication skills and are able to seamlessly interact with Finance, Technology and Operations...


  • Wilmington, Delaware, United States Capital One Full time

    Distinguished Data Engineer- Bank TechDistinguished Data Engineers are individual contributors who strive to be diverse in thought so we visualize the problem space. At Capital One, we believe diversity of thought strengthens our ability to influence, collaborate and provide the most innovative solutions across organizational boundaries. Distinguished...


  • Wilmington, Delaware, United States Capital One Full time

    Distinguished Data Engineers are individual contributors who strive to be diverse in thought so we visualize the problem space. At Capital One, we believe diversity of thought strengthens our ability to influence, collaborate and provide the most innovative solutions across organizational boundaries. Distinguished Engineers will significantly impact our...


  • Wilmington, Delaware, United States JPMorganChase Full time

    Job DescriptionAs a Computational Linguist in the Machine Learning & Optimization team, you are an integral part of the group that optimizes features, models, and AI capabilities for the Chase Digital Assistant (CDA) and other conversational AI products. You will act as the voice of the customer, developing a robust and scalable intent taxonomy to enhance...