Sr. Data Analyst

Arch Capital Group Ltd. - Greensboro, NC

Full-time - Mid Level

Greensboro, NC

Insurance Carriers and Related Activities

About the position

With a company culture rooted in collaboration, expertise, and innovation, Arch Mortgage aims to promote progress and inspire its clients, employees, investors, and communities to achieve their greatest potential. The mission of the Arch Mortgage Data, Reporting, and Insights team is to unlock the power of data through insightful reporting and analytics, empowering stakeholders to confidently make data-driven decisions. The team strives to deliver accurate, timely, and actionable insights that drive business growth and success while continuously innovating and pushing the boundaries of what's possible in reporting and data analytics. In this role, you will be responsible for collecting, cleaning, and preparing data for analysis. This includes aggregating data, creating new variables, normalizing data, and splitting data into training and testing sets. You will need to source data from various platforms, including databases, APIs, websites, surveys, and third-party providers. Additionally, you will prepare standard reports in a timely manner for stakeholders, ensuring that the data is complete and accurate while providing clear analysis. You will also build, optimize, and maintain data pipelines to ensure data integrity and availability for analysis. Developing data models, custom scripts, and specialized tools/applications to enhance data processing and analysis capabilities will be part of your responsibilities. Conducting advanced statistical analyses, such as regression testing and trend evaluations, will help derive actionable business insights. As a subject matter expert in one or more business domains, you will partner with stakeholders to develop tailored data-driven insights and create visualizations that tell a clear and compelling story, highlighting key insights and making complex data more understandable to stakeholders. Moreover, you will utilize version control systems, such as Git, to manage changes to analysis scripts and documentation, ensuring that updates are tracked and previous versions can be retrieved if necessary.

Responsibilities

• Collect, clean, and prepare data for analysis, including aggregating data and creating new variables.
• Prepare standard reports in a timely manner for stakeholders, ensuring data completeness and accuracy.
• Build, optimize, and maintain data pipelines to ensure data integrity and availability for analysis.
• Develop data models, custom scripts, and specialized tools/applications to enhance data processing and analysis capabilities.
• Conduct advanced statistical analyses and trend evaluations to derive actionable business insights.
• Act as a subject matter expert in one or more business domains and partner with stakeholders to develop tailored data-driven insights.
• Create visualizations that highlight key insights and make complex data more understandable to stakeholders.
• Use version control systems to manage changes to analysis scripts and documentation.

Requirements

• High proficiency in programming with analytical tools/languages (i.e. SQL, Python, SAS).
• Experience with cloud-based platforms (i.e. Azure, AWS, GCP) and technologies (e.g., Databricks, ADF).
• Proficient with BI and Data Visualization tools (i.e. Power BI).
• Broad analytical, problem-solving, and organizational skills.
• Working knowledge of database management systems (i.e., architecture, data storage, security).
• Ability to connect business processes and procedures to day-to-day activities.
• Proven track record of working independently under tight schedules and prioritizing multiple work assignments.
• Vast interpersonal and communication skills.
• Experience with collaboration and productivity tools like Confluence, Asana, and Microsoft Teams.