Sql data analyst Jobs in Charlotte, NC

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 :