BI Data Solutions Analyst — Power BI, SQL & Dashboards

Ally Financial; Lake Vista (MS); Hybrid; USD 65,000 - 115,000; Full time

Benefits offered by this job

Time off benefits

401K retirement plan

Health insurance

Life insurance

Disability benefits

Parental leave and family support

Job summary

Ally Financial is seeking a Data Solutions Support Analyst to leverage Snowflake and Power BI to build data management, analytical pipelines and reporting for the Contract Processing Center and Direct Business Teams. The role focuses on delivering well-managed data solutions, dashboards, and automated reporting to support business operations.

You will design and maintain BI solutions, create robust visualizations, and ensure data quality through automated testing and SQL data prep.

Qualifications

• 1+ years in customer service or financial services industry.
• Bachelor's degree in business related discipline.
• Experience with data analytics and BI tools is a plus.

Responsibilities

• Under general direction, perform complex research and analysis to support business operations and present findings to manager or project leader.
• Assist in drafting, interpreting, and administering operational policies and procedures.
• Develop, validate, and maintain step-by-step instructions/training materials.
• Monitor performance to identify and help correct performance problems and provide feedback regarding areas requiring attention.
• Responsible for the design, development, and support of business intelligence solutions to meet reporting and analytic needs from our business partners.
• Implement robust, reliable, and custom reporting and visualizations using BI tools (Power BI, Sigma, Excel).
• Develop and maintain self-service reporting solutions and/or automated solutions.
• Use SQL as main tool for data preparation: extracting, cleansing, aggregation, and summarizing data to create meaningful visualizations.
• Ensure the quality and accuracy of data by creating automated testing scripts.
• Participate in the design and implementation of logical and physical data models.
• Review proposed production changes to ensure highest quality data standards and lowest production impact.
• Navigate, understand, and leverage existing complex data structures for reporting.
• Support production BI solutions by monitoring and tuning SQL queries and data loads.
• Monitoring performance and communicating functional and technical issues proactively.
• Interact with senior management, department leaders and other employees to develop and reach agreement on reporting requirements and priorities.
• Experience in designing and implementing custom reporting and visualizations using BI tools (Power BI)

Skills

Power BI

SQL

Excel

DAX

Python

Data visualization

Six Sigma

Education

Bachelor's degree in business related discipline

Tools

Power BI

Sigma

Excel

SQL

Job description

Ally Financial is seeking a Data Solutions Support Analyst to leverage Snowflake and Power BI to build data management, analytical pipelines and reporting for the Contract Processing Center and Direct Business Teams. The role focuses on delivering well-managed data solutions, dashboards, and automated reporting to support business operations.

You will design and maintain BI solutions, create robust visualizations, and ensure data quality through automated testing and SQL data prep.