SQL Developer II

Dexian - University Park, TX

Full-time - Mid Level

University Park, TX

10,001+ employees

Administrative and Support Services

About the position

The SQL Developer II position is designed for an individual who excels in working with data and complex systems, focusing on building efficient and optimized database solutions. This role is crucial for ensuring the accuracy and performance of data processes, contributing significantly to the technical operations and the delivery of high-quality solutions for clients.

Responsibilities

• Work collaboratively with developers, business analysts, and external teams to review business requirements and transform them into database objects
• Design, develop, document, test and optimize SQL database objects following coding standards
• Develop new and enhance existing data extracts from Solvas Portfolio
• Develop new and enhance existing SSIS packages to load and normalize data from external sources
• Use Microsoft PowerShell to create scripts to orchestrate data load jobs: move, copy, and archive files; manipulating data files; convert from one format to another; initiating SSIS packages
• Create, maintain, and publish data models, data dictionaries and ER diagrams
• Contribute to and maintain Knowledge Base and SQL coding standards
• Schedule, monitor and troubleshoot daily jobs and reports using job administration tools

Requirements

• Minimum 5 years of overall SQL experience with the ability to develop, modify, optimize, and troubleshoot complex queries
• Advanced knowledge of T-SQL/Stored Procedure/View/Function programming and design
• Minimum 5 years of experience developing with ETL tools (SSIS preferred)
• Experience with PowerShell or other scripting languages
• Capital Markets or Finance industry experience
• Experience with Solvas Portfolio or CDO Suite preferred
• Bachelor's degree in Computer Science, MIS, Engineering, Accounting, Finance, or related field

Nice-to-haves

• Enjoys working with numbers and data in various formats
• Pays attention to detail and takes ownership and pride in delivering quality work outputs
• Adapts quickly in fast-paced environments, possessing excellent analytical and problem-solving skills
• Comfortable communicating effectively (written and verbal) as well as working with a team
• Takes initiative and ownership of job responsibilities and performs duties accurately and timely
• Self-motivated, self-starter, and challenge-seeker