SQL Developer

Why MMIT? At MMIT (https://www.mmitnetwork.com/), we provide our healthcare clients with a transparent, structured view of complex drug coverage information. We are a company that values:

•      Collaborative teams focused on meeting goals and delivering value
•      Continuous learning and opportunity to grow

We answer the “what” and the “why” related to drug coverage and reimbursement, leveraging technology, research and industry experts to make sense of how and why specific pharmaceutical drugs are covered. Physicians and pharmacies use our data and applications to understand what drugs are available to patients and how they are covered by health plans. Pharmaceutical manufacturers trust our data to understand how their drug and competitive drugs are covered, which helps forecast performance and tune strategy.

This full-time position will play a critical role supporting MMIT’s 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.

• Work in a team environment that includes collaborating with Product Owners, Stakeholders, and Software Developers.

• Bachelor’s 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 Scala fundamentals and  Databricks

All your information will be kept confidential according to EEO guidelines.