SQL Expert

Job Title:
SQL Expert

Location:
Remote

Duration:
Permanent role

Job Description:
We are seeking a skilled SQL expert to enhance the performance of our large-scale applications. The ideal candidate will have a strong focus on optimizing database systems and a proven track record of delivering results in complex environments.

Key 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:
minimum 3 years of professional experience as SQL Developer or Data Engineer with strong query writing skills
minimum of 5 years of professional experience in information technology.
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.
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.

---