Sr. Data Analyst (Business Transformation, SQL, Commercial Lending Reporting)

Why work at OpTech?

OpTech is a woman-owned company that values your ideas, encourages your growth, and always has your back. When you work at OpTech, not only do you get health and dental benefits on the first day of employment, but you also have training opportunities, flexible/remote work options, growth opportunities, 401K and competitive pay. Apply today!

Title: Business Transformation Analyst

Location: Frisco, TX or Farmington Hills, MI, Auburn Hills, MI or Remote for those out of commutable distance to previous locations. For those in commutable range - 2 days a week hybrid onsite is required.

Job Summary:

We are seeking a Business Transformation Analyst with strong SQL and analytical skills to support our transformation initiatives across commercial and financial lending reporting systems. This role is ideal for someone who enjoys investigative work digging deep into undocumented systems, understanding legacy data flows, and reverse-engineering SQL queries to support system changes and business improvements.

Key Responsibilities:

• Perform forensic-level data analysis using SQL to understand existing system behavior and reporting logic.
• Analyze and interpret SQL scripts from legacy and active reports to determine the impact of system and business changes.
• Work closely with a small team (2 3 people) to drive business transformation initiatives in a collaborative and agile environment.
• Investigate undocumented system data and processes to map out current-state data flows and transformations.
• Recommend changes to reporting logic and SQL based on business needs and transformation objectives.
• Liaise with stakeholders in commercial and financial lending to ensure analytical outputs align with business requirements.
• Document findings and contribute to the creation of sustainable documentation for long-term system understanding.

Qualifications & Skills:

• Strong proficiency in SQL, with proven experience performing deep-dive analysis on complex or undocumented datasets.
• Demonstrated experience in data forensics or reverse-engineering of data/report logic.
• Experience working with financial or commercial lending data and reporting systems.
• Strong analytical thinking and problem-solving skills with a detail-oriented mindset.
• Excellent communication skills and the ability to convey technical insights to non-technical stakeholders.
• Comfortable working in ambiguous environments and navigating undocumented systems.

Preferred Experience:

• AFS Vision experience
• Prior experience in business transformation or data migration projects.
• Familiarity with reporting tools and environments (e.g., SSRS, Tableau, Power BI, etc.).
• Experience in regulated industries or financial services is a strong advantage.

OpTech is an Equal Opportunity Employer (EOE), all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.