TrueScripts is looking for an Application Developer to help create, maintain, load, and analyze data related to prescription claims. This role will provide methods to help other teams generate actionable insights, ultimately aiming to lower prescription drug spending, achieve clinically effective outcomes, and deliver Amazing Care.
Requirements
- At least 3 years of professional experience working with C-Sharp and SQL Server.
- Proficiency with the following languages and frameworks: SQL, C-Sharp, PowerShell, HTML, CSS, Bootstrap, jQuery, Vue.js.
- Experience in developing secure enterprise web applications and APIs, both internal and external.
- Familiarity with database design concepts such as Star Schema, Snowflake Schema, and Slowly Changing Dimensions.
- Experience with or willingness to learn OpenID Connect and Azure B2C authentication.
- Competence in data transformation and managing data ingress/egress for sharing with external parties.
- Ability to assess and utilize MS Azure platforms and services for solution implementation.
Responsibilities
- Develop and manage secure websites and APIs for data transfer
- Design and maintain SQL Server tables in Azure cloud
- Create star and snowflake schemas in SQL Server
- Build and deploy SSIS packages for ETL processes
- Write stored procedures for data aggregation and exports
- Monitor and debug daily data jobs
- Manage Azure Data Factory pipelines, Functions, and Logic Apps
Other
- A future team members' values need to align with TrueScripts' core values of Integrity, Respect, Innovation, and Service.
- Our culture is positive, and our people possess a ‘can do, proactive attitude.
- Honesty and transparency are the foundation that we build upon.
- Exceptional problem-solving skills, analytical thinking, and attention to detail.
- A strong emphasis on security in all projects.
