Description:
Ally is seeking a Sr. Analyst - Data Management within Ally's Data Solutions Support team. The ideal candidate will have personal experience implementing data lakes, data analytics, and master data management solutions, including data ingestion, data homogenization - data preparation, data quality checking and management, structured and unstructured data processing, and analytics engineering.
Experience with modern self-service data capabilities, data management and governance, data modeling architecture is also a plus. Candidates having strong analytical skills, hands on development experience, strong SQL skills, ability to multi-task, and strong verbal and written communication skills will be best suited for the team.
The Work Itself
- Responsible for developing curated semantic layers for the auto business to support analytics engineering and AI product enablement
- Develop and maintain pipelines; partner with data engineering to deploy to Oracle and Snowflake.
- Apply data warehousing principles to design reliable, performant models.
- Extract and reconcile data from traditional and cloud warehouses for executive and operational insights.
- Create clean, tested, well-documented data layers to power AI use cases (Cortex search, agentic models).
- Validate AI outputs; curate a library of “Verified Queries” and enable fuzzy search via Cortex.
- Write and troubleshoot complex SQL; working knowledge of Python and dbt.
- Stay current on industry trends and lead data/analytics platform innovation.
- Collaborate cross-functionally to translate needs into tools, metrics, and visualizations.
- Operate within Agile; define/prioritize technical stories and manage multiple projects with clear status and risk communication.
- Metadata integration, quality checks, tags and other steps required to stand up a complete semantic layer that can be used as input for BI or AI products
- Able to do requirement gathering, documenting business metrics, lineage etc.,
Skills
The Skills You Bring
Minimum Qualifications:
- 3+ years of experience
- Bachelor's degree in Computer Science, Data Management, Data Science, Management Information System, Information Technology, or Business Analytics
Preferred Qualifications:
- 3+ years of relevant experience required, 5 years of relevant experience preferred.
- Bachelor's degree in Computer Science, Data Management, Data Science, Management Information System, Information Technology, or Business Analytics
- Strong organizational, analytical, and interpersonal skills
- RDBMS – Snowflake, Oracle, SQL Server
- Programming Languages/Tools - SQL, Python, DBT
- Data platforms - AWS, Snowflake, Oracle
- AI Models Claude, ChatGPT
- Data Governance - Alation, Collibra
- Knowledge about Snowflake Semantic, Cortex Products will be a plus