POSITION SUMMARY:
The Senior Business Analyst Data Engineering analyzes the data requirements and technical needs of the Company's most complex functional business areas within ***, providing recommendations on data solutions, architecture decisions, and data strategy. As the liaison between business stakeholders and the Data Platforms team, the Senior Business Analyst ensures that data initiative scope, data lineage, transformation logic, and analytics requirements are clearly documented, communicated, and validated. This role works closely with data engineers and architects to design, develop, document, test and validate data solutions that meet business requirements while maintaining medallion architecture principles. The successful candidate will lead data platform innovations, mentor other analysts, and contribute technical expertise to advance our data capabilities.
JOB DETAILS:
This is not a contract-to-hire role
This role must align with Arizona core working hours (9:00 AM-4:00 PM AZ time)
Location preference: AZ or same time zone preferred
TIMELINE: The first batch of resumes will be sent to the hiring manager on Monday, August 31st at 3pm AZ time.
PRINCIPAL RESPONSIBILITIES:
Act as a liaison with business stakeholders to analyze data requirements, reporting needs, and analytical use cases while ensuring data quality standards and architectural governance
Create detailed technical documentation including: Data Requirements Specifications, Logical and Physical Data Models, ETL/ELT Process Flow Diagrams, Data Lineage Maps, Transformation Rules, and Data Quality Frameworks
Design and document medallion architecture implementation (Bronze/Silver/Gold layers) for large-scale transformation projects, ensuring scalability and maintainability
Leverage AI and machine learning tools to enhance data definitions, automated table attribute analysis, and data discovery processes
Perform comprehensive data profiling, quality assessment, and source system analysis to inform data transformation strategies
Lead feasibility studies and impact analysis for proposed data platform initiatives, including cost-benefit analysis and ROI modeling
Collaborate with data engineers and architects to define technical requirements, data governance policies, and transformation standards
Provide technical guidance throughout the development lifecycle, including requirements validation, design reviews, and testing support
Build and maintain relationships with technology vendors, platform partners, and implementation specialists specializing in data technologies
Mentor and guide other business analysts and junior team members on data engineering best practices and complex analytical problem-solving
Contribute to innovation initiatives for the Data Platforms team, staying current with emerging data technologies and methodologies
Develop comprehensive implementation and knowledge transfer documentation for data solutions
Write, troubleshoot, and validate Snowflake SQL queries to perform data analysis, reconciliation, and quality assurance before delivering data solutions or results to stakeholders
Quickly learn and understand source systems, business processes, and end-to-end data flows to support data integration, transformation, and analytics initiatives
Lead and validate source-to-target mapping activities, ensuring that business requirements, transformation logic, and data definitions are accurately translated into technical specifications; guide data engineers on source interpretation, mapping, and business rules
Create and maintain metadata documentation, business glossaries, and data dictionaries, including field-level definitions, business descriptions, transformation rules, and data lineage information
Responsible for status reporting, stakeholder communication, and project coordination for data initiatives
Performs other duties as assigned
MINIMUM QUALIFICATIONS:
Bachelor's degree in Computer Science, Information Systems, Data Science, Statistics, Engineering, or a related field, OR minimum of 6 years of direct work experience in data analysis, business analysis, or data engineering roles involving complex data systems, ETL/ELT processes, or data platform development
Demonstrated experience with SQL and data transformation logic
Strong technical foundation with experience in large-scale data projects or data warehouse/lake environments
PREFERRED QUALIFICATIONS:
Experience with medallion architecture (Bronze/Silver/Gold layers) or similar data layering patterns
Proficiency in data modeling tools and methodologies (Dimensional, Entity-Relationship modeling, etc.)
Experience with cloud data platforms (Snowflake, Databricks, BigQuery, or Azure Synapse)
Hands-on experience with ETL/ELT tools and orchestration platforms (dbt, Apache Airflow, Informatica, etc.)
Knowledge of data governance frameworks and data quality best practices
Experience leveraging AI/ML for data cataloging, metadata management, or automated data profiling
Familiarity with modern data stack tools and practices
Business Analysis or Data Engineering certification (CBAP, ECBA, AWS Data Engineer, Snowflake certification)
Experience leading or architecting large-scale data transformation initiatives
Background in software development or systems engineering with transition to data platforms