What are the responsibilities and job description for the SQL Developer: Solvas or other CDO platform + SSIS position at KORE1?
Job Details
THIS ROLE IS FULLY ONSITE FOR 90 DAYS THEN DROPS TO HYBRID AFTER THAT.
THIS ROLE REQUIRES 45-50 HOUR WORK WEEKS.
KORE1, a nationwide provider of staffing and recruiting solutions, has an immediate opening for a SQL Developer: Solvas or other CDO platform SSIS
Rapidly growing, Dallas-based SaaS company, specializing in developing tech-enabled solutions for firms in the hedge fund and financial services industry. Our mission is to deliver a single source of truth from which investment managers can find strategic, actionable insights to drive competitive advantage and business growth.
We are a profitable company and offer competitive compensation and benefits while also providing an opportunity for advancement in a growing business.
Seeking a SQL Developer II who thrives on working with data and complex systems, and who has a passion for building efficient, optimized database solutions. The ideal candidate will have a deep understanding of SQL, ETL tools, and scripting languages like PowerShell, along with a commitment to quality and attention to detail. As a core contributor technical operations, the Database Engineer will be integral to ensuring the accuracy and performance of data processes, making them a key player in supporting continued success in delivering high-quality solutions for clients.
We are a profitable company and offer competitive compensation and benefits while also providing an opportunity for advancement in a growing business.
Seeking a SQL Developer II who thrives on working with data and complex systems, and who has a passion for building efficient, optimized database solutions. The ideal candidate will have a deep understanding of SQL, ETL tools, and scripting languages like PowerShell, along with a commitment to quality and attention to detail. As a core contributor technical operations, the Database Engineer will be integral to ensuring the accuracy and performance of data processes, making them a key player in supporting continued success in delivering 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.
- Work can average 45-50 hours per week.
Qualifications
- Bachelor's degree in Computer Science, MIS, Engineering, Accounting, Finance, or related field is preferred
- Relevant certifications a plus
- Capital Markets or Finance industry experience.
- Experience with Solvas Portfolio or CDO Suite required
- 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 like Python
- 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.
Must be authorized to work in the US without the need for current or future sponsorship.
Compensation depends on experience but is typically $85-115K.
ABOUT KORE1
Specializing in professional and technical recruiting, KORE1 is committed to supporting top IT, Engineering, Creative, Scientific, Accounting and Finance professionals in their career paths. We build deep relationships with leading companies, connecting them to exceptional talent every day. With extensive industry expertise and unmatched opportunities, our goal is to provide a unique experience for our contractors and consultants as they prepare for their next role. We are passionate about matching the right people with the right companies.
Specializing in professional and technical recruiting, KORE1 is committed to supporting top IT, Engineering, Creative, Scientific, Accounting and Finance professionals in their career paths. We build deep relationships with leading companies, connecting them to exceptional talent every day. With extensive industry expertise and unmatched opportunities, our goal is to provide a unique experience for our contractors and consultants as they prepare for their next role. We are passionate about matching the right people with the right companies.
Kore1 provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability or genetics. In addition to federal law requirements, Kore1 complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training. Kore1 expressly prohibits any form of workplace harassment based on race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, genetic information, disability, or veteran status. Improper interference with the ability of Kore1's employees to perform their job duties may result in discipline up to and including discharge.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
Salary : $85,000 - $115,000
