Analytics Engineer (Redshift, Data Warehousing, SQL Server)

Location: Charlotte, NCHybrid position (3 days per week on site in uptown Charlotte)1-year contract with opportunity for extension or full-time hireW-2 only. No Corp-to-Corp or 1099 arrangements.Applications will be accepted through October 22, 2026

Ready to make your application Please do read through the description at least once before clicking on Apply.
Brooksource is seeking a Senior Analytics Engineer to support the modernization and ongoing development of enterprise data warehouse solutions for our Fortune 500 client. This role will focus on designing and implementing dimensional data models, developing complex SQL transformations in Amazon Redshift, and supporting data migration efforts from legacy SQL Server environments.
The ideal candidate combines strong data warehousing expertise with advanced SQL skills and the ability to analyze, cleanse, reconcile, and validate enterprise data. This individual will serve as a key liaison between business stakeholders, analytics teams, and Data Engineers, translating requirements into clear technical specifications that enable scalable and trusted data solutions.
The position requires hands-on experience with Amazon Redshift, data modeling, data quality remediation, and data warehouse modernization initiatives. Successful candidates will be comfortable working across both business and technical teams to support the delivery of reliable analytics capabilities and enterprise reporting solutions.
WHAT YOU'LL DO:Design and implement dimensional data models including fact and dimension tables within Amazon RedshiftBuild and maintain curated analytics datasets to support reporting, business intelligence, and downstream analytical use casesApply data warehousing best practices including star schemas, snowflake schemas, slowly changing dimensions, and conformed dimensionsWrite, optimize, and maintain complex SQL queries and transformations to support analytics and reporting requirementsAnalyze existing SQL Server databases to understand source data structures, relationships, and business rulesPerform data profiling, cleansing, remediation, and reconciliation activities during data warehouse migration and modernization effortsIdentify and resolve data quality issues including duplicates, null values, data type inconsistencies, and integrity concernsValidate migrated data through source-to-target reconciliation and testing processesTranslate business and analytical requirements into technical specifications, source-to-target mappings, transformation logic, and validation criteriaPartner closely with Data Engineering teams to support backlog refinement, pipeline development, and production readiness activitiesCreate and maintain data dictionaries, technical documentation, transformation specifications, and data model documentationCollaborate with business stakeholders, analysts, and engineering teams to ensure data solutions align with organizational needsSupport testing, validation, and deployment efforts for new data warehouse capabilities and enhancements
WHAT YOU BRING:Bachelor's degree in Computer Science, Information Systems, Analytics, Engineering, or a related field, or equivalent professional experience4-7 years of experience in analytics engineering, data warehousing, data modeling, or related data-focused rolesStrong hands-on experience with Amazon Redshift or comparable cloud-based data warehouse platformsAdvanced SQL experience including complex joins, aggregations, window functions, and query performance optimizationExperience working with SQL Server databases, particularly within legacy modernization or migration initiativesStrong understanding of dimensional modeling and enterprise data warehouse design principlesExperience supporting ETL/ELT processes and collaborating with Data Engineering teamsExperience performing data validation, reconciliation, and data quality analysisAbility to convert business requirements into clear technical specifications and implementation-ready deliverablesStrong analytical, troubleshooting, and problem-solving skillsExperience developing and maintaining technical documentationAbility to effectively communicate with both xzbcwsv technical and non-technical stakeholders
PREFERRED QUALIFICATIONS:Experience supporting enterprise data warehouse modernization or migration initiativesFamiliarity with AWS services such as S3, Glue, Lambda, Redshift, or related cloud-based data platformsExperience with dbt, Airflow, or similar data transformation and orchestration toolsKnowledge of data quality frameworks, reconciliation methodologies, and governance practicesExperience working in Agile or Scrum environmentsFamiliarity with BI and analytics platforms such as Tableau, Power BI, Looker, or Amazon QuickSightExperience supporting large-scale analytics and reporting environmentsUnderstanding of enterprise data architecture and cloud-based data ecosystems
Eight Eleven Group is an equal opportunity employer that does not discriminate on the basis of actual or perceived race, color, creed, religion, national origin, ancestry, citizenship status, age, sex or gender (including pregnancy, childbirth, lactation, and related medical conditions), gender identity or gender expression, sexual orientation, marital status, military service and veteran status, physical or mental disability, protected medical condition as defined by applicable state or local law, genetic information, or any other characteristic protected by applicable federal, state, or local laws and ordinances.