Siepe
SQL Developer II
Siepe, Dallas, Texas, United States, 75215
Siepe is a 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.Siepe is 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 to Siepe’s technical operations, the Database Engineer will be integral to ensuring the accuracy and performance of data processes, making them a key player in supporting Siepe’s 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 Siepe 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 Siepe’s Knowledge Base and SQL coding standards.Schedule, monitor and troubleshoot daily jobs and reports using Siepe’s job administration tools.Qualifications
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.US Citizen or Permanent Resident eligible to work in the US without sponsorship.Skills
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.
We are proud to offer a comprehensive benefits package that supports your well-being both inside and outside of work. Enjoy paid holidays and vacation, 401k matching, and bonus opportunities, as well as access to our learning & development program to help you grow your career. Additional perks include daily catered lunches, monthly celebrations, quarterly offsite events, and annual holiday parties. We also provide a generous employee referral program. Join us and be part of a company that invests in your success and values your contributions!
#J-18808-Ljbffr
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 Siepe 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 Siepe’s Knowledge Base and SQL coding standards.Schedule, monitor and troubleshoot daily jobs and reports using Siepe’s job administration tools.Qualifications
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.US Citizen or Permanent Resident eligible to work in the US without sponsorship.Skills
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.
We are proud to offer a comprehensive benefits package that supports your well-being both inside and outside of work. Enjoy paid holidays and vacation, 401k matching, and bonus opportunities, as well as access to our learning & development program to help you grow your career. Additional perks include daily catered lunches, monthly celebrations, quarterly offsite events, and annual holiday parties. We also provide a generous employee referral program. Join us and be part of a company that invests in your success and values your contributions!
#J-18808-Ljbffr