Description:

The IT department seeks an ECI Database Developer who will manage enterprise data by installing/maintaining ECI software systems for information sharing between case management systems and external agencies. This includes creating data stores and T-SQL code that align with best practices. After an initial training period, telework is available up to two days per week.

Typical Duties:

• Designs, develops, and maintains database code objects, including coding for SQL stored procedures and views, in cooperation with application developers and in accordance with database standards and best practices.
• Designs, develops and maintains database code scripts to validate or maintain data external to the application.
• Manages and performs detailed testing of database objects and scripts; performs code reviews.
• Writes and maintains specifications and documentation for database objects and scripts.
• Contributes to the design of the data model for application modifications/enhancements.
• Identifies SQL code performance issues and optimizes SQL code for performance.
• Participates (with a team of six) in an on-call weekly rotation to provide support for critical systems outside regular working hours.

Additional Requirements/Preferences:

• Satisfactory criminal background check required.
• Extensive experience in client-server application development using T-SQL for coding stored procedures and
• database scripts with a good understanding of relational database concepts required.
• Advanced working knowledge of SAP (formerly Sybase) Adaptive Server Enterprise preferred.

Experience:
- Bachelor's degree in Computer Science, Information Technology, or related field
- Proven experience as a Data Architect or similar role
- Proficiency in SQL, Hadoop, AWS, Python, NoSQL databases
- Strong knowledge of data warehouse design and implementation
- Experience with server technologies such as Spark
- Ability to vaticinate future data needs and trends

Join us in this exciting opportunity to shape the future of our enterprise data architecture!

Job Types: Full-time, Contract

Pay: Up to $45.00 per hour

Expected hours: 40 per week

Benefits:

• 401(k)
• Dental insurance
• Health insurance

Schedule:

• 8 hour shift
• Day shift

Experience:

• ECI Database Developer: 3 years (Required)

Ability to Commute:

• Mechanicsburg, PA 17050 (Required)

Ability to Relocate:

• Mechanicsburg, PA 17050: Relocate before starting work (Required)

Work Location: Hybrid remote in Mechanicsburg, PA 17050