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.

Essential Duties & Responsibilities:

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

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.

Benefits:

ELLKAY offers a comprehensive and competitive benefit package that starts day one!

Including:

• A Competitive salary
• 401k w/ matching – once eligibility is met
• Work/life balance
• Paid Volunteer Program
• Flexible working hours
• Unlimited PTO
• Remote work options
• Employee Discounts
• Parental Leave

Our awesome culture includes:

• Working with talented, collaborative, and friendly people who love what they do
• Professional growth within
• Innovation environment
• On site in HQ Free daily lunches

Additional information

At ELLKAY, we are committed to operating as a hybrid workplace, offering employees flexibility in how they structure their time between in-office and remote work. We recognize the significance of fostering connections, collaboration, and creativity within our office culture and its positive impact on our business. Our philosophy of operating as a hybrid workplace underscores our dedication to enabling employees to tailor work-life balance to their individual preferences. For those who do not live within 40 miles of one of our offices, we are open to considering remote work for candidates whose skills and experience strongly align with the role. While we prioritize a hybrid work environment for most roles, we understand the importance of flexibility and are open to remote work for specific positions and specialized skill sets.

For more information on our company, visit www.ELLKAY.com.

ELLKAY LLC is a Smoke-Free Workplace.

ELLKAY, LLC provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.