Ampcus Inc · 5 months ago
Senior Data Modeler
Washington, DC
Full-time
Onsite
Senior Level, Lead/Staff
$70/hr - $90/hr
10+ years expAmpcus Inc. is a certified global provider of a broad range of Technology and Business consulting services. They are in search of a highly motivated Senior Data Modeler to leverage financial industry expertise in defining data models and working with various stakeholders to optimize data for performance and cost. The role involves creating documentation and artifacts related to data models and best practices for data layer implementation.
Data ManagementInformation Technology
Responsibilities
Leverage financial industry expertise to define conceptual, logical and physical data models in Databricks to support new and existing business domains
Work with product owners, system architects, data engineers, and vendors to create data models optimized for query performance, compute and storage costs
Define best practices for the implementation of the Bronze/Silver/Gold data layers of the lake house
Provide data model documentation and artifacts generated from data, data dictionary, data definitions, etc
Qualification
Required
At least ten or more years of experience in AI, Data Science, Software Engineering experience, including knowledge of Data ecosystem
Bachelor's degree in Computer Science, Information Systems, or a related field is required or equivalent work experience
Expertise in designing and implementing data models optimized for storage, retrieval, and analytics within Databricks on AWS, including conceptual, logical, and physical data modeling
In-depth knowledge and hands-on experience with AWS Databricks platform, including Databricks SQL, Runtime, clusters, notebooks, and integrations
Proficiency in developing ETL pipelines to extract data from various sources, transform it as per business requirements, and load it into the central data lake using Databricks tools and Spark
Experience integrating data from heterogeneous sources (relational databases, APIs, files) into Databricks while ensuring data quality, consistency, and lineage
Ability to optimize data processing workflows and SQL queries in Databricks for performance, scalability, and cost-effectiveness, leveraging partitioning, clustering, caching, and Spark optimization techniques
Understanding of data governance principles and implementing security measures to ensure data integrity, confidentiality, and compliance within the centralized data lake environment
Proficiency in writing complex SQL queries and Spark code (Scala/Python) for data manipulation, transformation, aggregation, and analysis tasks within Databricks notebooks
Understanding of cloud computing principles, AWS architecture, and services for designing scalable and resilient data solutions
Preferred
Basic knowledge of data visualization tools (e.g. Tableau) to create insightful visualizations and dashboards for data analysis and reporting purposes
Familiarity with government cloud deployment regulations/compliance policies such as FedRAMP, FISMA, etc
Company
Ampcus Inc
Ampcus is a global business, technology consulting and an staff augmentation firm specializing in AI/ML,digital solutions, Cybersecurity & Risk management, Testing, Forensics & Fraud services and human capital management.
1001-5000 employees
H1B Sponsorship
Ampcus Inc has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (14)
2024 (13)
2023 (7)
2022 (16)
2021 (13)
2020 (18)
Funding
Current Stage
Late StageLeadership Team
Raj Narayan
Sr. Vice President, Strategic Sales
Recent News
2025-08-18
2025-07-31
Seattle TechFlash
2025-07-15
Company data provided by crunchbase