Overview
Remote
On Site
$50 - $70 hourly
Accepts corp to corp applications
Contract - W2
Contract - Independent
Contract - Temp
Skills
Stored Procedures
Data Integrity
Data Modeling
Performance Tuning
Use Cases
Auditing
Data Retention
Authentication
FOCUS
Data Warehouse
Data Integration
Scalability
Data Quality
Data Validation
Collaboration
Documentation
Workflow
Regulatory Compliance
SQL
Transact-SQL
Database Design
Normalization
Application Development
Microsoft SQL Server
Database
Extract
Transform
Load
Management
Testing
.NET
Artificial Intelligence
Messaging
Job Details
RESPONSIBILITIES:
Kforce has a client that is seeking a remote Lead Database ETL to help with a 1-year contract.
Key Tasks:
* Lead Database ETL writes and optimizes complex SQL queries, stored procedures, triggers, and functions; Designs database schemas, tables, and relationships to support applications
* Ensures data integrity and efficient data retrieval for applications; Collaborates with software developers to integrate databases with applications
* As a Lead Database ETL, you may work on data modeling and performance tuning for specific use cases
* Performs audits on data retention and data logging strategies
* Cross server login authentication for production or test users
* Focus Area: Building and optimizing databases for application functionality and security
* Design and Develop ETL Processes: Create and implement ETL pipelines to extract data from structured and unstructured sources, transform it (e.g., clean, aggregate, enrich), and load it into target systems like data warehouses or databases
* Data Integration: Integrate data from multiple sources, ensuring consistency, accuracy, and reliability
* Optimize Performance: Tune ETL processes for efficiency, scalability, and performance, minimizing processing time and resource usage
* Data Quality Assurance: Implement data validation, cleansing, and error-handling mechanisms to ensure high-quality data
* Collaborate with Stakeholders: Work with data analysts, data scientists, and business teams to understand data requirements and deliver solutions
* Maintain and Monitor ETL Jobs: Schedule, monitor, and troubleshoot ETL workflows, ensuring timely and accurate data delivery
* Documentation: Document ETL processes, data mappings, and workflows for reference and compliance
REQUIREMENTS:
* Strong programming skills (e.g., SQL, T-SQL); Knowledge of database design principles and normalization
* Familiarity with application development and APIs
* Tools: SQL Server 2022
* Expertise with designing, developing and managing Microsoft SQL Server databases
* Expertise with designing, developing and maintaining ETL Processes and managing data
* Expertise with developing, testing and maintaining .NET applications
* Integrating and supporting third party software
Scoring:
* 20% - Cost
* 70% - Expertise with designing, developing and managing Microsoft SQL Server databases; Expertise with designing, developing and maintaining ETL Processes and managing data; Expertise with developing, testing and maintaining .NET applications
* 10% - Integrating and supporting third party software
The pay range is the lowest to highest compensation we reasonably in good faith believe we would pay at posting for this role. We may ultimately pay more or less than this range. Employee pay is based on factors like relevant education, qualifications, certifications, experience, skills, seniority, location, performance, union contract and business needs. This range may be modified in the future.
We offer comprehensive benefits including medical/dental/vision insurance, HSA, FSA, 401(k), and life, disability & ADD insurance to eligible employees. Salaried personnel receive paid time off. Hourly employees are not eligible for paid time off unless required by law. Hourly employees on a Service Contract Act project are eligible for paid sick leave.
Note: Pay is not considered compensation until it is earned, vested and determinable. The amount and availability of any compensation remains in Kforce's sole discretion unless and until paid and may be modified in its discretion consistent with the law.
This job is not eligible for bonuses, incentives or commissions.
Kforce is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.
By clicking ?Apply Today? you agree to receive calls, AI-generated calls, text messages or emails from Kforce and its affiliates, and service providers. Note that if you choose to communicate with Kforce via text messaging the frequency may vary, and message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You will always have the right to cease communicating via text by using key words such as STOP.
Kforce has a client that is seeking a remote Lead Database ETL to help with a 1-year contract.
Key Tasks:
* Lead Database ETL writes and optimizes complex SQL queries, stored procedures, triggers, and functions; Designs database schemas, tables, and relationships to support applications
* Ensures data integrity and efficient data retrieval for applications; Collaborates with software developers to integrate databases with applications
* As a Lead Database ETL, you may work on data modeling and performance tuning for specific use cases
* Performs audits on data retention and data logging strategies
* Cross server login authentication for production or test users
* Focus Area: Building and optimizing databases for application functionality and security
* Design and Develop ETL Processes: Create and implement ETL pipelines to extract data from structured and unstructured sources, transform it (e.g., clean, aggregate, enrich), and load it into target systems like data warehouses or databases
* Data Integration: Integrate data from multiple sources, ensuring consistency, accuracy, and reliability
* Optimize Performance: Tune ETL processes for efficiency, scalability, and performance, minimizing processing time and resource usage
* Data Quality Assurance: Implement data validation, cleansing, and error-handling mechanisms to ensure high-quality data
* Collaborate with Stakeholders: Work with data analysts, data scientists, and business teams to understand data requirements and deliver solutions
* Maintain and Monitor ETL Jobs: Schedule, monitor, and troubleshoot ETL workflows, ensuring timely and accurate data delivery
* Documentation: Document ETL processes, data mappings, and workflows for reference and compliance
REQUIREMENTS:
* Strong programming skills (e.g., SQL, T-SQL); Knowledge of database design principles and normalization
* Familiarity with application development and APIs
* Tools: SQL Server 2022
* Expertise with designing, developing and managing Microsoft SQL Server databases
* Expertise with designing, developing and maintaining ETL Processes and managing data
* Expertise with developing, testing and maintaining .NET applications
* Integrating and supporting third party software
Scoring:
* 20% - Cost
* 70% - Expertise with designing, developing and managing Microsoft SQL Server databases; Expertise with designing, developing and maintaining ETL Processes and managing data; Expertise with developing, testing and maintaining .NET applications
* 10% - Integrating and supporting third party software
The pay range is the lowest to highest compensation we reasonably in good faith believe we would pay at posting for this role. We may ultimately pay more or less than this range. Employee pay is based on factors like relevant education, qualifications, certifications, experience, skills, seniority, location, performance, union contract and business needs. This range may be modified in the future.
We offer comprehensive benefits including medical/dental/vision insurance, HSA, FSA, 401(k), and life, disability & ADD insurance to eligible employees. Salaried personnel receive paid time off. Hourly employees are not eligible for paid time off unless required by law. Hourly employees on a Service Contract Act project are eligible for paid sick leave.
Note: Pay is not considered compensation until it is earned, vested and determinable. The amount and availability of any compensation remains in Kforce's sole discretion unless and until paid and may be modified in its discretion consistent with the law.
This job is not eligible for bonuses, incentives or commissions.
Kforce is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.
By clicking ?Apply Today? you agree to receive calls, AI-generated calls, text messages or emails from Kforce and its affiliates, and service providers. Note that if you choose to communicate with Kforce via text messaging the frequency may vary, and message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You will always have the right to cease communicating via text by using key words such as STOP.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.