Job Description: Data Modeler Onsite
7 + years of experience in Data Modeling & Data Analysis and should have excellent communication and leadership skills. Financial Domain knowledge is plus.
Should have strong understanding of cloud Data warehouse 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 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 Data Governance team daily 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, Data Dictionary, Data Mapping, Data Policy, and Data Governance.
Compensation, Benefits and Duration
Minimum Compensation: USD 34,000
Maximum Compensation: USD 120,000
Compensation is based on actual experience and qualifications of the candidate. The above is a reasonable and a good faith estimate for the role.
Medical, vision, and dental benefits, 401k retirement plan, variable pay/incentives, paid time off, and paid holidays are available for full time employees.
This position is available for independent contractors
No applications will be considered if received more than 120 days after the date of this post
Photon Chicago, Illinois, USA Office
11 East Adams Street Suite 1100, Chicago, IL, United States, 60603
Similar Jobs
What you need to know about the Chicago Tech Scene
Key Facts About Chicago Tech
- Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
- Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
- Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
- Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory
