SQL Developer/Programmer or Senior SQL Developer/Programmer*
(Job #493609) Technology Innovation Team
*Position title will be determined based upon the candidate’s qualifications.
The Hilltop Institute at UMBC is seeking a SQL Developer/Programmer or Senior SQL Developer/Programmer to join its Technology Innovation team. Hilltop uses a data-driven approach to inform key state and federal policymakers on health care financing and delivery system reform in Maryland and other states. Hilltop’s Technology Innovation team has developed several Medicaid Management Information System (MMIS)-based applications, including the DataPort, a business intelligence and reporting platform for use by health care policy decision makers. Clients include the Maryland Department of Health, the Maryland Health Care Commission, the Developmental Disabilities Administration, and the Health Services Cost Review Commission, as well as the federal government and Medicaid agencies in other states.
This is a new position created to address Hilltop’s expanding portfolio of work and ensure our data infrastructure can support a growing workload. The incumbent will be responsible for completing advanced SQL development projects to support teams of data analysts, visualization experts, and predictive modelers. They will develop and manage a suite of extract, transform, load (ETL) processes to organize and automate our existing and future data repositories and to respond to ad hoc analytics requests on pressing questions in health policy. The individual should be an excellent communicator, working closely with policy analysts, SAS programmers, and project managers to effectively operationalize our data infrastructure.
The incumbent will assume a prominent role in the growth of Hilltop’s Data and Visualization group. Specific duties include but are not limited to the following:
- Develop and manage ETL processes that organize Hilltop’s data warehouse for use in data analytics and visualization platforms
- Lead SQL database infrastructure development projects
- Construct ETL processes between SQL databases and external data sources
- Use SQL Server Integration Services (SSIS), T-SQL, SQL Agent jobs, and stored procedures to automate and add auditing/QC functionality to existing processes
- Perform SQL-native ad hoc data requests within systems such as Hilltop’s Master Analytic Database (MAD) that supports the DataPort and other applications, and LTSSMaryland, an information system that supports Medicaid long-term services and supports
- Collaborate with the Hilltop Programming Operations team to advise on database development, querying, and reporting requirements
- Act as a liaison to UMBC’s Department of Information Technology (DoIT) for automating operational infrastructure
- Assist with the monitoring and maintenance of group and user privileges in Hilltop applications and databases
- Assist in establishing and implementing protocols related to promotion of databases through environments from Sandbox/Dev to Production
- Work closely with the Manager of Technical Innovation and Automation and Visualization Developers to automate data feeds and reports
- Perform other duties as assigned
Requires a master’s degree in computer science, information systems, or a related field and one year of relevant experience, or a bachelor’s degree in computer science, information systems, or a related field with three years of relevant experience.
Senior SQL Developer/Programmer
Requires a master’s degree in computer science, information systems, or a related field and five years of relevant experience, or a bachelor’s degree in computer science, information systems, or a related field with seven years of relevant experience. A PhD in computer science, information systems, or a related field and two years of relevant experience may substitute for the master’s degree and five years of experience.
For Both Positions
Must have minimum of two years hands-on experience in Microsoft SQL Server including database and ETL development with a strong understanding of database structures, theories, principles, and practices. This should also include experience with star schemas, SSIS/SQL Agent Job/stored procedure creation, as well as T-SQL programming. Must have strong analytical and effective communications skills (both verbal and written) and the ability to work in multidisciplinary project teams.
The ideal candidate will possess the following professional and interpersonal competencies: experience with data modeling; experience with Tableau® or similar reporting platforms; programming skills in SAS; the ability to work with large databases and on a variety of platforms; experience in building automated processes to extract, transform, and load large data sets, preferably health/HIPAA-protected data sets; experience with Agile software development methodology; a knowledge of publicly funded health insurance programs such as Medicare and Medicaid; and well-honed problem solving skills.
Compensation and Benefits
Salary is commensurate with qualifications and experience. The position is full-time, offers opportunity for professional growth, and includes the full university benefits package, including tuition remission for qualified candidates. Note: this is a grant-funded position wherein employment is contingent upon the renewal of the grant.
While this position is onsite at The Hilltop Institute’s offices located on the UMBC campus, options for part-time telework/remote work are available.
Resumes will be accepted until the position is filled, but for best consideration, submit a cover letter (indicating Job #493609), resume, and the contact information for three professional references by February 18, 2022, to the SQL Developer/Programmer Search Committee at:
email@example.com (MS Word or PDF attachments required) *
*Note: The cover letter, resume, and references should be included in separate attachments.
As required by the 1986 Immigration Act, be prepared to present acceptable documentation upon hire showing your identity and that you are a U.S. citizen or an alien who is authorized to work.
UMBC is an Equal Opportunity/Affirmative Action Employer and actively seeks the applications of minorities, women, Veterans and individuals with disabilities.
As an institution that receives federal financial assistance, UMBC adheres to Title IX and does not discriminate on the basis of sex. Information about Title IX and contact information for the Title IX Coordinator is available at: https://oei.umbc.edu/
January 28, 2022