ETL Developer Job at VDart Inc, Dallas, TX

eFYrQXFWZ2s1S0k5SjV0UDgvemUxUVM5TkE9PQ==
  • VDart Inc
  • Dallas, TX

Job Description

Position: ETL Developer

Location: 4 days in the office and 1 day remote - Dallas, TX 75202

Duration: 6 12 month contract with possible contract to hire

Top Skill: T-SQL

The ETL developer will design, develop, and maintain solutions for ingestion, transformation, and loading data into our Enterprise Data Warehouse. The successful candidate will have strong experience developing configurable SSIS/T-SQL/Stored Procedures skills to load and extract data on SQL Server platform.

Job Responsibilities and Duties:

Essential Duties:

  • Support full development life cycle for new ETL solutions. This includes understanding requirements, design/development of the solution, testing, deployment, and ultimately ongoing support of the solution
  • Ongoing support and improvement of existing database and ETL solutions
  • Develop automated solutions through Stored Procedures, SSIS packages and ETL Jobs to extract data in custom formats based on various source systems.
  • Assist with creation of visual documentation of existing solutions/processes
  • Research and analyze business requirements to recommend optimal architecture solutions
  • Contribute to project plan development, offer input, communicate status, and ensure timely issue escalation
  • Ensure the design of data systems, including the Enterprise Data Warehouse, is optimal to achieve Practice, Clinical, Business and Research goals and outcomes
  • Support in designing schemas, federate data from large enterprise systems, and make that data available for informed decision making, reporting, analysis, and data mining
  • Design data marts, develop scheduled and ad-hoc parameterized queries and reports from a variety of data sources and provide on-going analytical support for these kind of requests
  • Assist with identification of data integrity problems and recommend solutions
  • Define and enforce architectural standards, procedures, metrics, and policies for data across the enterprise to ensure consistency and adherence to best practices
  • Support application development teams in the data design of complex solutions and ensure that teams are in alignment with the organization's data architecture principles, standards, strategies, and target states
  • Facilitate transition from high-level design to detailed implementation and support a project lifecycle with input from management where needed.

Required Technical Skills:

  • SQL Server 2008/2012/2014/2016/2019
  • Transact-SQL (Creating stored procedures, views, functions)
  • Light SQL Server DBA tasks: assign permissions, restore databases, identify error messages upon receiving failure notification of SQL Agent jobs, etc.
  • Ability to troubleshoot and modify existing T-SQL scripts and procedures
  • Strong experience developing and deploying configurable SSIS solutions
  • Adherence to best practices for developing solutions using SQL Server

Job Tags

Contract work, Remote job,

Similar Jobs

Bunzl Distribution

Warehouse Order Selector Job at Bunzl Distribution

 ...- Picking and filling orders from stock, packing and shipping orders, or managing, organizing and retrieving stock in the warehouse. - Selecting, staging, packaging of customer orders to be delivered without damage or error. - Operate an order selector/cherry picker... 

GE Vernova

GE Vernova Gas Power Aero Engineering -Mechanical Engineer Intern - Fall 2025 Job at GE Vernova

 ...electrify and decarbonize the world? Aero engineering executes designs on a full portfolio of new product introduction (NPI), reliability...  ...is also eligible for: Relocation Assistance: Co-op/Interns will be reimbursed for reasonable, proper, and documented expenditures... 

Fusion Technology LLC

CJIS FAST-LESS Systems Engineer Job at Fusion Technology LLC

 ...made it through the process of receiving a United States government security clearance congratulations! We know you are a trustworthy intel professional because you have an active Secret security clearance. Experience is important to us: You have a Bachelors... 

O'Hara Corporation

Recreational Boat Mechanic Job at O'Hara Corporation

 ...for over 30 years. The parent company, OHara Corporation, has been in the maritime industry for over 100 years, operating fishing boats around the country. Starting in Boston as Francis J. OHara and Sons. In the 1990s, the fishing industry declined on the East... 

Purple Drive

ServiceNow Developer Job at Purple Drive

 ...Mandatory skills ServiceNow Development JavaScript DevOps Service now Devops Key Responsibilities: Proficiency in ServiceNow ITSM, Integrations, CMDB, Custom Application, Reporting and ServiceNow DevOps Modules Strong experience in...