Principal Software Engineer, Data Warehouse

SSIS, SQL Server 2012 or 2014, ETL, WebFocus, Logi
Full Time
Telecommuting not available Travel not required

Job Description

Principal Engineer, SaaS Data Warehouse
Cincinnati, OH or Frisco, TX

Senior Software Engineer 

Job Summary 

Do some people consider you an expert in application, database or ETL design? Do you stay on the cutting edge of technology? As a Senior Software Engineer, SaaS Data Warehouse in our Agile environment, your team will rely heavily on your technical expertise in the delivery and support of scalable solutions. Your primary role includes system analysis, design, coding, testing, debugging, documenting, and installing portions of new systems and modification of existing systems. You will lead analysis activity and do high level architecture for an app feature. Your role is critical and we need you to bring energy to the team. Innovation is key for us and you’ll be expected to influence your team with new technology tools and ideas. Also, because we are Agile, there will be times that you will be expected to step beyond “traditional” engineering duties to reach your teams definition of done.


Essential Duties and Responsibilities

  • Design and develop new applications based upon detailed specifications of business and user requirements
  • Troubleshoot application issues, identify root-cause and design solutions to prevent recurrence
  • Document new applications, or the changes made to existing applications
  • Participate in unit, integration, and business acceptance testing of the applications
  • Perform code reviews to ensure compliance of standards and quality
  • Do whatever is necessary to get to your team’s “definition of done”
  • Research, experiment and recommend emerging technologies
  • Server as a mentor to junior team members


  • Bachelor’s in related field preferred
  • 6+ years of experience in a related area
  • Strong understanding of relational database design concepts and software development methodologies
  • Experienced in developing high volume transaction or analytical database systems
  • Experienced in developing and supporting completing ETL/ELT processes
  • Experience with C#, SQL, ASP.Net is required
  • Expertise in middleware pattern such as: REST, Class Libraries as a Layer, WCF and/or SOAP Web Services is required
  • Strong expertise in data storage technology such as: Microsoft Entity Framework accessing the data, Relational Databases (SQL, Oracle, MySQL, etc.), NoSQL Technologies (Hadoop, Mongo, etc.) is required
  • Be able to describe the above in a logical software stack
  • Strong understanding of unit testing concepts and frameworks
  • Ability to be self-directed
  • Experience working in an Agile environment
  • Participation and familiarity with open source projects
  • Rely on experience and judgment to plan and accomplish goals
  • Be a student of technology with passion for researching and experimenting with new technologies


Preferred Requirements

  • Financial Services, Payroll, or related business experience
  • Experience working in a distributed environment
  • Hand-on experience productionizing solutions that leverage Microsoft Azure SQL Data Warehouse, Azure Stream Analytics, Azure Event Hub, Azure Data Factory
  • Experience with NoSQL implementations, Big Data, or other appliances preferred
  • Understanding of other Web Application concepts ideal, including: MVC, React, Angular, Node, REST APIs
  • Experience with Data Visualization Tools preferred: WebFocus, Logi, Birst, Tableau, Cognos, etc.
  • Deep knowledge of SSIS, SQL Server 2014


To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements are representative of the knowledge, skill, and/or ability required.

Posted By

Erika Stark

4811 Montgomery Road Cincinnati, OH, 45212

Dice Id : RTL175447
Position Id : 069739
Have a Job? Post it