Senior Software Engineer - DB Development
Reston, Virginia, United States · Information Technology · 17724
Specialist On Call, Inc. seeks a Senior Software Engineer – DB Development to work in Reston, VA and be responsible for developing, creating and modifying general computer application software and specialized utility programs. Also responsible for developing software solutions.
Specific duties include:
(i) creating OLAP/OLTP logical and physical relational data models, SQL queries and ETL processes;
(ii) SQL query tuning and optimization as well as stored procedure coding;
(iii) overseeing data mapping and data architecture for the company;
(iv) participating in a reporting shop through the requirement, design, development and QA SDLC cycles with a focus on relational databases and BI (Business Intelligence) technologies;
(v) executing report automation where needed;
(vi) understanding BI and analytics as related to the company’s business model;
(vii) collaborating with team and business owners in the development and/or execution of all types of data warehouse and report development considering the objectives of the organization;
(viii) participating in the full systems life cycle with solution design, development, implementation and product support using scrum and otheragile methodologies;
(ix) maintaining source-code repository and participating in deployment of code into production;
(x) participating in development process improvements of the company's continuous integrations services;
(xi) communicating the status and forecasting of these projects to internal clients through a variety of methods including project status reports; and
(xii) identifying new technologies that will benefit short- and long-term department goals.
Must have a bachelor's degree in Computer Science, Mathematics, Science or Engineering and five (5) years of post-baccalaureate, progressively responsibleexperience in a related position.
Requiredexperience must include:
(i) five (5) year in SQL query tuning, OLAP/OLTP data modeling, data mart building, ETL, BI server and reports;
(ii) five (5) years of experience in healthcare data analysis, data requirements, healthcare data warehouse and report building; (iii) any experience with Tech SME in Microsoft data server technologies including SQL server database, SSIS, SSRS, SSAS and T-SQL; and
(iv) any experience with Tech SME in one of the market leading BI tools, i.e., Microsoft, Micro Strategy, Business Object or Tableau.