SQL Data Engineer

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 :