Data Modeler Job at LingaTech, Harrisburg, PA

STNieGtaVWpuZnE2Zk05S3hUL01WQ0tEb1E9PQ==
  • LingaTech
  • Harrisburg, PA

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.

Job Tags

Full time,

Similar Jobs

Neomorph, Inc.

Associate Principal Scientist, Computational Chemistry Job at Neomorph, Inc.

 ...Neomorph is seeking a highly experienced and strategic Associate Principal Scientist to join our dynamic and collaborative Computational Chemistry team. This individual contributor role is ideal for someone who thrives in a fast-paced startup environment and is eager to... 

Providence Staffing LLC

Family Law Attorney Job at Providence Staffing LLC

 ...Providence Staffing has partnered with well-respected family law firm in Salt Lake City, Utah, known for our compassionate approach and...  ...clients. Their team is expanding, and we are seeking a Family Law Attorney who shares our dedication to making a positive impact in the... 

Better Living Solutions

Locum - Emergency Physician MD/DO, Jefferson City, MO Job at Better Living Solutions

 ...Locum - Emergency Physician MD/DO, Jefferson City, MO Job Details & Requirements ~ Coverage needed July ongoing ~4 Facility with range 55K, 9K, 16K, 25K ~24 - 36 hours of physician coverage ~ ABEM, ABIM accepted ~ ACLS, ATLS, PALS Certs ~ Paid weekly via... 

Ascend Performing Arts

Class A National Tour Driver Musical Organization Immediate Hire Job at Ascend Performing Arts

Class A National Tour Driver Musical Organization Immediate HireThis position is driving for the Blue Knights Drum and Bugle Corps, an...  ...tour beginning June 15 and ending August 15, 2018. Additional part-time opportunities year-round. Drivers are an important part of a... 

Tungsten Parts Wyoming Inc

AP/AR General Accountant Job at Tungsten Parts Wyoming Inc

 ...candidate will be responsible for managing and overseeing the accounts payable and receivable processes to ensure accurate and timely financial transactions. This role is integral to maintaining strong financial controls, ensuring compliance with company policies, and...