Integrated Resources
SQL Expert
Integrated Resources, Edison, New Jersey, us, 08818
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.
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.
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.
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.