SQL Expert at Integrated Resources
Edison, NJ 08817
About the Job
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: 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
Job SnapshotEmployee TypeContractorLocationEdison, NJ (Onsite)Job TypeOtherExperienceNot SpecifiedDate Posted10/17/2024Job ID24-24723
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: 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
Job SnapshotEmployee TypeContractorLocationEdison, NJ (Onsite)Job TypeOtherExperienceNot SpecifiedDate Posted10/17/2024Job ID24-24723