Data Modeler

Atria Group LLC; Buffalo (NY); On-site; USD 70,000 - 100,000; Full time

Job summary

A leading company in IT services seeks a skilled individual for data analysis and modeling. The role involves engaging with stakeholders, preparing data models, and utilizing tools like ER Studio or Erwin. Candidates should have strong analytical skills and a proficient understanding of SQL for data profiling.

Qualifications

• Experience in requirement analysis and OLTP/OLAP data modeling.
• Hands-on experience with ER Studio or Erwin is preferred.
• Knowledge of data analysis and SQL data profiling.

Responsibilities

• Perform requirement analysis and stakeholder discussions.
• Prepare conceptual, logical, and physical data models.
• Review models with enterprise architects.

Skills

Requirement analysis skills

Data modeling skills

Data analysis

Data profiling using SQL

Tools

ER Studio

Erwin

Job 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

• Requirement analysis skills
• Discussion with solution architects, business SMEs, onsite coordinators, and other stakeholders
• Preparing conceptual, logical, and physical data models
• OLTP and OLAP data modeling skills
• Hands-on experience with ER Studio / Erwin
• Reviewing with enterprise architects
• Knowledge of data analysis and data profiling using SQL