Analytics Consultant 3

About the role

A well-known Financial Services Company is looking for an Analytics Consultant in Charlotte, NC (Hybrid).

Responsibilities

• Work with the brightest minds at one of the largest financial institutions in the world.
• Contribute to large-scale planning related to Analytics deliverables.
• Review and analyze moderately complex Analytics challenges.
• Collaborate with client personnel in Analytics.
• Collaborate with business stakeholders to gather and refine requirements for data use cases.
• Design and architect scalable data models and data element relationships.
• Evaluate upstream system of record changes for potential data impact and provide recommendations.
• Translate business needs into actionable data requirements and technical specifications.
• Participate in data management documentation including data lineage, data sharing agreements, and other metadata management.
• Support database enhancement requests and contribute to logical data design solutions.
• Consult on or participate in moderately complex initiatives and deliverables within Analytics.
• Contribute to the resolution of moderately complex issues.

Requirements

• 4+ years of Analytics experience, or equivalent demonstrated through one or a combination of the following: work or consulting experience, training, military experience, education.
• MSSQL: Ability to write, read, and optimize queries for data extraction, transformation, and analysis.
• Data Analysis: Experience in data cleansing, validation, and transformation logic using Alteryx and SSMS.
• Documentation: Ability to define clear data sourcing and transform logic requirements and database/table/column specifications.
• Experience with metadata management and data governance practices.
• Proficiency in data profiling and root cause analysis for data quality issues.
• Proven ability to work independently and manage multiple priorities.
• Strong communication and stakeholder engagement skills.
• Comfortable navigating ambiguity and driving clarity in complex data environments.
• Experience with Google Data Cloud stack (Dataplex, big query, etc.).
• Familiarity with SSIS packages and jobs.
• Familiarity with Agile processes and Atlassian software (Jira)

Qualifications

• Medical Insurance - Four medical plans to choose from for you and your family
• Dental & Orthodontia Benefits
• Vision Benefits
• Health Savings Account (HSA)
• Health and Dependent Care Flexible Spending Accounts
• Voluntary Life Insurance, Long-Term & Short-Term Disability Insurance
• Hospital Indemnity Insurance
• 401(k) including match with pre and post-tax options
• Paid Sick Time Leave
• Legal and Identity Protection Plans
• Pre-tax Commuter Benefit
• 529 College Saver Plan

Skills

• Proficiency in data profiling and root cause analysis for data quality issues.
• Ability to define clear data sourcing and transform logic requirements and database/table/column specifications.
• Experience with Google Data Cloud stack (Dataplex, big query, etc.).
• Familiarity with SSIS packages and jobs.
• Familiarity with Agile processes and Atlassian software (Jira)

Benefits

• Medical Insurance - Four medical plans to choose from for you and your family
• Dental & Orthodontia Benefits
• Vision Benefits
• Health Savings Account (HSA)
• Health and Dependent Care Flexible Spending Accounts
• Voluntary Life Insurance, Long-Term & Short-Term Disability Insurance
• Hospital Indemnity Insurance
• 401(k) including match with pre and post-tax options
• Paid Sick Time Leave
• Legal and Identity Protection Plans
• Pre-tax Commuter Benefit
• 529 College Saver Plan

Pay

• $46.53/hr - $50.99/hr

Schedule

• Hybrid