Senior Software Engineer

In this role, you will:
Support assigned work efforts through all phases of the development, testing, and implementation life cycle, reviewing all requirements, creating test scenarios, developing test plans, analyzing results and testing/validating data
Reconcile multiple data sources and identify the root cause of discrepancies in expected output; distinguish between multiple root causes and/or multiple trends in a given data set and articulate results to various stakeholders, management, and technical resources
Analyze and test relational databases and investigate any data load failures or data retrieval issues
Monitor data warehousing systems based on assigned tasks to ensure reliability and accuracy of information loaded into the databases
Aid in defining and documenting requirements, communicating changes in scope or requires, to all stakeholders; initiate change management processes as required
Generate reports, dashboards, and ad hoc extracts for business and/or leadership
Ensure data integrity by implementing quality assurance practices, gathering, and entering missing data, and resolving any anomalies
Qualifications:
8+ years of experience in a Data Analysis, Business Analysis, Data Quality Assurance (or similar) role as part of a data warehouse team and supporting data-driven projects
Experience working with DBMS platforms, including a demonstrated understanding of table structures, hierarchies, joins, etc.
Advanced knowledge of SQL, with the ability to write and troubleshoot medium to advanced SQL queries
Knowledge of data warehousing methodologies and tools including their connection to systems both up and down stream
Bachelor s degree in Mathematics, Engineering, Computer Science, or a related discipline preferred
Prior experience within the insurance industry is a plus
Prior experience with Azure Synapse,Databricks,Python and/or Informatica Intelligent Cloud Services (IICS) is a plus

In this role, you will:
Support assigned work efforts through all phases of the development, testing, and implementation life cycle, reviewing all requirements, creating test scenarios, developing test plans, analyzing results and testing/validating data
Reconcile multiple data sources and identify the root cause of discrepancies in expected output; distinguish between multiple root causes and/or multiple trends in a given data set and articulate results to various stakeholders, management, and technical resources
Analyze and test relational databases and investigate any data load failures or data retrieval issues
Monitor data warehousing systems based on assigned tasks to ensure reliability and accuracy of information loaded into the databases
Aid in defining and documenting requirements, communicating changes in scope or requires, to all stakeholders; initiate change management processes as required
Generate reports, dashboards, and ad hoc extracts for business and/or leadership
Ensure data integrity by implementing quality assurance practices, gathering, and entering missing data, and resolving any anomalies
Qualifications:
8+ years of experience in a Data Analysis, Business Analysis, Data Quality Assurance (or similar) role as part of a data warehouse team and supporting data-driven projects
Experience working with DBMS platforms, including a demonstrated understanding of table structures, hierarchies, joins, etc.
Advanced knowledge of SQL, with the ability to write and troubleshoot medium to advanced SQL queries
Knowledge of data warehousing methodologies and tools including their connection to systems both up and down stream
Bachelor s degree in Mathematics, Engineering, Computer Science, or a related discipline preferred
Prior experience within the insurance industry is a plus
Prior experience with Azure Synapse,Databricks,Python and/or Informatica Intelligent Cloud Services (IICS) is a plus