Analytics Engineer (Redshift, Data Warehousing, SQL Server)

Eightelevengroup; Charlotte (NC); Hybrid; USD 83,000 - 96,000; Full time

Benefits offered by this job

Hybrid work arrangement

Job summary

Brooksource is seeking an Analytics Engineer in Charlotte, NC for a 1-year contract to modernize a data warehouse and build robust analytic datasets using Amazon Redshift. The role emphasizes dimensional modeling, complex SQL, and data migration from legacy SQL Server environments.

You will partner with stakeholders and Data Engineers to translate requirements into scalable data solutions, ensuring high data quality and reliable enterprise reporting.

Qualifications

• Bachelor's degree or equivalent professional experience
• 4-7 years of analytics engineering or data warehousing experience
• Hands-on with Amazon Redshift or similar cloud data warehouse
• Advanced SQL including joins, aggregations, window functions
• Experience with SQL Server databases in modernization/migration
• Knowledge of dimensional modeling and EDW design principles
• Experience supporting ETL/ELT and collaborating with Data Eng teams
• Experience validating data and performing data quality checks
• Ability to translate business requirements into technical specs
• Strong analytical and problem-solving skills
• Ability to document technical work clearly
• Experience with Agile/Scrum environments
• Familiarity with BI/analytics tools (Tableau/Power BI/Looker/QuickSight)
• Experience supporting large-scale analytics environments
• Understanding of enterprise data architecture and cloud ecosystems

Responsibilities

• Design and implement dimensional data models (facts and dimensions) in Redshift
• Build and maintain curated analytics datasets for reporting and BI
• Apply star/snowflake schemas and slowly changing dimensions
• Write and optimize complex SQL queries for analytics
• Analyze SQL Server sources to map data structures and rules
• Profile, cleanse, remediate, and reconcile data during migrations
• Identify and resolve data quality issues (duplicates, nulls, types)
• Validate migrated data via source-to-target reconciliation
• Translate requirements into source-to-target mappings and logic
• Collaborate with Data Engineering on pipelines and production readiness
• Create and maintain data dictionaries and technical docs
• Work with stakeholders to ensure data solutions meet needs
• Support testing, validation, and deployment of warehouse capabilities

Skills

SQL

Data warehousing

Dimensional modeling

Data quality

Data migration

Stakeholder communication

Problem solving

Cloud data platforms

Education

Bachelor's degree in CS/IS/Analytics or equivalent

Tools

Amazon Redshift

dbt

Airflow

SQL Server

Tableau/Power BI/Looker

Job description

Analytics Engineer (Redshift, Data Warehousing, SQL Server)

Charlotte, NC

Hybrid position (3 days per week onsite in uptown Charlotte)

Compensation: $60 - $70 per hour (W-2 only; no Corp-to-Corp or 1099 arrangements)

1-year contract with opportunity for extension or full-time hire

Applications accepted through October 22, 2026

ABOUT THE ROLE

Brooksource is seeking an Analytics Engineer to support the modernization and ongoing development of enterprise data warehouse solutions for our Fortune 500 client. In this hybrid role based in Charlotte, NC, you 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. You 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. This position requires hands‑on experience with Amazon Redshift, data modeling, data quality remediation, and data warehouse modernization initiatives. You will work across both business and technical teams to deliver reliable analytics capabilities and enterprise reporting solutions.

WHAT YOU'LL DO

• Design and implement dimensional data models, including fact and dimension tables, within Amazon Redshift
• Build and maintain curated analytics datasets to support reporting, business intelligence, and downstream analytical use cases
• Apply data warehousing best practices including star schemas, snowflake schemas, slowly changing dimensions, and conformed dimensions
• Write, optimize, and maintain complex SQL queries and transformations to support analytics and reporting requirements
• Analyze existing SQL Server databases to understand source data structures, relationships, and business rules
• Perform data profiling, cleansing, remediation, and reconciliation activities during data warehouse migration and modernization efforts
• Identify and resolve data quality issues including duplicates, null values, data type inconsistencies, and integrity concerns
• Validate migrated data through source‑to‑target reconciliation and testing processes
• Translate business and analytical requirements into technical specifications, source‑to‑target mappings, transformation logic, and validation criteria
• Partner closely with Data Engineering teams to support backlog refinement, pipeline development, and production readiness activities
• Create and maintain data dictionaries, technical documentation, transformation specifications, and data model documentation
• Collaborate with business stakeholders, analysts, and engineering teams to ensure data solutions align with organizational needs
• Support 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 experience
• 4-7 years of experience in analytics engineering, data warehousing, data modeling, or related data-focused roles
• Strong hands‑on experience with Amazon Redshift or comparable cloud-based data warehouse platforms
• Advanced SQL experience including complex joins, aggregations, window functions, and query performance optimization
• Experience working with SQL Server databases, particularly within legacy modernization or migration initiatives
• Strong understanding of dimensional modeling and enterprise data warehouse design principles
• Experience supporting ETL/ELT processes and collaborating with Data Engineering teams
• Experience performing data validation, reconciliation, and data quality analysis
• Ability to convert business requirements into clear technical specifications and implementation‑ready deliverables
• Strong analytical, troubleshooting, and problem‑solving skills
• Experience developing and maintaining technical documentation
• Ability to effectively communicate with both technical and non‑technical stakeholders
• Experience supporting enterprise data warehouse modernization or migration initiatives (preferred)
• Familiarity with AWS services such as S3, Glue, Lambda, Redshift, or related cloud-based data platforms (preferred)
• Experience with dbt, Airflow, or similar data transformation and orchestration tools (preferred)
• Knowledge of data quality frameworks, reconciliation methodologies, and governance practices (preferred)
• Experience working in Agile or Scrum environments (preferred)
• Familiarity with BI and analytics platforms such as Tableau, Power BI, Looker, or Amazon QuickSight (preferred)
• Experience supporting large-scale analytics and reporting environments (preferred)
• Understanding of enterprise data architecture and cloud-based data ecosystems (preferred)

WHAT'S IN IT FOR YOU

• Opportunity to work with a Fortune 500 client on high-impact data modernization initiatives
• Hybrid work environment (3 days onsite in uptown Charlotte)
• Potential for contract extension or full‑time hire
• Collaborative, cross‑functional team environment
• Professional development and growth opportunities
• Equal opportunity employer committed to diversity and inclusion