Big Data Modeler at Amex Systems

Title: Big Data Modeler

Location: Las Vegas, NV

Job Description:

5 + years of experience in Data Modeling & Data Analyst and should have excellent communication and

leadership skills. Financial Domain knowledge is plus.

• Should have strong understanding of cloud Datawarehouse like SnowFlake and Data modelling skill

using Data Vault 2.0 .

• Should have in depth understanding or executed new concepts like Data Lakehouse and should have

worked on Big Data data sources / tools such as Hive, S3, Trino, HUE, etc

• Should have done complex (100+ entities/tables) Data Modeling programs in both on-prem and cloud

environments .

• Experience in designing normalized, denormalized, relational, dimensional, star and snowflake

schemas for cloud, big data and on prem databases using any one of these data modeling tools (Erwin,

ER/Studio, Toad Data Modeler, etc)

• Extensive Data Modeling experience in same or similar bigdata and cloud databases such as Hive,

Redshift, Snowflake and on prem databases such as Oracle, SQL Server and DB2

• Should have experience in working with product managers, project managers, business users,

applications development team members, DBA teams and DataGovernance team on a daily basis to

analyze requirements, design, development and deployment technical solutions.

• Should have implemented Bill Inmon and Ralph Kimball methodologies to design data warehouses

• Should have in depth understanding on Data Warehousing, Data Analysis, Data Profiling, Master Data

Management (MDM), Data Quality, Data Lineage, DataDictionary, Data Mapping, Data Policy, and Data

Governance.

• Need to have at least 2 hours overlap with Pacific Timings to interact with Onsite team and to attend

daily standup meetings .

About Us:
Founded in 2005, Amex Systems Inc. has evolved into a pioneer in technology and process consulting, with a focus on delivering robust software development and affordable business solutions. Headquartered in Dallas, Texas, with additional operations in Detroit, Michigan, and nearshore centers in Canada and Mexico, Amex Systems stands as a leader in the IT industry.

AMEX SYSTEMS INC
38345 W 10 Mile Rd Suite 146 Farmington Hills, MI- 48335
https://amexsystems.com /