Business Analyst IT III - Fortune 150 Energy Client
Contract - Charlotte, NC - Hybrid
Description:
The successful candidate utilizes data to solve key business problems within the Customer Data Delivery team at our Fortune 150 Energy Client. There is a major drive at our client to migrate our on-premise databases to cloud architecture; our team works closely with business leaders to understand customer data initiatives, and collaborates with IT delivery teams to prioritize workload to meet business needs. The candidate will spend much of his/her time exploring customer databases (both on-prem and cloud-based), then translate data insights to delivery teams. The ideal candidate for this role is analytically-minded, self-motivated, and an excellent communicator.
The successful candidate will have the following qualities:
• Intellectually curious and creative, eager to generate ideas to solve business problems
• Strong analytical, facilitation, and communication skills
• Strong organizational and prioritization skills and ability to multitask with minimal oversight
• Capable of building, developing and maintaining positive working relationships with executives, key clients and subject matter experts while working in a team environment.
The successful candidate will have the following skillset:
• Intermediate to advanced SQL skills, and experience developing queries on large datasets
• Strong communication skills
• Strong exploratory analysis skills
• Exemplary problem solving, decision making and attention to detail
• Demonstrated ability to lead efforts across multiple business groups
• Experience with product testing and usability testing
• Success in project management or process improvement
• Experience in writing effective test cases/scripts and maintain a traceability matrix
• Experience developing, optimizing, and/or maintaining data visualizations (e.g., Power BI/Tableau)
Responsibilities
• Work across departments on data strategies that improve business processes
• Translate business initiatives into requisite data engineering tasks
• Authoring functional report designs, test scenarios and test cases for Analytics & Reporting
• Ensuring alignment between business stakeholders and development team
• Explore new datasets for anomalies that may inform data engineering methods used to migrate dataset
• Capturing source/target dataset metadata
• Build and manage Technical documents like ETL Mapping and Data Dictionaries.
• Perform data validations to confirm data migration successful
• Documenting data quality test results
• Documenting and communicating the results of your efforts
• Assist with creating training documentation and job-aids
• Sharing findings with team members and leadership in a regular cadence
Additional Preferred Qualifications
• Previous experience using cloud data warehouses (e.g., Amazon Redshift, Snowflake, Google BigQuery)
• Previous experience using stream processing platforms (e.g., Apache Kafka, Apache Spark, Apache Flink, AWS Kinesis)
• Previous experience using an object-oriented programming language (e.g. Python, JavaScript, CSS)
• Previous experience using statistical programming languages (e.g., SAS, R, sci-py)
