Analytics Engineer (Redshift, Data Warehousing, SQL Server)

North Carolina, NC, US • Posted 1 day ago • Updated 2 hours ago
Contract Independent
Contract W2
On-site
$60.00 - $70.00/hr
Company Branding Image
Fitment

Dice Job Match Score™

🔢 Crunching numbers...

Job Details

Skills

  • FOCUS
  • Data Migration
  • Use Cases
  • Snow Flake Schema
  • Slowly Changing Dimensions
  • Data Structure
  • Business Rules
  • Data Profiling
  • Documentation
  • Collaboration
  • Testing
  • Computer Science
  • Information Systems
  • Data Modeling
  • SQL
  • Performance Tuning
  • Microsoft SQL Server
  • Database
  • Software Modernization
  • Dimensional Modeling
  • Extract
  • Transform
  • Load
  • ELT
  • Data Engineering
  • Data Validation
  • Specification Gathering
  • Analytical Skill
  • Problem Solving
  • Conflict Resolution
  • Technical Writing
  • Data Warehouse
  • Migration
  • Amazon S3
  • Amazon Redshift
  • Orchestration
  • Data Quality
  • Agile
  • Scrum
  • Business Intelligence
  • Tableau
  • Microsoft Power BI
  • Amazon Web Services
  • Analytics
  • Reporting
  • Data Architecture
  • Cloud Computing
  • Cross-functional Team
  • Professional Development

Summary

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
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: 10110651
  • Position Id: a1Wcv0000017lBKEAY
  • Posted 1 day ago

Company Info

About Brooksource

Here at Brooksource, relationships are at the center of everything we do. Since 2000, we have established and maintained long-lasting relationships with our clients and consultants to create an unparalleled experience. Brooksource is a trusted services provider that specializes in delivering Engineering and IT solutions for Fortune 500 organizations through Experience-Driven Staffing, Professional Services, and Elevate, our Workforce Transformation program. As a certified partner for Salesforce, AWS, Microsoft, Google Cloud, and many other technology alliances, we are looking for professionals who want to be on the frontline of the latest trends in the industry.

We offer contract, contract-to-hire, and direct placement consultant opportunities, to provide a career path that can meet anyone's desires. The job search is hard, but you don’t have to do it alone! We know a successful partnership requires a good fit. Your personality, experience, and skill set are all important, contributing factors to that partnership. You can count on us to take the time to understand the type of technical and cultural fit that is right for you. As a Brooksource consultant, you will be provided with a comprehensive benefits plan, competitive compensation, and even paid time off!

Cyber Security Warning: Please be aware that all official Brooksource communications will ONLY come from emails displayed as [name]@brooksource.com. The use of any other domains is NOT an official Brooksource employee and could be fraudulent.

Brooksource provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, national origin, age, sex, citizenship, disability, genetic information, gender, sexual orientation, gender identity, marital status, amnesty or status as a covered veteran in accordance with applicable federal, state, and local laws.

Benefits & Perks: 

Brooksource offers competitive medical, dental, vision, Health Savings Account, Dependent Care FSA, and supplemental coverage with plans that can fit each employee’s needs. We offer a 401k plan that includes a company match and is fully vested after you become eligible, paid time off, sick time, and paid company holidays. We also offer an Employee Assistance Program (EAP) that provides services like virtual counseling, financial services, legal services, life coaching, etc. 

 Pay Disclaimer: 

The pay range for this job level is a general guideline only and not a guarantee of compensation or salary. Additional factors considered in extending an offer include (but are not limited to) responsibilities of the job, education, experience, knowledge, skills, and abilities, as well as internal equity, alignment with market data, applicable bargaining agreement (if any), or other law.

Partnerships:

  • Gold Microsoft Partner – Cloud Platform
  • Gold Microsoft Partner – Data Analytics
  • Silver Microsoft Partner – Data Platform
  • Silver Microsoft Partner – Security
  • Silver Microsoft Partner – Application Development
  • Silver Microsoft Partner – Data Center
  • AWS Partner
  • Salesforce Partner
  • Salesforce – Authorized Training Provider
  • Salesforce Talent Alliance Employer
  • Tableau Services Partner
  • Snowflake Partner
  • Google Cloud Platform (GCP) Services Partner

Awards (Extended):

  • Best Places to Work 2022, Charlotte Business Journal, 2022
  • Best Places to Work in Jacksonville, Jacksonville Business Journal, 2021
  • Best Places to Work in Jacksonville, Jacksonville Business Journal, 2020
  • Best Places to Work in Charlotte (#8 Small Business), Charlotte Business Journal, 2019
  • 2019 Best Places Work in Kentucky, Kentucky Chamber of Commerce, 2019
  • Top Workplaces, Indy Star, 2019
  • Best Places to Work in Jacksonville, Jacksonville Business Journal, 2019
  • Best & Brightest Companies to Work For in the Nation, Best & Brightest, 2018
  • Top Work Places, Indy Star, 2018
  • Best Places to Work, Jacksonville Business Journal, 2018
  • Best Places to Work, Charlotte Business Journal, 2018
  • Best Places to Work in Kentucky (Small/Medium), Kentucky Society for Human Resource Management State Council and the Kentucky Chamber of Commerce, 2018
  • Milwaukee’s 2018 Best And Brightest Companies To Work For, Milwaukee's Best and Brightest Place to Work, 2018
  • Best Places to Work, Best Places to Work in Kentucky, 2017
  • Best Places to Work, Best Places to Work in Kentucky, 2016
  • Best Places to Work, Jacksonville Business Journal, 2016
  • Top Workplaces, The Indianapolis Star, 2016
  • Top Workplaces, Indianapolis Star, 2015
  • Best Places to Work, Charlotte Business Journal, 2015
  • Best Places to Work Atlanta, Atlanta Business Chronicle, 2014
About_Company_One
Create job alert
Never miss an opportunity! Create an alert based on the job you applied for.