sql engineer.

job summary: 7+ years of experience in SQL Server administration and development (SQL Server 2012 - SQL Server 2019) Demonstrated experience configuring and administering SQL Server platform components including:SSAS, SSIS and CDC (change data capture), Hands on experience configuring and administering SQL Server replication. Excellent troubleshooting skills and ability to apply them under pressure strong experience in logical/physical database designs and T-SQL development of complex stored procedures Knowledge of cloud platform services for ETL/ETL such as Azure Data Factory and Logic Apps Experience with administering and using SQL monitoring tools, such as Spotlight Excellent written and oral communication skills Ability to learn and apply new technologies to existing environment Ability to perform work with minimal guidance from the other team members Willingness to communicate and work with business users and understand their requirements   location: Manhattan, New York job type: Contract salary: $85 - 95 per hour work hours: 8am to 5pm education: Bachelors   responsibilities: Provide support for all SQL Servers, including backup and recovery, database maintenance, health and performance monitoring, and troubleshoot database related issues Perform SQL server platform administration tasks such as installation and configuration, upgrades, and patching, database security and user management. Apply data modeling techniques and generate custom ETL flows using SQL Server Change Data Capture (CDC), SSIS and custom stored procedures. Setup and manage database high-availability technologies, including transactional replication, Always-On availability group, and log shipping Configure and manage SQL jobs using SQL Agent, ActiveBatch, and proprietary DW based job systems Design, develop, monitor, and performance tune database tables, views, indexes, stored procedures, functions, etc. Leverage T-SQL and other data querying tools to assist end-users with data analytics Performance tuning and optimization for T-SQL queries, stored procedures, SSIS packages, SQL Server and database configurations Provide support and guidance to other software developers and team members on SQL tools, techniques, and best practices   qualifications: Experience level: ExperiencedMinimum 5 years of experienceEducation: Bachelors  skills: SQL Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status. For certain assignments, Covid-19 vaccination and/or testing may be required by Randstad's client or applicable federal mandate, subject to approved medical or religious accommodations. Carefully review the job posting for details on vaccine/testing requirements or ask your Randstad representative for more information.

job summary: Our client is a well-known Health System in New York and they are looking for a Data Engineer to join their growing team on a full-time basis! The Data Engineer will be brought on to be responsible for data management and engineering in support of the Actuarial Informatics team of data scientists who deliver reporting, statistical modeling and advanced analytics for each of the client's diverse business areas. The role will also be supporting, enhancing, and enriching the existing claims data warehouse for supporting the data scientist team with various projects and stakeholders. This position brings excellent opportunities for growth and exposure within all levels of the organization. Develop great business relationships throughout the company footprint! Are you the next Data Engineer? Reach out today with your updated resume for immediate consideration!   location: New York, New York job type: Permanent salary: $109,000 - 136,410 per year work hours: 8am to 5pm education: Bachelors   responsibilities: Effectively collaborate and communicate with your stakeholders and customers to understand their needs and ensure all data management requests are properly triaged, recorded and tracked.Work with enrollment, eligibility, medical claims, pharmacy claims, utilization, clinical, medical management, financial, administrative and other corporate or third party data from raw, modeled and disparate internal and external sources. Work with departmental staff to identify business requirements for data intake, reporting and / or business intelligence tools.Ensure all data intake leverages approved enterprise methods for data exchange and transfer, including setup and utilization of secure FTP.Identify necessary data, data sources and methodologies to meet the business need.Work with IT or independently to collect, organize, integrate, profile and curate data, in both our Oracle RDMS or new Big Data platform Microsoft Azure Hadoop.Identify and address expected and unforeseen data complexities to mitigate their impact on the analytic outcome and associated business decisions. Clearly communicate data issues to the recipients and work to improve data quality where possible within the data marts you create. Feed data quality issues back to IT or identified data stewards (inside and outside the team) to assist in our quest for the highest quality data.Assist in building reports or dashboards that profile or express the quality of data to your stakeholders. Design and build complex Extract, Transform & Load (ETL) routines to ensure that data intake is consistently processed and integrated in accordance with approved business logic.Design and build data marts to specification to enhance efficiency of standard reporting and analyses being built by data science analysts.Execute production programs on daily, weekly, monthly and quarterly schedule for standardized reporting and other data processes that have been built by data science analysts.Adhere to corporate standards for performance metrics, data collection, data integrity, query design, and reporting format to ensure high quality, meaningful analytic output.Help identify and understand data from internal and external sources for competitive, scenario and performance analyses, and financial modeling to gain member/provider insight into new and existing processes and business opportunities.Work closely with IT on the ongoing improvement of our client's integrated data warehouse, driven by strategic and business needs, and designed to ensure data and reporting consistency throughout the organization.Develop and maintain project work plans, including critical tasks, milestones, timelines, interdependencies and contingencies. Track and report progress. Keep stakeholders apprised of project status and implications for completion. Provide technical support to data analytics functions as they relate to varied business units, and technical expertise on the selection, development and implementation of various reporting and BI tools tied to business unit reporting requirementsPrepare clear, well-organized project-specific documentation, including, at a minimum, data dictionaries, analytic methods used, key decision points and caveats, with sufficient detail to support comprehension and replication. Ability to coordinate with offshore development resources on various requests and projects.Assist and teach others within the organization on how to define meaningful process and performance measuresShare development and process knowledge with other staff to assure redundancy and continuously build a core of technical strength within the organization.Demonstrate proficiency with the principles and methodologies of process improvement. Apply these in the execution of responsibilities in support of a process focused approach.Perform other data management duties as necessary or assigned.   qualifications: Experience level: ExperiencedMinimum 4 years of experienceEducation: Bachelors (required)  skills: Data Mart (4 years of experience is preferred)Data Warehouse (4 years of experience is preferred)Healthcare EMR (3 years of experience is preferred)SQL (4 years of experience is preferred)Python (3 years of experience is preferred)Java (3 years of experience is preferred)Tableau (3 years of experience is preferred)ETL (3 years of experience is preferred)Data Analysis (4 years of experience is preferred)Data Center (4 years of experience is preferred)Oracle (3 years of experience is preferred)Azure (3 years of experience is preferred) Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status. For certain assignments, Covid-19 vaccination and/or testing may be required by Randstad's client or applicable federal mandate, subject to approved medical or religious accommodations. Carefully review the job posting for details on vaccine/testing requirements or ask your Randstad representative for more information.

job summary: Our client is a well-known Health System in New York and they are looking for a Lead Data Engineer to join their growing team on a full-time basis! The Lead Data Engineer will be brought on to be responsible for data management and engineering in support of the Actuarial Informatics team of data scientists who deliver reporting, statistical modeling and advanced analytics for each of the client's diverse business areas. The role will be architecting, supporting, enhancing and enriching a new Commercialization data model for supporting the data scientist team with various projects and stakeholders. This position brings excellent opportunities for growth and exposure within all levels of the organization. Develop great business relationships throughout the company footprint! Are you the next Lead Data Engineer? Reach out today with your updated resume for immediate consideration!   location: New York, New York job type: Permanent salary: $120,000 - 150,000 per year work hours: 8am to 5pm education: Bachelors   responsibilities: Architect and develop a comprehensive and flexible data model to handle the needs of the Commercialization Department stakeholder that meets the needs of existing and future projects.Guide team Data Engineers on data needs and development for project needs as well as provide insight into workflow improvement.Effectively collaborate and communicate with your stakeholders and customers to understand their needs and ensure all data management requests are properly triaged, recorded and tracked.Work hand in hand with data scientists and operational business and product resources to build a comprehensive, scalable, and integrated data model for the Commercialization business that includes consumer data, employer data, health center data and claims data.Work with consumer data (call, chat, other CRM, etc.), billing, clinical, enrollment, eligibility, medical claims, pharmacy claims, financial, administrative, and other corporate or third-party data from raw, modeled, and disparate internal and external sources. Ensure all data intake leverages approved enterprise methods for data exchange and transfer, including setup and utilization of secure FTP.Work with IT or independently to collect, organize, integrate, profile and curate data, in both our Oracle RDMS, Amazon AWS and/or Microsoft Azure Hadoop.Clearly communicate data issues to the recipients and work to improve data quality where possible within the data marts you create. Feed data quality issues back to IT or identified data stewards (inside and outside the team) to assist in our quest for the highest quality data. Design and build complex Extract, Transform & Load (ETL) routines to ensure that data intake is consistently processed and integrated in accordance with approved business logic.Design and build data marts to specification to enhance efficiency of standard reporting and analyses being built by data science analysts.Leverage new and existing APIs to build efficient pipelines for data exchange with internal and external parties.Execute production programs on daily, weekly, monthly and quarterly schedule for standardized reporting and other data processes that have been built by data science analysts.Adhere to corporate standards for performance metrics, data collection, data integrity, query design, and reporting format to ensure high quality, meaningful analytic output.Work closely with IT on the ongoing improvement of Mount Sinai's integrated data warehouse, driven by strategic and business needs, and designed to ensure data and reporting consistency throughout the organization.Develop and maintain project work plans, including critical tasks, milestones, timelines, interdependencies and contingencies. Track and report progress. Keep stakeholders apprised of project status and implications for completion. Prepare clear, well-organized project-specific documentation, including, at a minimum, data dictionaries, analytic methods used, key decision points and caveats, with sufficient detail to support comprehension and replication.Ability to coordinate with offshore development resources on various requests and projects.Share development and process knowledge with other staff to assure redundancy and continuously build a core of technical strength within the organization.Demonstrate proficiency with the principles and methodologies of process improvement. Apply these in the execution of responsibilities in support of a process focused approach.   qualifications: Experience level: ExperiencedMinimum 8 years of experienceEducation: Bachelors (required)  skills: data mart (8 years of experience is preferred)Data Warehouse (8 years of experience is preferred)healthcare emr (6 years of experience is preferred)SQL (6 years of experience is preferred)Python (5 years of experience is preferred)Java (5 years of experience is preferred)Tableau (5 years of experience is preferred)ETL (5 years of experience is preferred)Data Analysis (8 years of experience is preferred) Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status. For certain assignments, Covid-19 vaccination and/or testing may be required by Randstad's client or applicable federal mandate, subject to approved medical or religious accommodations. Carefully review the job posting for details on vaccine/testing requirements or ask your Randstad representative for more information.