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 processesCollaborate with IT teams for access, security reviews, and compliance requirementsDocument 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 pointsThe 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 initiativesProven proficiency in at least one scripting / automation language, including Python for building data pipelines and automating workflowsExperience working with data in Snowflake (SQL + Python) to transform raw inputs into usable datasets, including SnowflakeHands-on experience creating reports and dashboards using Power BI, including handling complex or unstructured source dataProven experience working directly with business teams to understand needs, define automation opportunities, and deliver solutions — including ongoing maintenance, refinement, and supportAbility to build trust through clear communication, active listening, and consistent deliveryDemonstrated success in translating ambiguous or evolving business requirements into reliable, automated workflows that are adopted and used over timeComfortability operating in Agile environments, using JIRA for task management and Confluence for documentationExcellent written and oral presentation skills, with the ability to partner with and influence stakeholdersProficiency in Microsoft Office applications (Excel, Access, PowerPoint)Experience in financial services or auto lending, particularly within credit operations or loan origination workflows preferredExposure to compliance-driven environments preferredExperience automating business processes using Power Automate or similar tools (e.g., UIPath, Automation Anywhere) preferredExposure to integrating AI models via API — especially for tasks like log analysis or report drafting – preferredUnderstanding of prompt engineering basics for guiding consistent output from generative tools (e.g., internal LLMs) preferredExperience with low-code / no-code automation platforms in a business context preferredFamiliarity with internal systems used in auto lending — especially Loan Origination Systems (LOS) and related platforms – preferredUnderstanding of business dynamics in credit operations, such as decisioning, underwriting workflows, compliance reporting, system uptime tracking, etc. preferredA minimum of a Bachelor’s Degree in a relevant technical field; relevant industry data analytic or automation-related Certifications preferredNote : This is a W2 contract role – C2C and 3 rd party candidates will NOT be considered