Apply Now

Database Administrator (SSIS ETL/Python) - 3632566

New York, NY, US • Posted 1 day ago • Updated 8 hours ago

Full Time

On-site

USD $70.00 - 75.00 per hour

Fitment

Dice Job Match Score™

👾 Reticulating splines...

Job Details

Skills

Data Warehouse
Database Migration
Microsoft Azure
Scripting
Provisioning
Data Management
Product Analysis
Mentorship
Knowledge Transfer
Testing
Integration Testing
Collaboration
Internal Control
Regulatory Compliance
Auditing
Database
Optimization
Microsoft SSIS
Extract
Transform
Load
Data Integration
Workflow
Python
Data Manipulation
Mainframe
Legacy Systems
Data Structure
RDBMS
Database Administration
Performance Tuning
Management
Analytical Skill
Problem Solving
Conflict Resolution
Issue Resolution

Data Warehouse
Database Migration
Microsoft Azure
Scripting
Provisioning
Data Management
Product Analysis
Mentorship
Knowledge Transfer
Testing
Integration Testing
Collaboration
Internal Control
Regulatory Compliance
Auditing
Database
Optimization
Microsoft SSIS
Extract
Transform
Load
Data Integration
Workflow
Python
Data Manipulation
Mainframe
Legacy Systems
Data Structure
RDBMS
Database Administration
Performance Tuning
Management
Analytical Skill
Problem Solving
Conflict Resolution
Issue Resolution

Summary

Lighthouse Technology Services is partnering with our client to fill their Database Administrator (SSIS ETL/Python) position! This is a 6-18 months contract and will be hybrid on site 4 days in Buffalo, NY. This role will be a W2 employee of Lighthouse Technology Services. No C2C or subcontracting arrangements will be considered.

What You'll Be Doing:

Lead the support and optimization of a data warehouse environment comprised of 10-20 databases, managing all data intake processes and ETL workflows using SSIS
Design and implement RDBMS solutions that align with both short and long-term business requirements, serving as the technical architect on complex database projects
Drive database migration initiatives to CoLo and Microsoft Azure environments, with future involvement in Azure Data Factory for ETL processes
Develop and maintain Python scripts for data movement, transformation, and consumption across multiple database platforms
Provide database support for on-premise vendor applications and manage a shared database environment for in-house web and client applications, including provisioning access and data management
Serve as Subject Matter Expert (SME) for RDBMS-related initiatives, providing guidance on vendor/product analysis, functional specifications, and optimal database designs
Mentor and train less experienced database personnel, conducting knowledge transfer sessions and overseeing their development in RDBMS functionality and testing
Collaborate with application owners and technology stakeholders to translate business requirements into detailed functional specifications and efficient database solutions
Manage and oversee execution of complex project plans, ensuring proper task dependencies, issue mitigation, and integrated testing coordination
Maintain internal control standards and ensure compliance with regulatory requirements, audit points, and system maintenance protocols

What You'll Need to Have:

8+ years of hands-on RDBMS experience with expertise in database engineering, design, and optimization
Strong proficiency in SSIS for ETL development, with demonstrated ability to build and maintain complex data integration workflows
Solid programming skills in Python for data manipulation, automation, and integration tasks
Mainframe experience with understanding of legacy system data structures and integration patterns
Proven track record leading large-scale RDBMS enhancements, conversions, and production problem resolution across multiple concurrent projects
Mastery-level knowledge of relational database management systems, including architecture, performance tuning, and troubleshooting
Strong project and task management skills with ability to coordinate cross-functional teams and manage competing priorities
Excellent analytical and problem-solving abilities with experience leading issue resolution efforts and providing technical guidance

Pay Range: $70-75/hr

Questions about any of our jobs? Email us at

View all of our open jobs here: jobs.lhtservices.com

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.

Dice Id: 10114206
Position Id: be46dfb43d3c8eeb6226883d57829e16
Posted 1 day ago

Create job alert

Never miss an opportunity! Create an alert based on the job you applied for.

Hybrid in Jersey City, New Jersey

•

Today

Are you ready to make an impact at DTCC? Do you want to work on innovative projects, collaborate with a dynamic and supportive team, and receive investment in your professional development? At DTCC, we are at the forefront of innovation in the financial markets. We are committed to helping our employees grow and succeed. We believe that you have the skills and drive to make a real impact. We foster a thriving internal community and are committed to creating a workplace that looks like the world

Full-time

Senior Database Reliability Engineer

New York, New York

•

6d ago

Credit Acceptance is proud to be an award-winning company recognized both locally and nationally across multiple workplace categories. Our world-class culture is shaped by dedicated team members who are driven to succeed as professionals individually and together as a team. Backed by a strong product, exceptional people, and a stable financial foundation, we've grown into a leading provider of used and new car financing across the country. Our Engineering and Analytics Team Members utilize the l

Full-time

USD 104,081.00 - 152,652.00 per year

Software Development Specialist

Remote or Jersey City, New Jersey

•

Today

Company Overview NTT DATA strives to hire exceptional, innovative, and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now. We are currently seeking a professional to join our team in Jersey City, New Jersey (US-NJ), United States (US). About the Role We are looking for a seasoned Senior SQL Developer to join our data engineering team. In this role, you will serve as a subject matter expert in relatio

Full-time

Data Warehouse, DB, AI - Application Programmer III

Jersey City, New Jersey

•

2d ago

Title: Data Warehouse, DB, AI - Application Programmer Location: Jersey City, NJ Employment Type: Contract Compensation: Pay Range:$47.49-$67.85 Per Hr Description Join our team as a Data Warehouse Developer in a hybrid role based in Jersey City, NJ. This contract position requires expertise in database design, data modeling, and modern analytics platforms. You will be responsible for designing, developing, and maintaining large-scale data warehouse and analytics platforms, utilizing technol

Easy Apply

Contract, Third Party

$47.49 - $67.85

Search all similar jobs

More jobs at Lighthouse Technology Services in New York, NY

Database Administrator (SSIS ETL/Python) - 3632566

Dice Job Match Score™

Job Details

Skills

Summary

Similar Jobs