Application Developer at TrueScripts Management Services

We need one to Design, build and manage SQL Server tables in the Azure cloud

Requirements:

What you’re made of

The bold requirements

• Bachelor’s Degree in Computer Science and/or similar field of study
• Minimum 3 years of professional experience working with C# and SQL Server
• Experience with the following languages and frameworks: SQL, C#, PowerShell, HTML, CSS, Bootstrap, jQuery, Vue.js
• Experience developing secure enterprise web applications and APIs (internal and external)
• Experience with database design concepts: Star Schema, Snowflake Schema, Slowly Changing Dimensions
• Experience with or ability to learn OpenID Connect and Azure B2C authentication
• Strong Microsoft Excel skills required
• Experience with or ability to learn the creation of Power BI reports allowing for others to review the operational statistics and logs of our internal systems and processes
• Knowledge of transactional processing or general accounting helpful
• Exceptional problem solving, analytical thinking, and attention to detail
• A focus on security with every project
• Ability to assess and learn MS Azure platforms and services to implement solutions
• Ability to multi-task and prioritize in an ever-changing environment
• Ability to work in an open team environment or remotely and be a team player with all levels of staff and management

Description:

Looking for something BETTER? So were we! That’s why TrueScripts was created.

But “better” didn’t stop there. That’s why we’re now looking for YOU!

What we're about

TrueScripts Management Services is a pharmacist-founded, fully transparent Prescription Benefit Manager that has been revolutionizing the PBM industry since 2014. Our mission is to build lasting relationships by providing prescription benefit expertise at a personal and customized level to ensure optimum value at the lowest possible cost. We are committed to lowering prescription drug spending, achieving clinically effective outcomes, and always delivering Amazing Care.

Did we mention Amazing Care? Good! Because this is so much more than just our tagline. It is the foundation upon which our business was built. We believe that Amazing Care starts from within, and our culture is reflective of this philosophy. And there is a reason that our company was just named the #1 Best Place to Work (for medium-sized employers) in Indiana!

Our team members enjoy:

• Robust benefits and a strong salary
• Employee Assistance Program
• Wellness Program
• Dream Manager Program (yes, it’s a real thing!)
• A cohesive, family-based culture
• Charitable contributions
• Lots of celebrations!

Ok, enough about us. Here’s what we need from you:

What you’ll do

In a few words

The Application Developer is responsible for website development, scheduled job creation, and system integration development. Additionally, this position will participate in requirements gathering, production support, debugging, log file analysis, source code repository maintenance, technology research, and project planning.

The fundamentals for the job

TrueScripts Management Services provides prescription benefit management expertise at a personal and customized level to ensure optimum value at the lowest possible costs for clients all around the US. The IT and Data Analytics team will deal with prescription claims and will analyze, pre-process the data, and apply data mining techniques to provide actionable insights.

• Build and manage secure websites and APIs to facilitate the transfer of data to partners and clients.
• Design, build and manage SQL Server tables in the Azure cloud
• Analyze data structures to design and build star schemas and snowflake schemas in SQL Server
• Design, build and deploy SSIS packages to perform ETL into SQL Server
• Create stored procedures to aid in the aggregation of data, data loads, and data exports
• Monitor and debug daily scheduled jobs that load and export data
• Create and support Azure Data Factory pipelines
• Create and manage Azure Functions
• Create and manage Azure Logic Apps
• Create and support Microsoft Dynamics 365 CRM business process flows and UI development
• Work with other developers and stakeholders to gather requirements and complete projects
• Work closely with business users in the Clinical Care, Account Management, and Finance divisions to improve processes that make the business run more efficiently

Requirements:

What you’re made of

The bold requirements

Bachelor’s Degree in Computer Science and/or similar field of study

Minimum 3 years of professional experience working with C# and SQL Server

Experience with the following languages and frameworks: SQL, C#, PowerShell, HTML, CSS, Bootstrap, jQuery, Vue.js

Experience developing secure enterprise web applications and APIs (internal and external)

Experience with database design concepts: Star Schema, Snowflake Schema, Slowly Changing Dimensions

Experience with or ability to learn OpenID Connect and Azure B2C authentication

Strong Microsoft Excel skills required

Experience with or ability to learn the creation of Power BI reports allowing for others to review the operational statistics and logs of our internal systems and processes

Knowledge of transactional processing or general accounting helpful

Exceptional problem solving, analytical thinking, and attention to detail

A focus on security with every project

Ability to assess and learn MS Azure platforms and services to implement solutions

Ability to multi-task and prioritize in an ever-changing environment

Ability to work in an open team environment or remotely and be a team player with all levels of staff and management