[Remote] Senior Data Engineer

Note: The job is a remote job and is open to candidates in USA. DBI Staffing is seeking a Senior Data Engineer to play a pivotal role in designing, developing, and maintaining the data architecture for the organization. The individual will be responsible for T-SQL development, ETL processes, and Python scripting to ensure efficient data transfer, transformation, and integration while collaborating closely with cross-functional teams.ResponsibilitiesUtilize advanced T-SQL skills to design, optimize, and maintain database structuresDevelop complex SQL queries for reporting and data transformationDesign, implement, and optimize ETL processes for efficient data extraction, transformation, and loadingDevelop and maintain ETL scripts using Python for seamless integration with existing data workflowsAutomate SFTP file transfer processes, ensuring secure and reliable data exchangeImport and export data and files in various formats, including flat file, XML, JSON, X12, Excel, and Parquet using PythonUtilize Python to integrate with APIs for importing and exporting dataCollaborate with team members and stakeholders to review and optimize code for efficiency and maintainabilityCollaborate with analysts and business stakeholders to understand data visualization requirementsWork closely with cross-functional teams to understand data requirements and ensure data integrityDocument data engineering processes, standards, and best practicesUse Git and Github for version control of scripts and queries, ensuring a collaborative and organized development environmentIntegrate Tableau for effective data representation and reportingSkillsBachelor's Degree in Computer Science, Information Technology, or a related fieldMinimum of 5 years of hands-on experience in T-SQL development and ETL processesProven experience in Python scripting for data manipulation and automationStrong expertise in database design, optimization, and maintenance using T-SQLProficient in developing and optimizing ETL processesExperience with automating SFTP file transfers and handling diverse file formatsKnowledge of data formats such as XML, JSON, X12, Excel, and ParquetFamiliarity with API integration for data import and export using PythonProficient in version controlling scripts and queries using Git and GithubExperience in data visualization using TableauStrong problem-solving skills and ability to troubleshoot data-related issues effectivelyIdentify and implement solutions to complex technical projectsAbility to work independently and in a team environmentExcellent communication and collaboration skillsKnowledge of health care delivery and operations a plusCompany OverviewDBI Staffing is a premier staffing organization dedicated to providing unparalleled service to clients and candidates ' IT needs. It was founded in 1999, and is headquartered in New York, New York, USA, with a workforce of 11-50 employees. Its website is https://dbistaffing.com.