What are the responsibilities and job description for the Data Engineer (ETL) position at Syrinx?
Purpose: Responsible for development of database code and ETL packages to move data based on requirements. This position will require the gathering of the data centric business requirements from business analysts, subject matter experts, various internal user groups and other team members to build often complex data access or data movement flows. Depending on requirements may also be responsible for coordinating with both internal and external source system administrators.
Essential Functions:
Additional Responsibilities:
Knowledge/Skills/Abilities:
REQURIED:
Essential Functions:
- Assume as a lead in the design, development, testing, maintenance and enhancement of data movements and database based applications development using SQL Server Integration Services, TSQL and Stored Procedures with limited guidance from manager or DBA.
- As needed may be responsible for creating and updating database tables using DDL and DML, backing up and recovering databases, building table indexes, and optimizing database query performance.
- Support IT staff and business users in the development, usage and troubleshooting of database-driven applications.
- Be responsible to follow data standards, resolve data issues, complete unit testing and system documentation for ETL processes.
- Assist software QA testers in the unit and functional test plans/applications for the testing of developed code and modules.
- Perform gap analysis on current solutions to determine areas of improvements as needed
- Re-factor legacy software to provide more flexible solutions aligned with corporate goals
Additional Responsibilities:
- Conduct system tests, troubleshoot customer issues and correct database defects.
- Collaborate with IT operations to perform root cause analysis.
- Conduct or contribute to design\software peer reviews.
- Document software and system designs as required.
- Insures the confidentiality, integrity, and availability of all data under their control.
Knowledge/Skills/Abilities:
REQURIED:
- Minimum of a Bachelor of Science in Computer Engineering, Computer Science, or equivalent degree.
- At least 8 years of database development experience.
- At least 5 years SQL Server development experience using SQL Server 2008, SQL Server 12, SQL Server 14.
- Experience with SSMS and other Microsoft database development tools.
- Familiarity with the Redgate Software suite of tools.
- Advanced knowledge of both TSQL and SSIS.
- Highly experienced in flat file ETL to database table conversion.
- Solid understanding of current database best practices and standards.
- Basic understanding of the .Net framework, Microsoft.NET technologies and languages.
- Advanced algorithmic and problem-solving skills, and ability to exercise these both laterally as a team member or individually.
- Experience working with virtual cloud based servers.
- Experience developing code under source version control systems such as TFS or SVN.
- Experience with software release preparation and deployment in a large enterprise.
- Excellent command of written and spoken English.
Front End Engineer
Catalytic Data Science -
BOSTON, MA
Software Engineer, Backend/Server-Side
Catalytic Data Science -
BOSTON, MA
Data Engineer
EDI Staffing, an EDI Specialists Company -
Boston, MA