Logo
Saxon Global

SQL Data Engineer

Saxon Global, Charlotte, North Carolina, United States, 28245


Role:

SQL Date Engineer

Location:

Charlotte, NC

Length:

3 + months

We are seeking a SQL Data Engineer to collaborate directly with our Finance teams. The successful candidate will be instrumental in constructing comprehensive audit tables for financial reporting. This role requires a strong background in data warehouse methodology, Slowly Changing Dimension (SCD) Type II, history tracking, and data validation using checksum or other hash/summary techniques. Excellent communication skills are essential, as is the ability to create and modify stored procedures. Bonus if using Azure platform and Azure SQL database.

Key Bullet Points:SQL Data Engineering:

Proficiency in SQL and building data warehouse, reporting, audit, history tracking tables.Data ETL/ELT:

Experience with data ETL (Extract, Transform, Load) or ELT (Extract, Load, Transform) processes.Communication:

Excellent communication skills are required as person will work directly with Finance teams to develop detailed audit tables for financial reporting.Data Warehouse Methodology:

Solid understanding and experience in data warehouse methodology.SCD Type II & History Tracking:

Experience with Slowly Changing Dimension (SCD) Type II and history tracking, or other type of history tracking method.Data Validation:

Proficiency in data validation using checksum or other hash/summary techniques.Stored Procedures:

Ability to create and modify stored procedures.Reporting:

Experience in building reports, specifically with Power BI and SSRS.

Required Skills : SQL Data Engineering: Proficiency in SQL and building data warehouse, reporting, audit, history tracking tables. Data ETL/ELT: Experience with data ETL (Extract, Transform, Load) or ELT (Extract, Load, Transform) processes. Communication: Excellent communication skills are required as person will work directly with Finance teams to develop detailed audit tables for financial reporting. Data Warehouse Methodology: Solid understanding and experience in data warehouse methodology. SCD Type II & History Tracking: Experience with Slowly Changing Dimension (SCD) Type II and history tracking, or other type of history tracking method. Data Validation: Proficiency in data validation using checksum or other hash/summary techniques. Stored Procedures: Ability to create and modify stored procedures. Reporting: Experience in building reports, specifically with Power BI and SSRS.Background Check :YesDrug Screen :YesNotes :Selling points for candidate :Project Verification Info :Candidate must be your W2 Employee :YesExclusive to Apex :YesFace to face interview required :YesCandidate must be local :YesCandidate must be authorized to work without sponsorship ::NoInterview times set :YesType of project :Master Job Title :Branch Code :