The Senior Data Modeler will design and develop data products, create data models, ensure alignment of physical and logical data models, and support data catalog setup.
THE ROLE
We are seeking an experienced Senior Data Modeler to join our newly created Service Consultant Sub-Practice and exclusively work with a mature and impactful long-term client in the financial services industry. This role requires a balance of independent work and teamwork, focusing on advancing the client's agenda. The ideal candidate will possess some understanding of the financial services sector, coupled with a proven track record of independent work and team collaboration. Join us to make a meaningful impact and contribute within our innovative team.
What you’ll do:
- Apply ER Studio and Data Modeling expertise to a Data Engineering team dedicated to the design and development, and delivery of Data products leveraging Databricks on AWS
- Work with Business Architects, Solution Architects, and Data Stewards to capture business requirements in a Conceptual and Logical Data Model.
- Contribute to ongoing updates to data modeling standards and guidelines
- Evaluate physical data models to ensure they align with the corresponding logical data models.
- Create notebooks in Databricks in support of development activities (using Spark SQL, PySpark)
- Support enterprise data catalog setup and enrichment
Requirements:
- Data management background with hands-on work experience in supporting teams that are building and testing data pipelines
- 4+ years of hands-on data modeling experience with ER Studio.
- Hands-on strong Data modeling (Conceptual, Logical, Physical, 3nF, Dimensional) at both enterprise and data product level.
- Strong SQL skills
- Good Databricks skills and understanding of Medallion Architecture
- Working knowledge of Unity Catalog
- Experience in the financial sector with Market securities reference data and fixed income such as Treasuries.
- Working knowledge of traditional DBMS platforms like Oracle and Cloud DBMS like Redshift and Databricks.
- Strong verbal, presentation, and written communication skills
The base salary range is - $165,000-$185,000
Placement within the range provided above is based on the individual’s relevant experience and skills for the role and level.
Base salary is only one component of our total compensation package. Employees may be eligible for a discretionary bonus, which is determined upon company and individual performance.
Salary range disclosure as required by S9427A when hiring in New York.
Lab49 is a specialist strategy, design, and technology consulting company dedicated to the financial services industry. We were founded in 2002 to fill a need in the Financial Technology marketplace for high-end execution and reliable delivery of technology projects.
We have office hubs in Midtown Manhattan, Washington DC, London, Budapest, New Delhi and Sydney.
Lab49/ION is committed to maintaining a supportive and inclusive environment for people with diverse backgrounds and experiences. We respect the varied identities, abilities, cultures, and traditions of the individuals who comprise our organization and recognize the value that different backgrounds and points of view bring to our business.
Lab49/ION adheres to an equal employment opportunity policy that prohibits discriminatory practices or harassment against applicants or employees based on any legally impermissible factor.
Top Skills
AWS
Databricks
Er Studio
Oracle
Pyspark
Redshift
Spark Sql
SQL
Similar Jobs
Cloud • Information Technology • Machine Learning
The Systems Engineer will lead HR systems integrations during M&A, focusing on Workday data migrations, configuration, and compliance during transitions.
Top Skills:
EibsRestSoap ApisWorkday HcmWorkday Web Services
Cloud • Information Technology • Machine Learning
The Senior Engineer, TA Systems role at CoreWeave involves configuring and optimizing Talent Acquisition systems, particularly Greenhouse, alongside integration with Workday, while collaborating with HR and external vendors to enhance the recruiting process.
Top Skills:
GreenhouseWorkday
Cloud • Information Technology • Machine Learning
The Executive Assistant supports the VP of People, managing calendars, organizing meetings, handling communications, and ensuring sensitive information is handled with discretion.
Top Skills:
AIConfluenceGoogle WorkspaceSlack
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
