Atria Group LLC Logo

Atria Group LLC

Data Modeler

Reposted 21 Days Ago
Be an Early Applicant
In-Office
Buffalo, NY
Mid level
In-Office
Buffalo, NY
Mid level
Perform requirement analysis and collaborate with solution architects, business SMEs, and stakeholders to create conceptual, logical, and physical data models for OLTP and OLAP systems. Use ER Studio/Erwin and Teradata, perform data analysis and profiling with SQL, and review models with enterprise architects. Strong communication skills required. 9+ month engagement.
The summary above was generated by AI
Company Description

We specialize in Staffing, Consulting, Software Development, and Training along with IT services to small to medium size companies. AG's primary objective is to help companies maximize their IT resources and meet the ever-changing IT needs and challenges.

In addition, AG offers enterprise resource planning and enterprise application integration, supply-chain management, e-commerce solutions, and B2B public exchanges and B2B process integration solutions. Our company provides application analysis, design, development and programming, software engineering, systems development, testing, integration, and implementation, and management consulting services to various clients – including governmental agencies and private companies – throughout the United States and India.

We provide these services in multiple computing environments and use technologies such as client/server architecture, object-oriented programming languages and tools, distributed database management systems, state-of-the-art networking, and communications infrastructures. Our honest and realistic approach to recruiting dictates that AG does not entice or lure engineers from their employers. We represent only high caliber technical professionals who have committed to making a change required by career.

Job Description

Data Modeler JD:

  • Requirement analysis skill
  • Discussion with solution architects and business SME and onsite coordinator and other stakeholders
  • Preparing conceptual, logical, Physical data model
  • OLTP and OLAP data modeling skills
  • Hands on experience in ER Studio / Erwin
  • Reviewing with enterprise architects
  • Knowledge on Data analysis, Data profiling using SQL's
  • Hands on experience in Teradata

Additional Information

GOOD COMMUNICATION SKILLS

DURATION: 9+ months

Similar Jobs

7 Days Ago
Hybrid
New York City, NY, USA
110K-170K Annually
Senior level
110K-170K Annually
Senior level
Artificial Intelligence • Big Data • Healthtech • Machine Learning • Analytics • Biotech • Generative AI
Lead enterprise healthcare data modeling: design and maintain conceptual/logical/physical models, integrate varied clinical sources, implement common data model transformations, monitor data quality, and collaborate with clinicians, data scientists, and engineers.
Top Skills: BigQueryDbtEltEpicErwinETLGCPHl7LucidchartMppNoSQLPythonSQLVertabelo
19 Days Ago
In-Office
New York, NY, USA
Expert/Leader
Expert/Leader
Information Technology • Professional Services • Software • Consulting
Designs and maintains logical and physical data models for OLTP and data warehouse environments. Leads stakeholder requirements, develops dimensional and relational schemas (star/snowflake), implements SCD Type I/II, creates ETL mappings, documents metadata, and works with SSIS/Informatica, Erwin/ERStudio, SQL Server, and BI tools (SAP BusinessObjects).
Top Skills: Er StudioErwinETLInformatica 7.1.3MS OfficeMicrosoft ProjectMicrosoft Sql ServerMicrosoft SsisOlapOltpSalesforce Service CloudSap BusinessobjectsScd Type IScd Type IiSnowflake SchemaStar SchemaUnixWindows
19 Days Ago
In-Office
New York, NY, USA
Senior level
Senior level
Professional Services • Consulting • Industrial
Lead ER/Studio data architecture and modeling efforts: build/maintain macros, standardize domains and metadata, synchronize models with physical databases, enforce naming/versioning standards, document and support modelers and DB engineering for BI and data integration.
Top Skills: Data ModelingData Warehouse ArchitectureDimensional ModelingEmbarcadero Er/StudioEmbarcadero SuiteEntity Relationship ModelingEr Studio Macro ScriptingEr/Studio Data Architect (V9.0+)MetadataUnixWindows Server

What you need to know about the NYC Tech Scene

As the undisputed financial capital of the world, New York City is an epicenter of startup funding activity. The city has a thriving fintech scene and is a major player in verticals ranging from AI to biotech, cybersecurity and digital media. It also has universities like NYU, Columbia and Cornell Tech attracting students and researchers from across the globe, providing the ecosystem with a constant influx of world-class talent. And its East Coast location and three international airports make it a perfect spot for European companies establishing a foothold in the United States.

Key Facts About NYC Tech

  • Number of Tech Workers: 549,200; 6% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: Capgemini, Bloomberg, IBM, Spotify
  • Key Industries: Artificial intelligence, Fintech
  • Funding Landscape: $25.5 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Greycroft, Thrive Capital, Union Square Ventures, FirstMark Capital, Tiger Global Management, Tribeca Venture Partners, Insight Partners, Two Sigma Ventures
  • Research Centers and Universities: Columbia University, New York University, Fordham University, CUNY, AI Now Institute, Flatiron Institute, C.N. Yang Institute for Theoretical Physics, NASA Space Radiation Laboratory

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account