Company Details

Berkley Medical Management Solutions (BMMS) provides a different kind of managed-care service for W.R. Berkley Corporation. We believe focusing on an injured worker’s successful and speedy return to work is good for people and good for Berkley’s insurance operating units. BMMS was first started in 2014 by reimagining the relationship between medical need and technology as a way to deliver the best outcome for injured workers and Berkley’s operating units. Our goal was clear: combine solid clinical practices, proven return-to-work strategies and robust software into one system for seamless management of workers’ compensation cases.

To get it right, we started with a flexible technology platform that allowed for impressive customization without sacrificing the ability for expansion and continued innovation. We deploy integrated systems to give W.R. Berkley Companies recommendations and professional services for managing each individual case in an efficient and appropriate manner. The power of our technology takes medical bill-review services and clinical advisory services to a new level. Our unique marriage of technology, software platforms, data analytics and professional services ensures we provide Berkley’s operating units with reliable results, and reduced time and expenses associated with case management.

Responsibilities

As a Data Engineer, you’ll have the opportunity to be on the forefront of driving a major transformation within our organization. You will be responsible for expanding and optimizing data, the data pipeline architecture, the data flow and collection for cross functional teams. As a crucial part of the business, you will guide and support our software developers, data analysts on business initiatives while ensuring optimal data delivery architecture is consistent. Whether it’s working on a solo project or with the team, you are self-directed and comfortable supporting the data needs of multiple teams, systems, and products.

• Participates in requirements analysis
• Create and maintain optimal data pipeline architecture
• Assemble large, complex data sets that meet functional/non-functional business requirements
• Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery/ dataOps
• Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL
• Build analytics tools that utilize the data pipeline to provide actionable insights into customer acquisition, operational efficiency, and other key business performance metrics
• Collaborates with internal teams to produce software design and architecture
• Write clean, scalable code using C# and JavaScript
• Revise, update, refactor and debug code
• Code enhancements to existing software applications and provide technical support
• Develop documentation throughout the software development life cycle (SDLC)
• Demonstrate the use of tact and discretion in all communications and provide a positive contribution to the morale of the department
• Establish and maintain effective working relationships with unit staff, clients, providers, and other departments

Qualifications

Core Competencies

• Action Oriented
• Active Learning
• Integrity
• Technically Astute
• Critical Thinking

Skills and Experience

• 3 years of experience as a SQL Developer
• Experience in developing new SQL code in Microsoft SQL server as part of ETL processes.
• Ability to develop and improve stored procedures functions using T-SQL and Dynamic SQL
• Must have in-depth experience with SQL Server, SSIS, SQL Agent, Data Warehousing, ETL/ELT 
• Build reports and dashboards using SSRS and Microsoft PowerBI
• Experience with Azure cloud architecture, azure stack including Data factory, Databricks, Synapse and ADLS Gen2
• Experience with predictive analytics: Python knowledge is preferred.
• Familiarity with Agile environments
• Troubleshooting abilities
• Good communication skills 

Education 

• Bachelor’s degree in Computer Science, Software Engineering or relevant field

Travel Requirements

• Low level of domestic U.S. travel is required (5% - 10% of time)

Additional Company Details

We do not accept unsolicited resumes from third party recruiting agencies or firms. The company offers a competitive compensation plan and robust benefits package for full time regular employees which for this role include: • Benefits: Health, Dental, Vision, Life, Disability, Wellness, Paid Time Off, 401(k) and Profit-Sharing plans. The actual salary for this position will be determined by a number of factors, including the scope, complexity and location of the role; the skills, education, training, credentials and experience of the candidate; and other conditions of employment. The Company is an equal employment opportunity employer.

Additional Requirements

While performing the duties of this job, the employee is regularly required to be seated for sustained periods of time; be able to use a keyboard; pick-up, pinch, or twist objects; must be able to communicate information accurately; distinguish sounds at normal levels and be able to receive information orally. The employee is occasionally required to move about the office to accomplish tasks; reach in any direction; raise or lower objects or move objects from place to place; and hold onto objects. Occasionally, the employee may need to move or exert force up to ten (10) pounds. The employee is regularly required to operate a computer and other office equipment, including a phone, copier and printer.

Sponsorship Details

Sponsorship Offered for this Role