The Senior Software Engineer, Database Development will be a member of client's technology leadership team and will play a crucial role responsible for architecting and developing technical processes around data management to ensure success in terms of both revenue and timely release of current and next generation products and capabilities. The Senior Software Engineer, Database Development must be both operationally minded and strategic, for this position is responsible for executing the development of, and for driving the direction of capabilities to be competitive in the market and serve the diverse needs of its clients. This position will interface with virtually every element of the business and as a result, the individual who fills this position will need to be able to work well in a cross-functional and matrixed organization and be able to be both responsive to needs and thoughtful and directive in supporting and implementing the organization's Product capabilities.
Responsibilities:
· Lead the development of data retrieval and data management. Responsible for ensuring that the data assets of an organization are aligned with the organization in achieving its strategic goals. The architecture should cover databases, data integration and the means to get to the data
· Create logical and physical data models that support both opportunity assessment and population management initiatives
· Program in MS SQL server T-SQL and other related language to support application development around opportunity assessment and population health management initiatives
· Understand analytics and stratification as related to client's business model
· Let an application development IT shop run through the requirement, design, development, QA SDLC cycles with a focus on relational database technologies
· Lead aspects of our services based solutions and internal applications to ensure consistency, quality, architectural integrity, scalability, and availability
· Hands-on in designing and development of software solutions and software requirements related core components, foundational frameworks and SOA based services
· Help to resolve questions of program intent, software requirements, and inclusion of internal checks and controls
· Collaborates with team and business owners in the development and/or execution of all types of software development considering the objectives of the organization
· Participate in the full systems life cycle with solution design, development, implementation, and product support using scrum and other agile methodologies
· Maintain source-code repository, and participate in deployment of code into production
· Help explore and implement new technologies. Provides thought leadership in the areas of strategy and technology
· Develop software using known best practices with test driven development
· Participate in development process improvements of our continuous integrations services
· Communicates the status and forecasting of these projects to the internal clients through a variety of methods including project status reports
· Researches competitive online marketing presence/campaigns and maintains a pulse on industry trends and systems; bringing forth ideas that embrace emerging technology/executions and innovative ideas
· Produces and implements visual enhancements to existing designs as needed
Qualifications:
Required
· 7 or more years of experience in information technology
· Expert in T-SQL coding techniques (Stored Procedures and embedded SQL), and assist developers in tuning theirs
· Must have a strong understanding of the MS SQL Server database engine works, including but not limited to: Physical storage, indexing, physical database design best practices, and the Query Optimizer
· Demonstrated ability to create normalized and star-schema database schemas utilizing data modeling discipline. Understanding of normalization, de-normalization, and the difference between the two
· Ability to create schemas for both OLTP and OLAP databases
· Excellent written computer and oral communication skills
Preferred
· Understanding of various MS SQL Server features such as SSIS, SSAS, SSRS, XML, Service Broker, Full-Text, etc. and how they are used; Expertise in one or more would be a plus
· Proven track record in establishing strong relationships with clients and vendors
· Intense intellectual curiosity and an ability to view old problems with a fresh perspective
· Ability to attract, manage and develop staff of superlative quality
Education Requirements for the Position
The minimum qualification required for the performance of the above specialty occupation duties is a Bachelor’s Degree in Computer Science, Information Systems, or Engineering.