Talent.com
Data Modeler
Data ModelerLingaTech • Harrisburg, PA, US
Data Modeler

Data Modeler

LingaTech • Harrisburg, PA, US
30+ days ago
Job type
  • Full-time
  • Quick Apply
Job description

Job Title :

  • Data Modeler Location : Hybrid, Central PA Employment Type : Full-Time, 6 month RTH Position Overview We are seeking a highly skilled Data Modeler to design, implement, and optimize data models that support enterprise applications and analytics.
  • The ideal candidate will have expertise in relational and dimensional data modeling, PostgreSQL, and AWS data services , with the ability to collaborate across development and analytics teams.
  • This role requires strong problem-solving skills, clear communication, and the ability to work independently while keeping stakeholders informed with proactive updates.
  • Key Responsibilities Design, create, and maintain PostgreSQL data models to support business applications and reporting.
  • Develop relational and dimensional data models optimized for performance and scalability.
  • Optimize and troubleshoot complex SQL queries for efficiency and reliability.
  • Collaborate with application teams ( .NET, Angular ) to define and document data requirements.
  • Ensure data integrity, consistency, and quality across environments.
  • Support and maintain AWS data services including Amazon RDS and Aurora.
  • Contribute to data reviews and provide insights for improving data solutions.
  • Implement version control practices using Git for database schema management.
  • Provide transparent progress reporting and proactively communicate risks or delays.

Apply performance tuning and monitoring practices for cloud-hosted databases.

  • Support data modeling for Tableau and other reporting tools.
  • Leverage ETL concepts / tools to support integration and data movement.
  • Write scripts in Python for automation and data processing tasks.
  • Document and communicate data architecture, design decisions, and standards .
  • Manage multiple assignments effectively, maintaining timelines and quality.

    • Qualifications Required :

  • 3–5+ years of experience in data modeling with relational and dimensional approaches.
  • Advanced proficiency in SQL with PostgreSQL .
  • Experience with AWS cloud data services (RDS, Aurora).
  • Strong analytical thinking, problem-solving, and troubleshooting skills .
  • Clear verbal and written communication skills.
  • Demonstrated ability to work independently and manage time effectively .
  • Proactive in reporting status, risks, and progress .
  • Familiarity with Git or other version control systems.
  • Exposure to ETL concepts and data integration tools.
  • Experience supporting Tableau data models for visualization and reporting.
  • Knowledge of cloud database performance tuning and monitoring .
  • Basic Python scripting skills for automation.
  • Exposure to .NET and Angular environments for cross-team collaboration.

    • Strong communication, organization, and time- management skills Strong knowledge of relevant reporting tools and methods Assist with creation of different reports (e.g., provider-specific reports) created from data collected / reported in the system Preferred :

  • Experience with additional AWS services (Redshift, S3, Glue).
  • Familiarity with CI / CD pipelines for database changes.
  • Background in data governance and compliance best practices.
  • Powered by JazzHR
    • Create a job alert for this search

    Data Modeler • Harrisburg, PA, US