SQL Server Database Developer

Company: Evolent Health
Location: Topeka
Posted on: June 20, 2022

Job Description:

**Your Future Evolves Here**Vital Decisions, a division of New Century Health and the newest addition to the Evolent Health portfolio.We help people facing serious health conditions advocate for the experience they want, feel in control of their medical choices, avoid chaos in a crisis, and improve the quality and value of the care they receive. As part of Evolent Health, we are on a bold mission to change the health of the nation by changing the way health care is delivered. Evolenteers make a difference wherever they are, whether it is at a medical center, in the office, or while working from home across 48 states. We empower you to work from where you work best, which makes juggling careers, families, and social lives so much easier. Through our recognition programs, we also highlight employees who live our values, give back to our communities each year, and are champions for bringing their whole selves to work each day. If you're looking for a place where your work can be personally and professionally rewarding, don't just join a company with a mission. Join a mission with a company behind it.**Why We're Worth the Application:**+ We continue to grow year over year.+ Recognized as a leader in driving important diversity, equity, and inclusion (DE) efforts (https://www.evolenthealth.com/diversity) .+ Achieved a 100% score two years in a row on the Human Rights Campaign's Corporate Equality Index making us a best place to work for LGBTQ+ equality.+ Named to Parity.org's 2020 list of the best companies for women to advance (https://www.evolenthealth.com/about-us/press-releases/8579/evolent-health-named-to-parity.org%E2%80%99s-best-companies-for-women-to-advance-list-2021) .+ Continued to prioritize the employee experience and achieved an 87% overall engagement score on our last employee survey.+ Published an annual DE report (https://dev.evolenthealth.com/sites/default/files-public/Evolent%20Health%202020%20DE%26I%20Annual%20Report.pdf) to share our progress on how we're building an equitable workplace.**What You'll Be Doing:**As Database Developer, your main responsibility is to build and maintain SQL code that supports all clinical and operational staff in their reporting needs, data structures, and system build/customization. This role involves working with large medical data sets (i.e. medical claims, eligibility data) as well as data derived from our internal client relationship management software (CRM). The Database Developer maintains strong skills in documenting requirements and an in-depth working knowledge of data models and how they interact .**Essential Duties and Responsibilities**+ Develop and maintain Tables, Stored Procedures, Views and Functions+ Write SQL queries, views or stored procedures to extract data from SQL Servers in a consistent and efficient manner that follows industry best practices+ Interpret existing complex SQL queries and stored procedures to reverse engineer existing code+ Make recommendations for improvements in reporting tools, techniques and processes+ Participate in efforts to analyze, design and migrate data as needed+ Code, optimize, and debug database queries and store procedures in MS SQL Server+ Develop and maintain an in-depth working knowledge of data models and how they interact+ Create and maintain SSIS ETL packages for data transformation, cleansing, and transfer; migrating them through environments for testing+ Maintain the EDI application, including ETL design, development, testing, and deployment activities effectively and efficiently while maintaining existing ETL code and developing new code using SSIS+ Become an expert on the companies many varied data sets and where they are derived from.+ Create and maintain SSRS reports and dashboards+ Create custom SSIS tasks using C#+ Perform custom Dynamics tasks using JavaScript**Education and Experience**Required:+ Bachelor's degree with significant coursework in computer science or related field strongly preferred; or equivalent combination of education and experience+ High level T-SQL abilities, including knowledge of execution plans and best indexing strategies+ High level SSIS and SSRS abilities+ 3+ years of experience working with healthcare data, preferably for a health plan, consulting firm, or a software vendor that offers data solutions to health plans+ Experience working with large medical claims and related data sets (834, 835, 837)+ Knowledge of Data Warehousing, relational database concepts and dimensional modeling principlesPreferred:+ Experience with SSAS+ Experience with MS Dynamics+ Experience with Azure+ Experience with analysis services+ Experience with Power BI**Knowledge, Skills & Abilities**+ Ability to QA and troubleshoot data issues+ Desire to continually learn and explore new database technologies+ Ability to understand problems from a broad perspective and gauge the potential impact of multiple solutions+ Excellent team-player attitude, with the ability to consistently demonstrate the highest levels of professionalism, integrity, mutual respect, and accountability to others+ Must be self-motivated, proactive, and able to work well under pressure+ Excellent time and priority management to support multiple concurrent initiatives and priorities+ Ability to think critically and analytically; be a proactive problem solver+ Comfortable with change and taking on new responsibilities, balancing conflicting prioritiesI may suggest a sentence or 2 on how this role is important to the business, and who this role interacts/collaborates with regularly.I'd recommend at least one bullet on effective communication (verbal and written)**Technical Requirements:**Currently, Evolent employees work remotely temporarily due to COVID-19. As such, we require that all employees have the following technical capability at their home: High speed internet over 10 Mbps and, specifically for all call center employees, the ability to plug in directly to the home internet router. These at-home technical requirements are subject to change with any scheduled re-opening of our office locations.Evolent Health is committed to the safety and wellbeing of all its employees, partners and patients and complies with all applicable local, state, and federal law regarding COVID health and vaccination requirements. Evolent expects all employees to also comply. We currently require all employees who may voluntarily return to our Evolent offices to be vaccinated and invite all employees regardless of vaccination status to remain working from home. Certain jobs require face-to-face interaction with our providers and patients in client facilities or homes. Employees working in such roles will be required to meet our vaccine requirements without exception or exemption.**Evolent Health is an equal opportunity employer and considers all qualified applicants equally without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran status, or disability status.**Compensation Range: The minimum salary for this position is $90000, plus benefits. Salaries are determined by the skill set required for the position and commensurate with experience and may vary above and below the stated amounts.

Keywords: Evolent Health, Topeka , SQL Server Database Developer, IT / Software / Systems , Topeka, Kansas