Design and manage scalable data architectures, ensuring data governance and integration, and collaborate with stakeholders for innovative solutions.
As a Data Architect / Data Model, you will design and manage scalable, secure data architectures to meet business needs. You will ensure the data governance, infrastructure optimization, and diverse data source integration. Collaborating with stakeholders, you will translate requirements into data architecture and produce schema diagrams and scripts to deploy those architectures. You will drive innovation by adopting emerging technologies, ensuring high data quality, and enabling analytics for decision-making.
Responsibilities:
- Design and Develop Data Architectures: Create scalable, secure, and efficient data models, schemas, and architectures to support organizational needs and analytics.
- Collaborate with Stakeholders: Work closely with business, analytics, and IT teams to translate requirements into technical data solutions.
- Integrate and Manage Data Sources: Design strategies to consolidate and manage diverse data sources, enabling seamless data integration and accessibility.
- Optimize Data Infrastructure: Analyze and improve database performance, storage solutions, and data pipelines to ensure high availability and reliability.
- Stay Updated on Emerging Technologies: Evaluate and incorporate advancements in data engineering, cloud platforms, and big data technologies to enhance the organization's capabilities.
Requirements
- Bachelor’s
or master’s degree in computer/data science technical or related
experience.
- 7+
years of hands-on relational, dimensional, and/or analytic experience
(using RDBMS, dimensional, NoSQL data platform technologies, and ETL and
data ingestion protocols).
- Experience
with data warehouse, data lake, and enterprise big data platforms in
multi-data-center contexts required.
- Strong
data modeling experience
- Needs
knowledge and experience with Snowflake
- Experience
with Azure Cloud
- Experience
with Tableau and Power BI
- Huge
bonus if they have experience with health care / insurance
- Knowledge
and hands-on experience with start schema
- Good
knowledge of metadata management, data modeling, and related tools (Erwin
or ER Studio or others) required.
- Ability
to work independently
Benefits
Working at VentureSoft means being part of a team driven by success and care. We believe in helping each other achieve their aspirations. We prioritize your growth through exceptional mentorship opportunities, continuous learning programs, and a well-defined career path. Our flat and agile structure ensures that your voice is heard, your ideas are valued, and your contributions drive success for our clients and partners. At VentureSoft, you’re not just an employee—you’re part of a community that supports your aspirations and celebrates your achievements.
- Flexible Work Schedule/Telecommuting
- Vacation / Paid Time Off
- Employee Discounts and Rewards
- Finding Balance
- Health Insurance / Wellness Program
We offer the best employee benefits and perks, and we have created a culture of appreciation within our organization. It’s a philosophy that’s not necessarily new—the idea that employees who are treated better perform better—but it’s starting to gain momentum in the professional world. At Venturesoft, we think that offering major benefits like flexible work schedules, generous PTO, and unique perks like a vacation reimbursement program (or a tuition reimbursement program), full cost for any IT certifications can do wonders for morale and productivity.
Similar Jobs
Artificial Intelligence • Professional Services • Business Intelligence • Consulting • Cybersecurity • Generative AI
Lead design and implementation of data architecture for healthcare systems, influence stakeholders, mentor teams, ensure regulatory compliance, enable data integration and transformation, and apply AI techniques to improve healthcare operations and reporting.
Top Skills:
Emr Back-End DatabasesFhir R4Gen AiHl7 V2Integration EnginesInteroperability StandardsMiddlewarePythonSQL
Information Technology
Lead design and delivery of end-to-end Databricks Lakehouse architectures, cloud data modernization, ETL/ELT and streaming pipelines, medallion data modeling, governance (Unity Catalog), performance and cost optimization, ML/AI platform enablement, CI/CD and IaC, and mentor technical teams while collaborating with stakeholders.
Top Skills:
SparkAWSAzure Data FactoryAzure Data Lake Storage Gen2Azure DevopsAzure Key VaultAzure Synapse AnalyticsCdcCi/CdData VaultDatabricksDatabricks LakehouseDatabricks SqlDatabricks WorkflowsDelta LakeDelta Live TablesEltETLGitGithub ActionsGoogle Cloud PlatformLakeflowMicrosoft Entra IdMlflowOraclePostgresPower BIPysparkPythonScalaSnowflakeSpark SqlSQLSQL ServerStructured StreamingTableauTerraformUnity CatalogVector Databases
Beauty
Lead enterprise data architecture across Snowflake, dbt, and Power BI. Define data models, integration patterns, ingestion (batch and near real-time), governance, metadata, lineage, and BI semantic layers. Own roadmap, standards, documentation, design reviews, and mentor engineering and BI teams to ensure scalable, consistent, and trusted analytics across the organization.
Top Skills:
APIsAWSAzureCRMDbtErpGCPNetSuiteOraclePower BISalesforceSAPSnowflake
What you need to know about the San Francisco Tech Scene
San Francisco and the surrounding Bay Area attracts more startup funding than any other region in the world. Home to Stanford University and UC Berkeley, leading VC firms and several of the world’s most valuable companies, the Bay Area is the place to go for anyone looking to make it big in the tech industry. That said, San Francisco has a lot to offer beyond technology thanks to a thriving art and music scene, excellent food and a short drive to several of the country’s most beautiful recreational areas.
Key Facts About San Francisco Tech
- Number of Tech Workers: 365,500; 13.9% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Google, Apple, Salesforce, Meta
- Key Industries: Artificial intelligence, cloud computing, fintech, consumer technology, software
- Funding Landscape: $50.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Sequoia Capital, Andreessen Horowitz, Bessemer Venture Partners, Greylock Partners, Khosla Ventures, Kleiner Perkins
- Research Centers and Universities: Stanford University; University of California, Berkeley; University of San Francisco; Santa Clara University; Ames Research Center; Center for AI Safety; California Institute for Regenerative Medicine
