SQL Expert - Integrated Resources, Inc

Job Title: SQL Expert
Location: Remote
Duration: Permanent role

Job Description:
SQL guru to join our team, with a strong focus on optimizing large-scale applications. We need someone with deep expertise in SQL and a proven track record of enhancing performance in complex, high-traffic environments.

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.

• 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.

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

• 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.

• 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.

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

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

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

• 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.

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

• 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.

• 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.