ETL Developer

03 Dec 2024

Vacancy expired!

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
  • Perform some SQL Server DBA responsibilities. Manage database permissions, ad-hoc backup / restore operations, administration of SQL Agent Jobs, manual deployment of database scripts, etc.
  • Oversee and define development specifications, technical requirements, system performance objectives, and necessary system modifications
  • 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

  • ID: #23784385
  • State: Texas Dallas / fort worth 75202 Dallas / fort worth USA
  • City: Dallas / fort worth
  • Salary: $60 - $70
  • Job type: Contract
  • Showed: 2021-12-03
  • Deadline: 2022-01-30
  • Category: Et cetera