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 :
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 :