Analytics Engineer

Five Star Credit Union•Dothan, AL

1d•$100,000 - $120,000•Hybrid

About The Position

This role combines data engineering, business intelligence, and analytics to deliver data-driven solutions for the credit union. The Analytics Engineer designs and builds data pipelines, develops dimensional models, creates Power BI reports and dashboards, and translates business requirements into technical solutions. This position emphasizes hands-on SQL Server development and BI delivery (80%) while providing platform support (20%) to ensure data quality, performance, and reliability. The role requires self-management of projects from requirements gathering through deployment, collaborating with business and technical stakeholders across the organization.

Requirements

Bachelor’s degree in Business, Finance, Accounting, Statistics, Mathematics, Computer Science, or minimum 5 years of equivalent work experience.
Expert-level SQL Server 2022 knowledge including T-SQL, performance tuning, execution plans, and indexing strategies
SSIS development and deployment including error handling, logging, and package reliability
Power BI development including datasets, DAX calculations, and visualization best practices
Dimensional modeling (star schema, snowflake schema) and ETL processes
Data security practices including PII protection and safeguarding sensitive member information
Credit union products, services, and core banking systems (Symitar/ARCU strongly preferred)
Minimum 5 years of hands-on experience with SQL Server development, SSIS, and Power BI in a data engineering, analytics engineering, or business intelligence role
Diagnose and resolve database performance issues using execution plans, indexes, query analysis, and SQL Server monitoring tools
Gather requirements from stakeholders and translate business needs into technical solutions
Self-manage projects from requirements through design, development and deployment with minimal supervision
Exceptional verbal and written communication skills and ability to present information clearly and professionally
Strong interpersonal skills with ability to mentor analysts and collaborate across departments
Excellent organization, prioritization, and time management in a fast-paced environment
Finger dexterity: Using primarily just the fingers to make small movements such as typing, picking up small objects, or pinching fingers together.
Talking: Position requires capacity for almost continuous verbal communication and detailed or important instructions or ideas must frequently be conveyed accurately, loudly or quickly to other team members.
Average hearing: Able to hear average or normal conversations and receive ordinary information.
Repetitive motions: Movements frequently and regularly required using the wrists, hands, and fingers.
Average visual abilities: Average, ordinary, visual acuity necessary to prepare or inspect documents or products, or operate machinery.
Physical strength: Medium work; exerts up to 20 lbs. of force occasionally, and/or up to 20 lbs. frequently, and 10 lbs. constantly.
Reasoning ability: Ability to analyze complex technical problems with multiple variables and determine appropriate solutions.
Ability to interpret business requirements and technical specifications.
Mathematics ability: Ability to work with percentages, ratios, and basic statistical concepts.
Ability to interpret data trends and create meaningful calculations in reports and queries.
Language ability: Ability to read and comprehend technical documentation, manuals, and industry resources.
Ability to write clear technical documentation, procedures, and communications using proper grammar and formatting.
Ability to communicate technical concepts effectively to both technical and non-technical audiences.

Nice To Haves

Symitar/ARCU strongly preferred

Responsibilities

Design and build data pipelines using SQL Server, SSIS, and other tools to ingest, transform, and load data from diverse sources
Develop and maintain data models (e.g., star schema, snowflake schema) to support analytics and reporting
Build and enhance stored procedures, views, and SQL code to deliver business and project data requests
Modify existing code (procedures, views, staging logic) to add columns, fix joins, or improve performance
Integrate data from APIs and external systems, ensuring consistency and quality
Maintain and harden existing SQL Server Integration Services packages for reliability including logging and automated error recovery
Optimize data infrastructure and queries for performance, scalability, and cost efficiency
Keep database objects and job scripts in source control and participate in CI/CD deployment processes
Support AI/ML initiatives by preparing and structuring data for machine learning models and LLM applications
Research and prototype AI/ML solutions including natural language query interfaces, semantic layer technologies, and LLM applications for credit union analytics
Design and develop reports, dashboards, and visualizations in Power BI to meet business needs
Collaborate with stakeholders to translate business requirements into data and reporting solutions
Build Power BI datasets and implement DAX calculations to enhance reporting capabilities
Ensure consistency and usability of visualizations through adherence to established design standards
Gather requirements directly from business stakeholders and design solutions independently
Provide technical support to analysts and end users, assisting with the use of data and reports
Mentor business unit personnel on data understanding, report structure, and dashboard usage
Review, debug, and optimize T-SQL stored procedures and functions using execution plans and Dynamic Management Views (DMVs)
Design and maintain indexing strategies including clustered, non-clustered, and filtered indexes
Manage statistics, mitigate parameter sniffing, and optimize temp db usage
Support SQL Server Agent jobs, schedules, and automation tasks
Monitor key data quality indicators and alerts for priority tables; perform root cause analysis and drive corrective actions
Implement and tune monitoring and alerting for performance and job health
Write clear runbooks, documentation, and technical specifications
Partner with business and technical teams to identify opportunities to leverage data for decision-making
Communicate effectively with Security, Infrastructure, Analytics, and Data Governance teams
Maintain documentation for data pipelines, models, and reporting assets to promote team collaboration
Lead and self-manage medium-sized data and analytics projects involving multiple business and technical stakeholders using Azure Boards and agile sprint methodology
Coordinate with cross-functional teams to define project scope, timelines, and deliverables
Manage competing priorities and communicate project status to stakeholders and leadership
Ensure all data engineering and analytics activities comply with regulatory requirements and internal standards
Implement and maintain data security practices to safeguard sensitive information
Maintain compliance with FSCU's established policies, procedures, and applicable regulations including BSA, AML, MIP, and OFAC
Stay current on emerging tools, technologies, and best practices in data engineering and analytics
Identify opportunities to streamline data workflows and improve data accessibility for business users
Explore and experiment with emerging AI/ML technologies including LLMs and their applications to credit union data and analytics