Note: The job is a remote job and is open to candidates in USA. American Unit, Inc is seeking a Sr. Business Intelligence Analyst to join their Enterprise Business Intelligence group. This role focuses on advanced data analysis, source-to-target data mapping, and leading User Acceptance Testing (UAT), acting as a bridge between business stakeholders and technical teams to ensure data accuracy across reporting and cloud migration platforms.
Responsibilities
- Perform deep-dive data analysis using advanced SQL to evaluate source system structures, identify data patterns, and define business transformation rules. Author Functional Requirements Documents (BRDs) and Technical Specification Documents (TSDs)
- Drive end-to-end source-to-target data mapping, track data lineage, and ensure strict alignment with enterprise Data Governance and data catalog protocols
- Design, coordinate, and execute comprehensive User Acceptance Testing (UAT) strategies, test plans, and data validation scripts (including Alteryx/SQL validation) to verify pipeline output against client application and reporting tools
- Collaborate directly with cross-functional partners across Data Architecture, Cyber Security, PMO, Credit Risk, Finance, and Business Units within an Agile delivery framework
- Build and support ad-hoc SQL scripts, Alteryx workflows, and Power BI/Tableau reporting objects. Support ongoing cloud warehouse migrations (Snowflake)
Skills
- Proven expertise in Data Analysis, Data Mapping, and UAT Coordination/Execution
- Advanced hands-on SQL proficiency (complex queries, stored procedures, schema design, data masking concepts)
- Power BI or Tableau
- Alteryx (or similar data transformation tool)
- Python (for data movement/workflows)
- Snowflake
- Ability to lead independently, drive cross-departmental alignment, and operate effectively within an Agile team structure
- Financial Services or Banking background preferred
- Experience supporting Credit Risk Management or Lending systems is a plus
Company Overview