Data Warehouse Developer

2 weeks ago

New York, New York, United States Mindlance Full time
Jo b Su mm ry:

The Developer must have extensive experience in software analysis, design, development, implementation and maintenance of Data Warehouse/Data Marts. T h e Developer w ill w o rk cl o s ely wi t h proje c t m a n a g ers, I T s t af f , p r o g ram s t aff a n d o t h er s t akeh o l d e rs t o defi n e n d d e v e l o p r eq u ire m ents f o r the enterprise data warehouse . The Developer w ill pp ly ra ng e o f specia l i z ed s kills n d t o o ls t o c o m p le t e the f o ll o wing specific d u ties n d r e sponsi b iliti e s:

The Developer will u se t h eir e x t en si v e kn o w l ed g e o f b u si n ess n alysis b est pract i ces to facilit a te r eq u ire m ents s ess i o n s and c o m m un ica t e c l early and e f f ec t i v ely w ith en d - u sers, a pp licati o n s d e v e l o p er s , s en i o r b u si n ess m a n a g e r s a n d o t h er t e a m m e m b ers. T h e Developer w ill be c c o un tab l e f o r p r ov i d i n g c oo r d i n at i o n t o e n su r e the ap p r o p ri a te c o ll e cti o n o f da t a; d o c u m entat i o n o f in f o r m at i o n ; and p res e n tat i o n o f fi nd i ng s. T h e Developer w ill p r ov i d e do cu m entat i o n and fl o w -ch a rts o f t h e o r g a n i z ati o n 's w o rkflow, as w e ll as ad- h o c qu e ry su p p o rt n d r e p o rt c r ea t i o n .

The Developer m u st h v e s t r o n g t ech n ical k n o wled g e n d u nd ers t a nd i n g o f I T s y st e m s n d ap p licati o n s as w ell as t h e a b ility t o pl a n and t r ack b u si n ess n al y ses cti v i ties as part o f p r o je c t. The Developer lso m u st h v e g o o d lis t en in g skills n d i n t e r v i e wing s k ills t o talk with i nd ivid u als and gr o up s abo u t t h eir ne e d s and ask t h e ri gh t qu e s ti o n s t o su r face e ssential r e qu ir e m ents i n f o r m ti o n . The i d eal ca nd i d ate will l s o p o s sess g oo d w riti n g s kills t o ens u re effec t i v e c om m un ica t ion o f i n f o r m ti o n to c u s t o m ers, m ar k e t i ng , m a n a g ers, and t e ch n ical s taff.

The Developer will report directly to the CIO, and indirectly to the VP / Application Development

Manager, and will play a vital role in helping client fulfil its strategic, analytical and operational reporting requirements. The ideal candidate will demonstrate critical thinking skills when solving problems and making recommendations for new solutions.

Responsibilities Include (but not limited to):

• Extensive experience in architecting and designing solutions at Enterprise scale in Enterprise Data warehouse applications.

• Experience in developing Data Warehouse/Data Marts using, as examples, OBIEE, OBI APPS, Cognos, Business Objects, SPSS, SSIS, SSRS, Informatica Power Center, OWB and ODI.

• Experience on design and development of Data Warehouse Architecture for Enterprise Data Warehouse (EDW), Operational data Store (ODS), Operational Data Marts and Data Marts.

• Experience in defining metadata standards for the enterprise data warehouse.

• Experience in design and development of:
  • ETL processes using Dimensional Modeling for ROLAP and MOLAP.
o ETL technical architecture.

o BI load dependency plan, job scheduling and cycle management.

• Experience in developing end-to-end Data warehouse ETL routines.

• Experience in using SQL in advanced analytical functions.

• Experience in writing complex PL/SQL packages stored Procedures, functions, cursors, triggers, views, and materialized views.

• Experience in creation of enterprise data Warehouse Test plan, Test script creation and Test Script Execution for different test environments such as System, Integration and User Acceptance.

• Experience developing optimal approach for obtaining data from diverse source system platforms and moving it to the Enterprise Data Warehouse.

• Experience in Logical and Physical data Models for enterprise data warehouse and applications.

• Experience developing and configuring Interactive Dashboards with drill-down capabilities, links/images, HTML objects and folders.

• Proficient in using the time-series functions to support historical time comparison analysis.

• Experience with Calculated Measures and assigned Aggregation levels based on Dimension Hierarchies.

Qualifications:

• Client h el o r ' s deg r e e; M B o r rele v a n t t ech n ical deg r e e p referred.

• str o n g b ackg r o un d in technology , n alysis n d cr i tically e v al u ati n g i n f o r m at i o n g athe r e d fr o m m u lti p le s o u r c es.

• E x p erien c e d eco m p o si n g h i g h -le v el i n f o r m at i o n i n t o d e tails, d isti ngu is h i n g u ser req u e sts fr o m t h e und erlying t r u e n e eds, and d e v e l o p i n g s o l u t i o n ide a s f r o m r e qu ir e m e n t s .

• Strong experience writing business requirements documentation (BRDs) and functional requirements documentation (FRDs).

• P r o v en e x p er i ence succe s s f u lly w o rki n g in t e m s e t t i n g and ab i lity t o r ec o n ci l e c o n fl i cts.

• M i n i m u m seven 7-10 y e a rs of ex p erience in r ela t ed p r o f ess i o n al bu si n es s / p r o j ect n al y st ca p aci t y.

• Ex c elle n t o ral and w r i t t en c o m m un icat i o n s kills.

• Experience in the housing and financial sector is preferred and a major plus, 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.

• Excellent e x p er i ence with M S Off i c e 2013/2016 and above as well as design tools and flowcharting tools, e.g. Visio.

This j o b descri p t i o n is n o t i n t e nd ed to be all inc lu s i v e, n d em p l o y e e will l so p e r f o rm r ea s o n a b le r e la t ed b u si n ess du ties as a s si gn ed.

  • Data Warehouse Developer

    2 weeks ago

    New York, 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 Warehouse Developer

    2 weeks ago

    New York, New York, United States Experis Full time

    Our Financial domain client is seeking aGCP Data Engineerto join their team. As aGCP Data Engineer , you will be part of the clientsupporting Team. The ideal candidate will have Google BigQuery ,Python and SQLwhich will align successfully in the organization.Job Title: GCP Data EngineerLocation: Remote or Local to Denver, COPay Range: $50-55/hr.Valid...

  • Data Analyst, Data Product Development

    2 weeks ago

    New York, New York, United States Hearst Media Services Full time

    Key Responsibilities Use various advanced tools and analytical practices to present detailed pictures of overall performance and user engagement across all touchpoints, empowering stakeholders to make informed decisions. Analyze and interpret large datasets through the extraction of relevant data including data integrations with internal systems and 3rd...

  • Data Warehouse Architect

    2 weeks ago

    New York, New York, United States StateJobsNY Full time

    Requisitos de Educación: Titulación universitaria en una disciplina relacionada con TI con un mínimo de 3 años de experiencia en el campo relacionado; O un título de 2 años con un mínimo de 5 años de experiencia; O, cualquier combinación equivalente de experiencia y / o educación que haya alcanzado conocimientos, habilidades y habilidades...

  • Big Data developer

    2 months ago

    New York, New York, United States Cygnus Professionals Inc. Full time

    Job Description Strong knowledge in Scala Spark implementation and preferably in Kafka as well Strong Scripting / programming experience in Spark Scala and Java Experience in cleansing and preparing large complex datasets Extensive experience in RDBMS SQL Experience with bash shell scripts Unix commands and utilities Distributed processing parallel...

  • Data Analyst, Data Product Development

    2 weeks ago

    New York, New York, United States Hearst Full time

    Job Description The Enterprise Data Team is looking for a Data Analyst, Data Product Development who will be a critical part of our data-driven decision-making process. The role will work to extract actionable insights from various sets of first party consumer data and content-related datasets to drive informed decision-making. Reporting to the SVP of Data...

  • kdb+ Developer

    6 days ago

    New York, New York, United States Data Intellect Full time

    Company DescriptionEvery question matters, every pathway, direction, thought process and conversation. Because every challenge makes us stronger, more knowledgeable, more determined and more valuable to our clients.We're not big on egos and we're not for the faint hearted. We stand for camaraderie, collaboration and change.Welcome to Data Intellect.Challenge...

  • Data Engineer

    2 weeks ago

    New York, New York, United States Action Tech Full time

    This is a full time, direct hire position that requires 3 to 4 days a week onsite in NYCAll applicants must be local to the NY, NJ, CT areaWe are looking for an outstanding Data Engineer to join our New York-based team who can help build the infrastructure to make data a central part of the company. Data driven decisions are very critical, as a result, we...

  • Mendix Developer

    6 hours ago

    New York, New York, United States NTT DATA Services Full time

    Req ID: NTT DATA Services strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now.We are currently seeking a Mendix Developer - New York, New York to join our team in new york, New York (US-NY), United States (US). NTT 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...

  • azure data engineer

    2 months ago

    New York, New York, United States Atechstar Full time

    Job Description Roles and ResponsibilitiesExperience in Perform Design Development & Deployment using Azure Services (Data Factory Databricks PySpark SQL) Develop and maintain scalable data pipelines and build out new Data Source integrations to support continuing increases in data volume and complexity. Experience in create the Technical Specification...

  • azure data engineer

    3 months ago

    New York, New York, United States Atechstar Full time

    Job DescriptionRoles and ResponsibilitiesExperience in Perform Design Development & Deployment using Azure Services (Data Factory Databricks PySpark SQL) Develop and maintain scalable data pipelines and build out new Data Source integrations to support continuing increases in data volume and complexity. Experience in create the Technical Specification Design...

  • Senior Data Engineer

    4 days ago

    New York, New York, United States Tickets Full time

    , an MLB company, delivers innovative, cutting-edge technologies to enable frictionless and unforgettable fan experiences in venues across the globe. Together with MLB, is changing the landscape of the live sports and entertainment industry, delivering new digital venue and ticketing experiences to millions of fans. Our Technology team builds platforms and...

  • Data Engineer

    1 month ago

    New York, New York, United States Masterworks Full time

    Masterworks Overview:Masterworks is the only platform for investing in blue-chip, multi-million dollar artworks. Prior to Masterworks, the only way to allocate to art was to purchase a multi-million dollar painting, making the asset class inaccessible for most investors. The company has over 900,000 users signed-up purchasing shares in primary offerings...

  • Business Info Developer

    2 weeks ago

    New York, New York, United States Elevance Health Full time

    Position Title: Business Information Developer – SAS / SQLCompany: Elevance HealthJob Description: The Business Information Developer – SAS / SQL is responsible for developing and executing more complex data mining analyses. How you will make an impact: Determines how decision support systems will provide the data required to make effective business...

  • Azure Data Engineer

    1 month ago

    New York, New York, United States Atechstar Full time

    Job descriptionAzure Data Factory Databricks ADLS Azure SQL IoT hub Stream analytics SQL NoSQL Spark Kafka Power BI Python/R Azure Synapse Power BI Should have around 5.5-8 yrs. of experience in Microsoft technologies Demonstrated experience in end-to-end deployment of MS Azure BI solution Hands on experience in developing solutions using Azure data factory...

  • Senior Data Analyst

    2 weeks ago

    New York, New York, United States WW International, Inc. Full time

    WW is looking for candidates to help change people's lives. We are a global wellness technology company inspiring millions of people to adopt healthy habits for real life. We do this through engaging digital experiences, face-to-face workshops and sustainable programs that encourage people to move more, shift their mindset and eat healthier while enjoying...

  • Salesforce data engineer

    2 weeks ago

    New York, New York, United States VSG Business Solutions LLC Full time

    Job DescriptionJob DescriptionWe need A senior (8+ years) Salesforce data engineer with experience with OLAP, Apex, AWS and SalesForce. They will Develop and automate large scale, high-performance data platform infrastructure to drive business growth and enable data-driven organization. No Relocation ( Need local candidates in the NY/NJ area. ) Interview...

  • Data Scientist, TIDAL

    1 month ago

    New York, New York, United States Block Full time

    Company DescriptionTIDAL was founded for artists by artists as the next innovative streaming platform to bring value back to the music industry. We empower artists with the products, resources, services, and content required to take control of their careers and connect more deeply with fans. Available in over 60+ countries, TIDAL continues to help artists...

  • Data Engineer, Consultant

    2 weeks ago

    New York, New York, United States MigrationIT Full time

    Requirements 3-6 years of experience in data engineeringGather requirements from stakeholders and translate them into technical specifications.Design and implement data pipelines to collect, transform, and load data into data warehouses and data lakes.Maintain and optimize data systems to ensure high availability and performance.Work with other engineering...