ELLKAY is a nationwide leader in healthcare connectivity, providing innovative, customizable solutions and unparalleled services for over a decade. We empower diagnostic laboratories, PM/EMR vendors, ACO and HIE companies, hospitals, and other healthcare organizations with cutting-edge technologies and solutions that improve their bottom lines.
Our ‘Client-first’ focus has made ELLKAY one of the most respected healthcare IT companies in the nation. We value our clients and believe that strong relationships are the foundation for a strong company, and we’re dedicated to providing connectivity to the healthcare industry.
Company Culture: We deal with medical data and we take our work very seriously, but not ourselves. If you’re a smart, hard-working, dedicated individual who thrives in a laidback, friendly work environment, ELLKAY may be the place for you. We’re committed to attracting good people who are passionate about the work they do.
ELLKAY was founded over a decade ago on the values of innovation, efficiency, and service created in a collaborative work culture. As we have grown, we are proud to still possess the same energy and passion for what we do. We strive to provide exceptional customer experiences to our clients, which begins with first employing amazing people. ELLKAY is proud to maintain a high-quality, innovative, and diverse workforce.

JOB DESCRIPTION:

We are looking for an experienced and performance-driven Database Developer with deep expertise in query tuning and database optimization. You will be responsible for enhancing database performance, analyzing slow-running queries, and ensuring that our data infrastructure supports high-throughput, low-latency operations across applications and analytical workloads.

QUALIFICATIONS:

• A minimum 3 years of professional experience as SQL Developer or Data Engineer with strong query writing skills
• A minimum of 5 years of professional experience in information technology.
• A minimum of bachelor’s or higher in Computer Science, Information Systems, or equivalent degree or strong industry experience.
• Excellent SQL skills, with experience in building and interpreting complex queries (preferred)
• Proficient with SQL Server or have experience with other similar RDBMS like Oracle, MySQL, Postgres, etc.
• A minimum of 1 year of experience managing technical resources.

Nice-to-haves:

• Knowledge of Healthcare Domain and different healthcare terminology standards required.
• Knowledge required in Healthcare Data Standards like C-CDA, HL7 and Healthcare Billing Data Standards like 835, 837, CMS1500, UB04, etc.
• Programming experience required in any object-oriented programming languages like C#, Java etc.
• Understanding and experience of cloud-based databases such as Snowflake is a plus.

Technical Proficiency

• Extract data from client systems and restore databases as required.
• Identify and interpret data elements across various database platforms at the request of clients
• Proficiently manage diverse Database Management Systems including SQL Server, Oracle, MySQL, and Postgres.
• Demonstrate advanced SQL skills to construct and interpret intricate queries.

Problem Solving

• Identify and resolve data-related issues and inconsistencies.
• Develop innovative solutions to complex data challenges.
• Collaborate with cross-functional teams to define and implement data requirements.

Data Analysis

• Analyze and interpret complex datasets to support business decision-making.
• Create and maintain comprehensive documentation of data processes and workflows.

Data Cleansing and Transformation

• Perform thorough data analysis and execute transformations to align data with business standards.
• Clean, preprocess, and transform raw data into structured formats suitable for analysis.

Schema and Data Mapping

• Design and maintain data schemas to support various business applications.
• Map data from multiple sources to ensure seamless integration and compatibility.
• Collaborate closely with client Subject Matter Experts to grasp business objectives and requirements effectively.
• Actively contribute to knowledge management initiatives, advocating for best practices in project execution

Team Management

• Provide guidance and resources to offshore technical teams for seamless task execution.

Project Management

• Coordinate with IT teams, data analysts, and business units to ensure alignment on project goals and specifications.

Stake Holder Communication

• Maintain transparent and proactive communication with stakeholders, offering timely updates on project status, issues, and resolutions.

Documentation and Reporting

• Maintain an organized repository of project documentation and data assets
• Ensure all data engineering activities are well-documented and comply with company policies and industry standards

Adaptability

• Demonstrate flexibility in managing multiple projects and priorities simultaneously
• Embrace new tools, technologies, and methodologies to enhance data engineering capabilities