ShiftCode Analytics, Inc. is seeking a Senior Business Analyst – Data Engineering to analyze complex data requirements for Republic Services. This role involves liaising between business stakeholders and the Data Platforms team to ensure effective data solutions and architecture decisions are implemented.
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
- Responsible for status reporting, stakeholder communication, and project coordination for data initiatives
- Performs other duties as assigned
Requirements:
- 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
- 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