Report this Job
Why MMIT? At MMIT, we simplify the complexities of healthcare to smooth access to life saving therapies. Our collective teams achieve this through prioritizing cultivating industry leading data coupled with cutting edge technology to solve some of healthcares most complex challenges.
MMIT is regarded as a trusted go-to-market partner that identifies barriers to patient access and helps coordinate major stakeholders to move therapies from pipeline to prescriptionanswering the what of how payers cover therapies and the why behind those decisions. MMITs product portfolio has been built by listening to our clients, and with expert teams of pharmacists, clinicians, data specialists and market researchers who provide foresight, clarity and confidence.
In 2022, MMIT joined forces with other market-leading pharmaceutical-solutions providersEvaluate, Citeline, PanalgoandThe Dedham Groupto launchNorstella, which aims to deliver must-have answers for critical strategic and commercial decision-making along the entire drug development journey.
This full-time position will play a critical role supporting MMITs applications. Primary responsibilities will be to analyze, design, develop, implement and maintain technical solutions SSIS and T-SQL.
As a SQL Developer, you will:
- Design, code and test programs using the Microsoft SQL Server platform.
- Create business logic, reports, exports and other data related output.
- Learn continuously, manage your work independently and seek guidance from senior developers when needed.
- Use best practice coding standards in a fast-paced and agile environment.
- Works in a team environment that includes collaborating with Product Owners, Stakeholders, and Software Developers.
- Other duties as assigned.
Requirements
- Bachelors degree or higher in technology field or related field preferred.
- 3-5 years of practical experience with SSIS, SQL, T-SWL
- Practical experience with Microsoft SQL Server platform, and Transact SQL stored procedures and triggers
- Experience with SSIS development and SSRS reports (preferred)
- Interest in working with complex data sets and analytic technologies such as Power BI
- Ability to create Functions/Views/Stored Procs.
- Experience with complex queries including use of CTEs, table variables, merge and dynamic SQL.
- Experience with complex business logic including applying logic to transforms that falls outside of basic schema formatting conversion.
- Experience executing SSIS packages via SQL Server Job Agent
- Experience using all components available in SSIS including sorts, derived values, data conversion, multicast, merge, union, variables, parameters, package DB connections, project DB connections, flat file connections, excel connections and SMTP connections, expressions and file system tasks.
- Data processing on Azure services (Azure Data Lake, Azure Storage, Azure SQL, Azure DW)
- Working knowledge of Azure Synapse and/or Snowflake
The guiding principles for success at Norstella:
01: Bold, Passionate, Mission-First
We have a lofty mission to Smooth Access to Life Saving Therapies and we will get there by being bold and passionate about the mission and our clients. Our clients and the mission in what we are trying to accomplish must be in the forefront of our minds in everything we do.
02: Integrity, Truth, Reality
We make promises that we can keep, and goals that push us to new heights. Our integrity offers us the opportunity to learn and improve by being honest about what works and what doesnt. By being true to the data and producing realistic metrics, we are able to create plans and resources to achieve our goals.
03: Kindness, Empathy, Grace
We will empathize with everyone's situation, provide positive and constructive feedback with kindness, and accept opportunities for improvement with grace and gratitude. We use this principle across the organization to collaborate and build lines of open communication.
04: Resilience, Mettle, Perseverance
We will persevere even in difficult and challenging situations. Our ability to recover from missteps and failures in a positive way will help us to be successful in our mission.
05: Humility, Gratitude, Learning
We will be true learners by showing humility and gratitude in our work. We recognize that the smartest person in the room is the one who is always listening, learning, and willing to shift their thinking.
Benefits
- Medical and prescription drug benefits
- Health savings accounts or flexible spending accounts
- Dental plans and vision benefits
- Basic life and AD&D Benefits
- 401k retirement plan
- Short- and Long-Term Disability
- Education benefits
- Maternity leave
- Paid parental leave
- Paid time off
The expected base salary for this position ranges from $95,000 to $120,000. It is not typical for offers to be made at or near the top of the range. Salary offers are based on a wide range of factors including relevant skills, training, experience, education, and, where applicable, licensure or certifications obtained. Market and organizational factors are also considered. In addition to base salary and a competitive benefits package, successful candidates are eligible to receive a discretionary bonus.
Norstella is an equal opportunities employer and does not discriminate on the grounds of gender, sexual orientation, marital or civil partner status, pregnancy or maternity, gender reassignment, race, color, nationality, ethnic or national origin, religion or belief, disability or age. Our ethos is to respect and value peoples differences, to help everyone achieve more at work as well as in their personal lives so that they feel proud of the part they play in our success. We believe that all decisions about people at work should be based on the individuals abilities, skills, performance and behavior and our business requirements. MMIT operates a zero tolerance policy to any form of discrimination, abuse or harassment.
Sometimes the best opportunities are hidden by self-doubt. We disqualify ourselves before we have the opportunity to be considered. Regardless of where you came from, how you identify, or the path that led you here- you are welcome. If you read this job description and feel passion and excitement, were just as excited about you.
MMIT
