CenterLight Health System
DATA ENGINEER III
CenterLight Health System, Uniondale, New York, United States, 11553
Job PurposeThe Data Engineer III will play a pivotal role in designing, developing, and maintaining the data architecture for our organization. This individual will be responsible for T-SQL development, ETL processes, and Python scripting to ensure efficient data transfer, transformation, and integration. The primary focus will be on automating data workflows, supporting diverse file formats, and utilizing APIs for seamless data import and export. The Data Engineer will collaborate closely with cross-functional teams to enhance data-driven decision-making and contribute to the overall success of our data infrastructure.Job Responsibilities
Utilize advanced T-SQL skills to design, optimize, and maintain database structures.Develop complex SQL queries for reporting and data transformation.Design, implement, and optimize ETL processes for efficient data extraction, transformation, and loading.Develop and maintain ETL scripts using Python for seamless integration with existing data workflows.Automate SFTP file transfer processes, ensuring secure and reliable data exchange.Import and export data and files in various formats, including flat file, XML, JSON, X12, Excel, and Parquet using Python.Utilize Python to integrate with APIs for importing and exporting data.Collaborate with team members and stakeholders to review and optimize code for efficiency and maintainability.Collaborate with analysts and business stakeholders to understand data visualization requirements.Work closely with cross-functional teams to understand data requirements and ensure data integrity.Document data engineering processes, standards, and best practices.Use Git and Github for version control of scripts and queries, ensuring a collaborative and organized development environment.Integrate Tableau for effective data representation and reporting.Schedule:
8:30 AM – 5:30 PMWeekly Hours:
40QualificationsEducation:
Bachelor's Degree in Computer Science, Information Technology, or a related field.Experience:
Minimum of 5 years of hands-on experience in T-SQL development and ETL processes. Proven experience in Python scripting for data manipulation and automation.Additional RequirementsTechnical Skills:
Strong expertise in database design, optimization, and maintenance using T-SQL.Proficient in developing and optimizing ETL processes.Experience with automating SFTP file transfers and handling diverse file formats.Knowledge of data formats such as XML, JSON, X12, Excel, and Parquet.Familiarity with API integration for data import and export using Python.Proficient in version controlling scripts and queries using Git and Github.Preferred SkillsExperience in data visualization using Tableau.Strong problem-solving skills and ability to troubleshoot data-related issues effectively.Identify and implement solutions to complex technical projects.Ability to work independently and in a team environment.Excellent communication and collaboration skills.Knowledge of health care delivery and operations a plus.Disclaimer:
Responsibilities and tasks outlined in this job description are not exhaustive and may change as determined by the needs of the company. We are an affirmative action and equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, disability, age, sexual orientation, gender identity, national origin, veteran status, height, weight, or genetic information. We are committed to providing access, equal opportunity, and reasonable accommodation for individuals with disabilities in employment, its services, programs, and activities.Salary Range (Min-Max)$115,000.00 - $130,000.00
#J-18808-Ljbffr
Utilize advanced T-SQL skills to design, optimize, and maintain database structures.Develop complex SQL queries for reporting and data transformation.Design, implement, and optimize ETL processes for efficient data extraction, transformation, and loading.Develop and maintain ETL scripts using Python for seamless integration with existing data workflows.Automate SFTP file transfer processes, ensuring secure and reliable data exchange.Import and export data and files in various formats, including flat file, XML, JSON, X12, Excel, and Parquet using Python.Utilize Python to integrate with APIs for importing and exporting data.Collaborate with team members and stakeholders to review and optimize code for efficiency and maintainability.Collaborate with analysts and business stakeholders to understand data visualization requirements.Work closely with cross-functional teams to understand data requirements and ensure data integrity.Document data engineering processes, standards, and best practices.Use Git and Github for version control of scripts and queries, ensuring a collaborative and organized development environment.Integrate Tableau for effective data representation and reporting.Schedule:
8:30 AM – 5:30 PMWeekly Hours:
40QualificationsEducation:
Bachelor's Degree in Computer Science, Information Technology, or a related field.Experience:
Minimum of 5 years of hands-on experience in T-SQL development and ETL processes. Proven experience in Python scripting for data manipulation and automation.Additional RequirementsTechnical Skills:
Strong expertise in database design, optimization, and maintenance using T-SQL.Proficient in developing and optimizing ETL processes.Experience with automating SFTP file transfers and handling diverse file formats.Knowledge of data formats such as XML, JSON, X12, Excel, and Parquet.Familiarity with API integration for data import and export using Python.Proficient in version controlling scripts and queries using Git and Github.Preferred SkillsExperience in data visualization using Tableau.Strong problem-solving skills and ability to troubleshoot data-related issues effectively.Identify and implement solutions to complex technical projects.Ability to work independently and in a team environment.Excellent communication and collaboration skills.Knowledge of health care delivery and operations a plus.Disclaimer:
Responsibilities and tasks outlined in this job description are not exhaustive and may change as determined by the needs of the company. We are an affirmative action and equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, disability, age, sexual orientation, gender identity, national origin, veteran status, height, weight, or genetic information. We are committed to providing access, equal opportunity, and reasonable accommodation for individuals with disabilities in employment, its services, programs, and activities.Salary Range (Min-Max)$115,000.00 - $130,000.00
#J-18808-Ljbffr