Data Warehouse Modeler

4 weeks ago

New York, United States RIT Solutions, Inc. Full time
Job Description:
Primary Responsibilities:
  • Model documentation and recommendations
  • Communicate with key stakeholders to facilitate discussions about data modeling Develop DDLs for physical implementation and views Data mapping and data discovery Analyze source system data using profiling tools Translates and transforms business requirements into data models (conceptual, logical and physical) Track technical debt in the data design and recommend approaches to minimize and reduce technical debt Synchronize models with physical implementations Adhere to existing naming and design standards as well as recommend new standards Design data models in data modeling tools (e.g. ERWin) Produce data model documentation using leading modeling tools at various levels including story, subject area, and full data model Work Work proactively and independently to address project requirements and articulate issues/challenges to reduce project delivery risks Work with business and application/solution teams to implement data strategies, build data flows, and develop conceptual/logical/physical data models Lead and/or participate in data model reviews with various stakeholders Evaluates database and data and develops the data model appropriately
Requirements:
  • Minimum of 1 year experience in modeling in an analytical environment Minimum of 5 years of experience with Logical Design demonstrated with large scale, multiple business solutions across divisions or enterprise Minimum of 5 years prior experience as a data analyst and data modeler Document target state end-end data flows and representations Ability to create and maintain conceptual data models, high complexity logical and physical data models Experience with SQL Bachelor's degree in information science, computer science, engineering, or related discipline Experience in Agile Frameworks (SAFe) Experience with WrWin, Hackoldae, or ER/Studio Strong analytical skills Ability to translate business requirements to technical requirements Financial Services experience a plus Comfortable working in ambiguity Experience as Data Modeler on OLTP relational and data warehouse projects Understanding of emerging technologies, and their associated impact on enterprise environments

Call Notes:
  • Plan to standardize critical / high value data sets across the organization, a lot of remodeling of existing data sets, a lot of governance, standardizing key data sets to avoid duplicates.
  • Will help C1 in their journey to Machine Learning, standardized, will be given data to build a more robust Client to trust data and the results.
  • Already completed 2 data products, will develop more data products this year
  • 2 needs for data molders
  • Routine activities, understanding data, work with business / stakeholder / SME to understand the data, meaning of the data and transform into ,meaningful metadata, model the data structures, build / implement the model, optimize the data, a lot of collaboration with the enterprise to approve the data, influence the enterprise guidelines. New strategy that was launched last yr, a lot of strategies are still needing to be determined, data profiling, SQL, snowflake, postgres, DynamoDB, great communication skills, problem solving skills, familiar with the delivery of best practices, Agile,
  • Mid - Sr level role with 5 -10 yrs of experience
  • Top skills: SQL / Traditional / modern data warehouses - Snowflake / PostGres, AWS, able to understand what data means
  • Interview: hoping to knock it out in 1 round
  • They have a separate team who will handle the Data Architect piece
  • Data Model tools: C1 no longer users Erwin, open to open-source tools,

  • Data Warehouse Developer

    7 days ago

    New York, United States UrBench Full time

    Job DescriptionJob DescriptionData Warehouse Developer.DURATION: 6 monthsLOCATION: Hybrid, New York, NYCLIENT: NYS HCRRATE: $65DUE: MAY 29TH37.5 hour work weekINTERVIEW VIRTUALNO LAYERSVisa USC/GC/GC-EAD/H4-EAD The successful candidate will play a vital role in helping fulfill strategic, analytical and operational reporting requirements.The client is...

  • Data Modeler

    5 days ago

    New York, United States Coforge Full time

    We at Coforge are seeking Data Modeler with mentioned skill-set and who can work onsite from New York, NY location.Role: Data ModelerLocation: New York, NYExperience: 09+ yearsKey Skills: Data modelling, SQL, Oracle, Metadata management.Mode of Hire: Full TimeResponsibilities :-• Data analysis to understand the data and relationship in source systems •...

  • Data Warehouse Developer

    7 days ago

    New York, United States IT Allianz Inc Full time

    Job DescriptionJob DescriptionData Warehouse Developer, 8 + yearsExperience in the housing and financial sector, especially around accounting, bonds, mortgages, underwriting, loans origination and servicing; in addition to, experience around grants, tax credits, property/buildings asset management and compliance reporting.HybridDuration: 6 Months37.5hrs per...

  • Data Warehouse Engineer New York

    3 weeks ago

    New York, United States Reddit Full time

    **Data Warehouse Engineer** at Reddit New York Our mission is to bring community and belonging to everyone in the world. Reddit is a community of communities where people can dive into anything through experiences built around their interests, hobbies, and passions. With more than 50 million people visiting 100,000+ communities daily, it is home to the most...

  • Senior Software Engineer

    3 days ago

    New York, United States ListenFirst Full time

    **Senior Software Engineer - Data Warehouse (Open to Remote)** **Engineering | New York, NY | Full Time** Job Description **Senior software Engineer Data Warehouse** **ListenFirst Media** At ListenFirst, we make our clients smarter by providing an unparalleled picture of their brand, competitors, and overall market performance on Social Media. Our vision is...

  • Data Warehouse Developer

    4 weeks ago

    New York, United States Hire IT People Inc Full time

    Sr Enterprise Data Warehouse Developer Location NYC (hybrid role) Must-haves: Data Warehousing expert Sourcing data, transforming data, star schema, landing, dimensions, data governance, data quality, running cycles, computing storage Enterprise-scale experience Has built enterprise-scale data warehouse SQL, Sybase, or Oracle **Job Type**: Contract Pay:...

  • Data Warehouse Developer

    4 weeks ago

    New York, United States New York Technology Partners Full time

    **Job title**:Data Warehouse Developer **Location**: New York City, NY **Position**: Long term contract Note: Hybrid 2-3 days onsite in a week **Job description**: - Data Warehousing expert Sourcing data, transforming data, star schema, landing, dimensions, data governance, data quality, running cycles, computing storage - Enterprise-scale experience -...

  • Data Warehouse Developer

    2 weeks ago

    New York, United States FirstPRO Full time

    FirstPro is now accepting resumes for a Datawarehouse Developer position based in Woburn, MA. This role will focus on creating datawarehouse designs/structures, design, automate, schedule and load jobs, ETL processes, and visualizing data. This is a permanent, direct-hire role that can offer benefits and a hybrid remote/onsite schedule. This position is...

  • Data Architect

    2 weeks ago

    New York, United States The Astor Group Full time

    Our Firm is responding to the growing demand for alternative data by modernizing their process of building data pipelines. In doing so, we are looking for a senior data architect/engineer:The Senior Azure Data Architect/Engineer s main responsibilities will be:Designing and implementing high-volume data ingestion and transformation pipelines.Experience in...

  • Data Warehouse Architect

    2 weeks ago

    New York, United States TribolaTech Inc Full time

    Minimum Qualifications:15+ years of BI/DW and data architecture experience.10+ years’ experience in data warehousingExperience of Cloud implementations on AzureKnowledge of Data Warehousing, Analytics, ETL and BI architectures, concepts and frameworksCapable of facilitating data discovery sessions involving business subject matter experts.Ability to create...

  • Data Analyst

    1 month ago

    New York, United States Pinnacle Soft Solutions LLC., Full time

    Position Data AnalystLocation Princeton NJ(Remote)Interview Mode VideoType ContractVisa ALLProject Description 2 -3 years of Data & Analytics experience with a focus on data architecture and data modeling Be responsible for the development of the conceptual logical and physical data models - implementation of operational data store (ODS) data...

  • Data Analyst

    1 month ago

    New York, New York, United States Pinnacle Soft Solutions LLC., Full time

    Position Data AnalystLocation Princeton NJ(Remote)Interview Mode VideoType ContractVisa ALLProject Description 2 -3 years of Data & Analytics experience with a focus on data architecture and data modeling Be responsible for the development of the conceptual logical and physical data models - implementation of operational data store (ODS) data marts data...

  • Solutions Data Architect

    4 weeks ago

    New York, United States Pierce Technology Corp Full time

    Job DescriptionJob DescriptionSolutions/data architect who understands data, can create a data model and design a new solution for an enterprise data warehouse. Legacy system is limited in documentation, no real data model or map, and no user interface. Internal clients are looking for easier, better, and more efficient ways to access data. Looking for...

  • Solutions Data Architect

    1 month ago

    New York, United States Pierce Technology Corp Full time

    Job DescriptionJob DescriptionSolutions/data architect who understands data, can create a data model and design a new solution for an enterprise data warehouse. Legacy system is limited in documentation, no real data model or map, and no user interface. Internal clients are looking for easier, better, and more efficient ways to access data. Looking for...

  • ETL Developer

    3 weeks ago

    New York, United States Creative Data Resources Full time

    Onsite/remote schedule - 2 days/week onsite•Migrate existing SSIS ETL scripts to Python; develop new ETL scripts •Support existing SSIS SQL Projects •Maintain ETL pipelines in and out of data warehouse using combination of Python and Snowflakes SnowSQL •Write SQL queries against Snowflake. •Understanding data pipelines and modern ways of automating...

  • Senior Data Modeler

    2 weeks ago

    New York, United States Orgspire Full time

    Job DescriptionJob DescriptionSenior Data ModelerLocation: NYC, NY or Brighton, MA (100% Onsite)Duration: 6-12 MonthsDescription: 12+ years of experience in data modelingInsurance background requiredInvestment background a plus Strong SQL experience and able to do analysis on the data.Strong communication and Authoritative skills is must to work with the...

  • Oracle Fusion HCM Analytics Warehouse Consultant

    2 weeks ago

    New York, United States Capgemini America, Inc. Full time

    As a Senior Oracle Fusion Analytics Warehouse Consultant, you will be responsible for leading and overseeing the implementation, customization, and optimization of Oracle Fusion Analytics Warehouse solutions for our clients. Your expertise in Oracle Fusion Analytics Warehouse will be critical in providing strategic guidance, designing solutions, and...

  • ETL Developer

    2 weeks ago

    New York, United States Creative Data Resources Full time

    Onsite/remote schedule - 2 days/week onsite •Migrate existing SSIS ETL scripts to Python; develop new ETL scripts •Support existing SSIS SQL Projects •Maintain ETL pipelines in and out of data warehouse using combination of Python and Snowflakes SnowSQL •Write SQL queries against Snowflake. •Understanding data pipelines and modern ways of...

  • Data Modeler

    1 month ago

    New Brunswick, United States Inizio Partners Corp Full time

    Job DescriptionJob DescriptionWe are seeking a skilled Data Modeler and Architect to join our team, dedicated to optimizing the data architecture for our esteemed pharmaceutical client. This role is ideal for someone who thrives in understanding complex data environments and is adept at designing data models that empower analytical and operational...

  • Manager, Data Modeling and Analysis

    5 days ago

    New York, NY, United States Bank of America Full time

    At Bank of America, we are guided by a common purpose to help make financial lives better through the power of every connection. Responsible Growth is how we run our company and how we deliver for our clients, teammates, communities, and shareholders every day. We hire individuals with a broad range of backgrounds and experiences and invest heavily in our...