All Lines Technology has an immediate opening for a Data Engineer in Robinson Township! The individual in this role will play a critical role in managing and optimizing data within our organization. They’ll be responsible for maintaining, organizing, and enhancing our data infrastructure to ensure efficient data flow, performance, and reliability. *THIS IS AN ONSITE POSITION. APPLICANTS MUST BE ABLE TO COMMUTE TO ROBINSON TOWNSHIP, PA.*

Responsibilities:
Data Maintenance:

- Archiving Old Data:
  - Identify and archive outdated data to free up storage space.
- Verification of Views/Tables/Stored Procedures:
  - Regularly assess the usage of existing views, tables, and stored procedures.
  - Determine which ones are still relevant and in active use.
- Updating Tables, Views, and Stored Procedures:
  - Collaborate with data analysts and developers to update data structures as needed.
  - Ensure data consistency and accuracy.

Data Management:

- Data Organization and Design:
  - Eliminate data flow redundancy by optimizing data pipelines.
  - Design efficient data models and schemas.
- Custom Views and Stored Procedures:
  - Create custom views and stored procedures to meet specific business requirements.
- Data Integration:
  - Combine historical data with current data from different databases and tables.

Database Performance Monitoring and Tuning:

- Query Efficiency and Configuration:
  - Monitor query performance and optimize SQL queries.
  - Fine-tune database configurations for optimal performance.
- Bottleneck Elimination:
  - Identify and address performance bottlenecks.
  - Optimize data retrieval and processing.
- Partitioning:
  - Set up data partitioning strategies to improve query speed.

Development Testing:

- Script Testing:
  - Ensure that scripts are thoroughly tested in development environments before deployment to production.
- Database Updates:
  - Keep development databases up-to-date with the latest data.
- Testing Jobs and Reports:
  - Validate data pipelines, ETL jobs, and reporting processes in development.

SQL Server Implementation and Maintenance:

- Implement, configure, and maintain critical SQL Server RDBMS systems.
- Ensure the availability and consistent performance of our corporate applications.
- Execute data loads and perform data modeling to support multiple development teams.

Custom Applications:

- Handle requests for changes in forms, functionality, or use.
- Address changes in data, roles, and new personnel.
- Conduct audits of custom applications (now within audit scope).

Automations Support:

- Assist Automations with data needs, queries, and stored procedures.
- Co-support all site SQL servers.

Qualifications:

Bachelor’s degree in Computer Science, Information Systems, or related field.
Proficiency in SQL, Python, or other relevant programming languages.
Experience with data modeling, ETL processes, and database design.
Familiarity with cloud-based data platforms (e.g., AWS, Azure, GCP).
Strong problem-solving skills and attention to detail

All Lines Technology

New Jobs

Data Engineer