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 :Yes
Drug Screen :Yes
Notes :
Selling points for candidate :
Project Verification Info :
Candidate must be your W2 Employee :Yes
Exclusive to Apex :Yes
Face to face interview required :Yes
Candidate must be local :Yes
Candidate must be authorized to work without sponsorship No
Interview times set :Yes
Type of project :
Master Job Title :
Branch Code :