Sr. Data Analyst (Job Code: 1012)

Responsible for supporting the onboarding, ingestion, and transformation of structured and unstructured data into AWS cloud environments; work within the Product team to enable regulatory and statistical models across domains including Mortgage, Credit Card, and Auto; collaborate with Data Scientists, Architects, and cross-functional stakeholders to design, develop, and implement scalable data engineering workflows and transformation logic to ensure efficient data processing, validation, and delivery; assist in onboarding datasets from multiple sources into AWS by performing data analysis, profiling, and validation; perform data ingestion from various sources including databases and APIs; conduct data profiling and exploratory data analysis to identify trends, anomalies, and data quality issues; develop, optimize, and maintain data pipelines using Python and SQL to ensure scalability and performance; monitor data pipelines and workflows, troubleshoot failures, perform root cause analysis, and implement fixes to ensure data reliability and availability; contribute to migration efforts and data transformation initiatives across platforms such as AWS, Snowflake, and Databricks; support CI/CD processes including version control, deployment, and testing using Git and Agile methodologies; apply relational data modeling concepts including Star Schema, normalization, and key design, as well as AWS, Python, R, Pandas, PostgreSQL, Teradata, Snowflake, and data modeling tools to complete assigned tasks; interpret, review, and validate code; perform code reviews and resolve defects and performance issues; develop and support lightweight APIs and internal tools using Python-based frameworks including FastAPI and Swagger UI, to enable data access and workflow automation; automate data processing tasks using Python and SQL; utilize AI-assisted development tools including GitHub Copilot to enhance development efficiency; utilize and apply knowledge of Python, SQL, cloud platforms, data visualization, data warehousing, version control, relational data modeling, machine learning modeling, data ingestion, statistical data analysis/profiling, APIs, and Agile development methodologies to complete assigned tasks; leverage advanced analytics and emerging technologies, including machine learning techniques and large language models (LLMs), to support data modeling and automation initiatives; support data governance efforts including data quality, metadata management, and compliance; collaborate with stakeholders to translate business requirements into data-driven solutions; and document processes and workflows for maintainability and knowledge sharing.

Experience must include two (2) years use of all the following: Python, SQL, cloud platforms, data visualization, data warehousing, version control, relational data modeling, machine learning modeling, data ingestion, statistical data analysis/profiling, APIs, and Agile development methodologies.

Will also accept any suitable combination of education, training, and/or experience.

Salary: $145,600 per year (Benefits include medical, dental, vision, 401(k), STD/LTD, life insurance, and EAP)

Education: Bachelors - Data Science, Business Analytics, Data Engineering, or in a related field of study (will accept equivalent foreign degree).

Training: None

Experience: Five (5) years in the position above, as a Senior data Analyst, as a Trainee Decision Scientist, as an Associate Manager - Digital and Advanced Analytics, as a Lead Data Engineer, or in a related occupation.