Industry: Information Technology - Data Architect/Analyst/Administrator
Type: Full Time
$84,860.00 - 126,040.00
The Database Analyst will work with a team of software developers to create and maintain a common code base for the Data Exchange platform, as well as support customer-specific implementation needs and will also be responsible for identifying improvements to the common platform, including architecting new solutions when necessary. The Database Analyst is responsible for designing and building mission-critical business logic in T-SQL, SSIS, C#. As a Senior Developer you will be expected to have a thorough understanding of the MS SQL server stack (2012/2014/2016/2017). You will be expected to design, develop and test complex data-driven business logic using T-SQL stored procedures, functions, views and tables. In-depth knowledge of performance tuning, data modeling and database design concepts are key aspects of this position. You will be expected to help analysts translate your data driven logic into user stories and work with other developers to implement your design concepts. Responsibilities:
Thorough understanding of the MS SQL server stack (2012/2014/2016/2017) with specific focus on the database engine and SSIS. SSRS and SSAS development skills a big plus, but not required.
Candidate must be fluent in T-SQL and SQL coding standards/best practices.
Ability to design and develop complex data-driven applications using stored procedures, functions, views, triggers, etc.
Ability to translate a design into user stories and work with other developers to implement your design concepts. Ability to take ownership of projects and act as a team lead/mentor for other developers.
Install and maintain SSRS portal and required data transformations.
Strong knowledge of performance tuning concepts (set theory, query design, index tuning etc.) and the ability to write efficient, highly performant code.
Strong knowledge of key data modeling and database design concepts (referential integrity, keys, data type usage, indexes etc.)
Strong knowledge of SSIS design, development and deployment concepts. Ability to develop new SSIS packages as well as maintain existing SSIS applications.
Excellent debugging skills with the ability to troubleshoot anything, anytime, anywhere.
Ability to function in a fast-paced Agile/SCRUM team focused on delivering new releases while also maintaining existing applications.
Adaptability to handle and gain knowledge on under defined/least-defined business requirements and produce valuable outcomes.
Be more autonomous, take complete control of the work in hand and work with necessary people to get what we want to achieve.
Healthcare domain knowledge is nice to have.
Perform capacity monitoring and management
Work with Enterprise DBA staff to design and manage server environment and infrastructure including physical layout, environment, backup/restore utilities, and monitoring.
5-10 years of understanding of the MS SQL server stack (2012/2014/2016/2017).
5+ years of expertise in T-SQL with the ability to design and develop complex data-driven applications and performance tuning concepts with the ability to write efficient, highly performant code.
5+ years of experience in production database support
Bachelor?s degree in Computer Science or Information Management Systems, or equivalent
Beacon Health Options is proud to be an Equal Opportunity and Affirmative Action Employer as well as a Drug Free and Tobacco Free Work Environment. EOE/AA/M/F/Veterans/Disabled At Beacon Health Options, our candidate's data privacy is a top priority. Our recruiting team conducts all communications using official company email [Click Here to Email Your Resum?] ). Only candidates who have applied for an open position through our Careers page (careers.beaconhealthoptions.com) will be engaged in our interview process. Beacon conducts all interviews in person or over the phone. At no time during the recruiting process will any Beacon recruiter request any financial or personally identifiable information from you. #LI #CB
Associated topics: data architect, data integrity, data scientist, etl, erp, hbase, mongo database, mongo database administrator, sybase, teradata