Sql Developer I Jobs

Dallas, TX

Siepe is a rapidly growing, Dallas-based technology services firm, specializing in developing software applications for firms in the asset management 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.

Our clients depend on us to ensure their data is clean, relevant, and readily available to drive important business decisions. To meet those expectations, our products must be able to handle data that is relevant to our clients, and those offerings must evolve to support new types of data that the clients, and our target future clients, demand. A SQL/SSIS Developer at Siepe is expected to be proficient with SQL, SSIS, and Powershell. They understand, maintain, and troubleshoot existing scripts and packages, as well as design code for new applications that the team is building. They work with internal and external stakeholders to ensure that their code meets the required objectives and accurately models the relationships it is meant to represent. They also work with internal teams to assess and resolve problems that users have encountered when interacting with the product. This often involves digging into problems independently and arriving at effective, sustainable solutions that they then present to senior members of the team to review and approve.

We are a profitable company with a start-up-like culture and offer competitive compensation and benefits while also providing an opportunity for new team members to take ownership in a small-company environment.

Responsibilities

• Contribute and maintain Siepe’s Knowledge Base and SQL coding standards
• Develop new and enhance existing SSIS packages to load and normalize data from external sources
• Design, develop, document, test and optimize SQL database objects following Siepe coding standards
• Work with developers, business analysts, and external teams to review business requirements and transform them into database objects
• Utilize PowerShell to create scripts to orchestrate data load jobs: move, copy, and archive files; manipulate data files; convert from one format to another; initiate SSIS packages
• Work collaboratively in a growing organization
• Schedule, monitor and troubleshoot daily jobs and reports using Siepe’s job administration tools

Qualifications

• Minimum 2 years of overall SQL experience with the ability to develop, modify, optimize, and troubleshoot queries
• Bachelor’s degree in MIS, Computer Science, Engineering, Accounting, Finance, or related field
• Knowledge of T-SQL/Stored Procedure/View/Function programming and design
• US Citizen or Permanent Resident eligible to work in the US without sponsorship

Preferences

• Experience with scripting languages (PowerShell preferred)
• Early shift: 6AM – 3PM
• Experience developing with ETL tools (SSIS preferred)
• Capital Markets or Finance industry experience

Perks

• Monthly Celebrations
• Referral Program
• Learning & Development Program
• Holiday Parties
• Daily Catered Lunches
• 401k Match
• Comprehensive Benefits Package
• Quarterly Offsite Events
• Bonus Opportunities
• Paid Holidays & Vacation