Analytics Engineer

If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process.

Full Time Professional Dothan HQ, Dothan, AL, US

Salary Range: $85,000.00 To $ Annually

* This position is open to remote, hybrid, and onsite candidates. Candidates must be willing and able to work onsite as needed to support business and project requirements.

Position Title:

Analytics Engineer Department:
Data and Analytics

Classification:
Exempt/Grade 13

Position

Reports To:

CDO - Chief Data Officer Positions Supervised:
None

All team members work toward a common purpose to Brighten the Financial Future of the Communities We Serve.

Each employee supports our members by promoting and offering relevant services and products to meet their diverse needs.

We deliver outstanding service by embracing our core values of Integrity, Collaboration, Accountability, Passion, and Self-Improvement.

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.

• 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, fixjoins, 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…