Location: Dallas Region
Category: Information Technology
Employment Type: Contract To Hire
Job Title: SQL Database Engineer
ESSENTIAL DUTIES AND RESPONSIBILITIES
Lead in architecting, designing, modeling, developing, maintaining and deploying complex datamodels, and data integrations utilizing SQL server (SSIS) based ETL processes for new and existing systems
Lead in planning and implementing the data integration and data migration activities.
Coordinate with team members to perform database programming based on project requirements.
Develop stored procedures, complex SQL queries, scripts and database programming for systems.
Assist in identifying process improvements for database performance, reliability and stability.
Perform Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS
SQL Server by using SSIS services
Knowledgeable in best practices for data modelling, database programming and job scheduling and ETL package dependencies.
Provide technical leadership for large-scale database projects.
Participate in all of Software Development Life Cycle, starting from requirements, design,
maintenance, enhancement, coding, and administration of SQL servers
Creates complex Graphs & Charts in SSRS with drill down functionality accessing SQL databases using T-SQL or other techniques to meet the requirements.
Meets with decision makers, systems owners, and end users to define reporting requirements and goals.
In conjunction with data owners and business units, develops models, procedures, and protocols for reporting in concert with company goals.
Creates prototype reporting models, specifications, diagrams, and charts to provide direction to system programmers.
Works with application development staff to coordinate the creation and management of reporting structures.
Prepares and delivers reports, recommendations, or alternatives for improving processes in reporting systems across the organization.
Advises department and managers regarding appropriate, effective, and efficient use of organizational reporting capabilities and functions.
Researches, reviews, and analyzed the effectiveness and efficiency of existing report procedures and develops strategies for enhancing or further leveraging these processes.
Liaisons with various business groups in the organization to facilitate implementation of new or improved reporting processes.
Communicates reporting changes, enhancements, and modifications – verbally or through written documentation – to management and other employees so that issues and solutions are understood.
Develops routines and procedures for end-users to facilitate best practices use of reporting tools and applications.
Maintains all documentation related to reporting.
Other duties as assigned
To perform this job successfully, an individual must be able to perform each essential duty satisfactorily.
Minimum of 5 years of experience working with data in a healthcare related field - Clinical and Billing a plus
Minimum of 5 years of experience writing reports against Microsoft SQL Server databases.
Bachelor's degree in Computer Science, Information Systems, Health Care Administration, Business, or equivalent experience, preferred
Specific training courses in hardware, software and/or systems, project management methodologies, preferred
Strong knowledge and experience writing complicated T-SQL queries and Stored Procedures (i.e. correlated sub queries, inline SQL….)
o Tableau, BI 360 and other drag and drop / analytic reporting tools
o Creating and managing ETL processes
o Statistical analysis
o SSRS 2008 developer with .NET experience
• Strong ability to quickly understand complicated and highly normalized databases and
• Effective verbal and written communications skills
• Critical thinking and analytical skills
• Must be able to work under pressure, following a plan and balancing requests by priority
• High level of integrity and trust
• Proficient knowledge of Microsoft Office applications required
• Strong customer service and team focus is required