Automation Data Engineer

Title: Business Analyst IV – Automation Data Engineer Location: Detroit, MI / Charlotte, NC / Lewisville, TX (3-days onsite, 2-days remote Hybrid schedule) Note: This is a W2 contract role – C2C and 3 rd party candidates will NOT be considered The Business Analyst IV will; · Partner with wider business teams to identify automation opportunities in manual or high-effort areas (e.g., reporting, data validation, system monitoring) · Learn and internalize how key systems operate — particularly Loan Origination Systems (LOS) and supporting platforms used across Auto Credit Operations · Design and implement automated workflows using o Python for ETL, API calls, log analysis, and rule-based actions o Power Automate to automate business processes (e.g., data ingestion, status updates, approval routing) o Snowflake to clean, model, and store data for automation pipelines o Power BI to create dynamic dashboards that visualize system health, process performance, and operational metrics · Take ownership of existing automation workflows during onboarding — including inherited scripts, dashboards, and processes · Collaborate with IT teams for access, security reviews, and compliance requirements · Document requirements, track progress, and manage deliverables using JIRA and Confluence, aligning with partner team practices (including sprint planning and backlog grooming) · Troubleshoot issues in automated systems — diagnosing root causes in data flow, logic, or integration points The ideal candidate for this role is a proactive problem-solver with a strong technical foundation in Python and data automation. The ideal candidates will thrive in collaborative environments, translating business needs into efficient, automated workflows. They will also be detail-oriented, comfortable working in Agile settings, and capable of owning processes end-to-end, demonstrating adaptability, clear communication, and a passion for improving operational efficiency through technology. Position Qualifications: · 2-5 years of experience as a Business Analyst, with proven delivery of automation or process improvement initiatives · Proven proficiency in at least one scripting/automation language, including Python for building data pipelines and automating workflows · Experience working with data in Snowflake (SQL + Python) to transform raw inputs into usable datasets, including Snowflake · Hands-on experience creating reports and dashboards using Power BI, including handling complex or unstructured source data · Proven experience working directly with business teams to understand needs, define automation opportunities, and deliver solutions — including ongoing maintenance, refinement, and support · Ability to build trust through clear communication, active listening, and consistent delivery · Demonstrated success in translating ambiguous or evolving business requirements into reliable, automated workflows that are adopted and used over time · Comfortability operating in Agile environments, using JIRA for task management and Confluence for documentation · Excellent written and oral presentation skills, with the ability to partner with and influence stakeholders · Proficiency in Microsoft Office applications (Excel, Access, PowerPoint) · Experience in financial services or auto lending, particularly within credit operations or loan origination workflows preferred · Exposure to compliance-driven environments preferred · Experience automating business processes using Power Automate or similar tools (e.g., UIPath, Automation Anywhere) preferred · Exposure to integrating AI models via API — especially for tasks like log analysis or report drafting – preferred · Understanding of prompt engineering basics for guiding consistent output from generative tools (e.g., internal LLMs) preferred · Experience with low-code/no-code automation platforms in a business context preferred · Familiarity with internal systems used in auto lending — especially Loan Origination Systems (LOS) and related platforms – preferred · Understanding of business dynamics in credit operations, such as decisioning, underwriting workflows, compliance reporting, system uptime tracking, etc. preferred · A minimum of a Bachelor’s Degree in a relevant technical field; relevant industry data analytic or automation-related Certifications preferred Note: This is a W2 contract role – C2C and 3 rd party candidates will NOT be considered