Database Architect

TCI has an immediate need for a Database Architect in Jeffersonville, IN . This is not a Corp2Corp opportunity. This is a contract to hire opportunity.

SUMMARY

Our client is seeking a Database Architect to help expand and continually improve the backend of their next generation reporting stack and data model. As a Database Architect, you will develop and maintain the data architecture strategy for pharmacy operations, ensuring it aligns with overall business goals and IT strategy.

RESPONSIBILITIES

• Lead the technical development and innovation of our database environment.
• Curate database environments such that new development can be fully vetted through our DevOps process.
• Evaluate all incoming requests for specific and measurable impact to existing systems.
• Work closely with BI and IT leadership to shape the future of DevOps at SVP
• Accurately diagnose and resolve environment issues in tandem with the IT Engineering team.
• Keep up-to-date documentation of all objects and optimizations.
• Help Development staff manage their work via SQL Source Control
• Develop and maintain the data architecture strategy for pharmacy operations, ensuring it aligns with overall business goals and IT strategy.
• Data Integration: Design and implement robust data integration solutions to ensure seamless data flow between different systems, including EHRs, pharmacy management systems, and other healthcare applications.
• Create and maintain logical and physical data models that accurately represent the pharmacy data requirements and support efficient data retrieval and analysis.
• Establish and enforce data governance policies and procedures to ensure data quality, integrity, and security across the organization.
• Ensure that data architecture and management practices comply with healthcare regulations such as HIPAA, HITECH, and other relevant standards.
• Monitor and optimize database performance, ensuring high availability and scalability of data systems.
• Work closely with cross-functional teams, including IT, pharmacy, clinical, and business stakeholders, to gather requirements and translate them into effective data solutions.
• Evaluate and recommend new technologies and tools to enhance the data architecture and support evolving business needs.
• Documentation: Create and maintain comprehensive documentation for data architecture, data flows, and data integration processes

REQUIREMENTS

• Bachelor's degree in computer sciences, Information Systems, or related field.
• 7+ years of experience in data architecture, data management, or a related role, with a focus on healthcare or pharmacy data systems.
• Strong understanding of healthcare data standards (e.g., HL7, FHIR, NCPDP) and regulatory requirements (e.g., HIPAA, HITECH) and Pharmaceutical industry.
• Proven experience with database management systems (e.g., SQL Server, MongoDB) and data integration tools (e.g., Azure Data Factory, SSIS, Informatica etc).
• Proficiency in data modeling, data warehousing, and ETL processes.
• Strong analytical and problem-solving skills, with the ability to troubleshoot complex data issues.
• Excellent communication and collaboration skills, with the ability to work effectively with both technical and non-technical stakeholders.
• Experience with cloud-based data platforms (e.g., Azure, Google Cloud) is a plus.
• Certifications in data management or architecture (e.g., CDMP, TOGAF) are desirable
• The ideal candidate will have a deep understanding of healthcare data standards, data governance, and data integration processes. This role will involve working closely with IT, Patient Services Operations, and Insights/Analytics teams to ensure our data systems support effective decision-making and compliance with regulatory requirements.
• Work is performed on-site in Jeffersonville, IN. Not a 100% remote opportunity.