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 Python for ETL, API calls, log analysis, and rule-based actions, Power Automate to automate business processes (e.g., data ingestion, status updates, approval routing), Snowflake to clean, model, and store data for automation pipelines, and 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