Are you ready to join a passionate community of people who are changing how health care is delivered? A place where you will find a career you love while truly making a difference building healthier communities. If this sounds like you, we would love to have you apply as SQL Server Data Warehouse Developer with Medical Home Network (MHN)!
MHN is a not-for-profit collaborative that has fundamentally changed how care is delivered. Our proven model of care unites provider communities and diverse healthcare entities around a common goal: to redesign healthcare delivery and transform the way care is managed.
THE PERKS
• challenging, and collaborative work environment with passionate colleagues that care deeply about healthcare delivery.
• as One of the Best Places to Work in Healthcare by Modern Healthcare.
• benefits program including Medical, Vision, Dental, HSA, FSA, and 401k.
• reimbursement, commuter benefits, and tuition assistance.
• work life benefits- Paid time off, sick time, and 12 paid holidays.
• For candidates local to Chicago we are working a hybrid schedule, 2 days on site 3 days remote.
• We are open to full remote in the following states, AK, AL, CA, FL, IN, MI, MO, NC, NM, NV, NY, OK, TX, WI
THE OPPORTUNITY:
MHN is seeking an experienced database developer to assist in our data modernization and optimization efforts. The Database Developer is responsible for delivering data warehouse, business intelligence, and operational data solutions by developing data integration and ETL processes, data quality and master data management solutions, and administration of SQL Server, and Azure SQL. This individual works closely with end users and IT development staff to ensure that new and existing data models and databases are consistent with approved MHN data architecture standards and HIPAA security requirements.
WHAT YOU CAN LOOK FORWARD TO:
• software/data solutions using SQL and Python.
• development, modification, and implementation of software and data applications in both our existing stack (SQL Server on Azure VM, Python on Azure Linux VM) and coding for our planned future state (Azure SQL, Azure Linux VM, Master Data Management, etc.)
• initiatives including data analysis, source-target mapping, data profiling, data quality, master data management, and performance tuning
• system performance trends and identify opportunities for improvement
• all programming changes and design, system modifications and their associated maintenance to all required applications
• and support production job schedules, including alerting, monitoring, break fixes, and performance tuning
WHAT YOU’LL NEED TO SUCCEED:
• knowledge of T-SQL (DML & DDL), Stored Procedures, Indexes, user defined functions, etc.
• degree in computer science or related field or 5 years equivalent experience
Python programming experience
• building/operating highly available, distributed systems of extraction, ingestion, and processing of large data sets both in near real time and batch processing.
• understanding of enterprise data hubs and data warehouses with deep experience in both types of environments
• knowledge of Linux and Windows VMs
• knowledge of Git, Bitbucket, or similar source code management software
• with a workload automation software package such as Active Batch
PREFERRED EXPERIENCE:
• knowledge of Azure, Azure SQL and serverless compute environments
• developing Restful APIs
• with NoSQL databases such as MongoDB
• developing data warehouses or data integration in a healthcare environment
• developing data warehouses and data marts (Kimball, Inmon design models)
• of self-service BI and reporting
• creating patient or provider web portals
• with HL7 data feeds
• of JIRA, Confluence and Bitbucket
• of database solutions and projects in Visual Studio with automated builds
Medical Home Network is an equal opportunity employer. We evaluate qualified applicants without regard to race, color, religion, age, sex, sexual orientation, gender identity, national origin, disability, veteran status, or any other protected characteristic. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.
Location: , , US
Offer Expires: 2024-11-17 14:00:29
Job Posting Language: en
Benefits:
- Dental Coverage
- Retirement Savings
- Health Insurance
- Paid Time Off
Qualifications:
- development, modification, and implementation of software and data applications in both our existing stack (SQL Server on Azure VM, Python on Azure Linux VM) and coding for our planned future state (Azure SQL, Azure Linux VM, Master Data Management, etc.)
- knowledge of T-SQL (DML & DDL), Stored Procedures, Indexes, user defined functions, etc
- degree in computer science or related field or 5 years equivalent experience
- Python programming experience
- knowledge of Linux and Windows VMs
- knowledge of Git, Bitbucket, or similar source code management software
- with a workload automation software package such as Active Batch
Responsibilities:
- The Database Developer is responsible for delivering data warehouse, business intelligence, and operational data solutions by developing data integration and ETL processes, data quality and master data management solutions, and administration of SQL Server, and Azure SQL
- all programming changes and design, system modifications and their associated maintenance to all required applications
- and support production job schedules, including alerting, monitoring, break fixes, and performance tuning
Benefits:
- challenging, and collaborative work environment with passionate colleagues that care deeply about healthcare delivery
- benefits program including Medical, Vision, Dental, HSA, FSA, and 401k
- reimbursement, commuter benefits, and tuition assistance
- work life benefits- Paid time off, sick time, and 12 paid holidays
- For candidates local to Chicago we are working a hybrid schedule, 2 days on site 3 days remote
- system performance trends and identify opportunities for improvement
LinkedIn: Apply Here
Jobilize: Apply Here