Data Modeler

Job not on LinkedIn

🔥 0 minutes ago

🇺🇸 United States – Remote

⏰ Full Time

🟠 Senior

🔴 Lead

🦅 H1B Visa Sponsor

This company has sponsored H1B visas in the past.

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

CSpring

WebsiteLinkedInAll Job Openings

51 - 200 employees

🤝 B2B

💼 Consulting

☁️ SaaS

B2B • Consulting • SaaS

CSpring is a consulting firm that specializes in unlocking the power and potential of data to achieve technology-enabled business goals. Founded in 1996, the company focuses on data-driven solutions that align with clients' business objectives, offering services such as data architecture, management, analytics, and reporting. With a team of full-time consultants, CSpring collaborates with both public and private sector clients to develop technology strategies, architect data solutions, build software, and create visualizations tailored to meet unique client needs. CSpring is also recognized as a certified Woman-owned Business Enterprise (WBE) and has been named a Best Place to Work in Indiana.

📋 Description

• Develop and deliver long-term strategic goals for data architecture vision and standards • Lead data architecture, data modeling, and data movement initiatives for healthcare data warehouses • Create end-to-end visions for logical-to-physical database design and data flows • Document data architecture and enterprise environments • Analyze business needs and create conceptual, logical, and physical data models • Develop dimensional, normalized, OLAP, and Data Vault models • Define keys, indexes, partitioning, constraints, and referential integrity rules • Produce and maintain ERDs, data flow diagrams, and model documentation • Ensure regulatory compliance and oversee data-source, data-movement, interface, and analytics mapping • Maintain data dictionaries, business glossaries, metadata policies, and lineage documentation • Support sensitive-data classification and protection • Provide technical recommendations and collaborate with architects, engineers, SMEs, and stakeholders • Address systems integration, compatibility, and multiple-platform integration issues • Develop implementation components and testing criteria for data architecture fidelity and performance • Communicate with customers and project teams and escalate issues and risks • Support migration of legacy Teradata models to Azure Synapse, Databricks Lakehouse, and Snowflake • Design target-state medallion architecture, Delta Lake, and Parquet models • Assess existing models for modernization, redundancy, and optimization

🎯 Requirements

• Strong problem-solving, influencing, communication, and presentation skills; self-starter • 7+ years of experience in data modeling, data strategy, and roadmaps for large and complex health entities and systems • Experience implementing large-scale, end-to-end Data Management & Analytics solutions for more than one large client • 5+ years of knowledge of regulatory security requirements regarding HIPAA, PHI, PII, and other healthcare data security standards • 5+ years of experience with Erwin Data Model or comparable tools such as ER/Studio or SQL Developer Data Modeler • 5+ years of healthcare domain knowledge covering Medicaid, Medicare, and Commercial healthcare data sets • Expertise with normalized OLTP, OLAP, MDM, and dimensional modeling techniques • 5+ years of expert-level SQL skills, including complex analytic queries, stored procedures, DDL, DML, DCL, query optimization, ANSI standards, and code review • 5+ years of experience in Data Quality, Data Profiling, Data Governance, Data Security, Metadata Management, MDM, Data Archival, and Data Migration strategies • Ability to work in a fast-paced, changing environment with short deadlines, interruptions, and multiple concurrent tasks/projects • Ability to work independently with planning, strategy, estimation, and scheduling skills • Preferred: Microsoft Azure infrastructure and services • Preferred: Snowflake DBMS, Power BI or Tableau, State Medicaid EDW/MMIS or federal reporting programs • Preferred: Teradata Vantage 20 modernization, Delta Lake/lakehouse architecture, Microsoft Fabric, AI/ML and GenAI tools • Preferred: ETL tools such as Informatica or Azure Data Factory • Preferred: BI/reporting software and Python or R

🏖️ Benefits

• Purposeful projects • People-first culture • Support, autonomy, and community • Strategic, hands-on work • Collaborative trust • Growth and career development opportunities