High Level Job Summary
Provides, builds, and maintains data solutions to meet the needs of the enterprise. Supplies coding proof-of-concepts for IT and helps ensure those solutions can be scaled appropriately. Under limited direction, works within significant limits and authority on assignments of higher technical complexity and coordination. Possesses demonstrated technical knowledge and skills, including product and industry, reflective of successful progression through various job family levels. Provides guidance and assistance to lower-level associates and other functional areas.
Detailed Job Summary
In this role, you will assist in the design, maintenance and production of processes related to claims data. You will predominantly have responsibility performing advanced Teradata/SQL coding, Denodo development, and SSIS ETL. This team holds the organizational experts in claims data and have been tasked with building repeatable, automated processes for claims data on database servers they own and maintain. In this role, you will oversee database design, automated process flows, and best practices around data management and governance. An ideal candidate will enjoy working with SSIS, SQL Server, Teradata, Denodo, and have significant experience with SQL Server, SSIS, Teradata, Oracle, Db2, and have comfort with programming on their own.
High Level Responsibilities
Under limited direction, prototypes/develops data solutions of high complexity to meet the needs of the organization and business customers. Designs proof-of-concept solutions utilizing an advanced understanding of multiple coding languages to meet technical and business requirements, with an ability to perform iterative solution testing to ensure specifications are met. Designs and develops data solutions that enables effective self-service data consumption and can describe their value to the customer. Prioritize efforts based on customer value. Can set expectations for deliverables of high complexity. Works with IT to further enable data accuracy and capabilities. Maintains proof-of-concepts and prototype data solutions, and handles any assessment of their viability and scalability, with own team or in partnership with IT. Working with IT, assists in building robust systems focusing on long-term and ongoing maintenance and support. Ensures data solutions include deliverables required to achieve high quality data. Display a basic understanding of complex multi-tier, multi-platform systems, and applies principles of metadata, lineage, business definitions, compliance, and data security to project work. Has a strong understanding of Business Intelligence tools, including visualization and user experience techniques. Can set expectations for deliverables of high complexity. Demonstrates an understanding of new technologies as needed to progress initiatives.
The salary range posted reflects the range for the varying pay scale that encompasses each of the Liberty Mutual regions.
Specific Responsibilities
- Designs automated process flows of moderate complexity linking together multiple source systems to create useable output for analytics professionals using SSIS and SQL Server
- Writes and troubleshoots complex queries in Teradata and Denodo to provide new output and analyze existing output
- Maintains and monitors SQL Server activity, manages permission, and provides other SQL Server dba function to ensure SQL Server environment and databases are functioning appropriately
- Converts and upgrades SQL Server SSIS packages to new versions and platforms of technologies that support ETL
- Responsible for intake and triage of data questions including developing a process to clearly document and understand the frequency and type of these requests
- Produces recurring data that provide insight to senior level managers on book trends and movements
- Fields data related questions, especially on claims source systems, and other systems that the claims organization frequently interfaces
- Troubleshoots and solves problems when SSIS ETL processes fail
- Troubleshoots and solves problems with existing SQL queries
Job Results
Ensures SQL Servers are operating efficiently and appropriately. Ensures proper permissions are adhered to in SQL Server environment. Monitors SQL Server Agent Job success and ensures successful SLAs are met. Ensures the proper data is being provided by analyzing query accuracy and analyzes query efficiencies.
Job Specifications:
Reference: 2023-57884
Category: Data Science
Primary Location: Seattle, WA
Additional Locations: Remote
Schedule: Full-Time
Salary: USD $91,300.00 – $129,900.00 / Year
Education Level:
Travel: As Needed