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.
- 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