What are the responsibilities and job description for the SQL Developer II position at KORE1 Technologies?
KORE1, a nationwide provider of staffing and recruiting solutions, has an immediate opening for SQL Developer II 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 ttechnical 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.ResponsibilitiesWork 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.QualificationsMinimum 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.Must be authorized to work in the US without the need for current or future sponsorship.SkillsEnjoys 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.Compensation depends on experience but is typicallyABOUT KORE1Specializing 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.
