Analytics Engineer

*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  

REPORTING RELATIONSHIPS

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. 

_______________________________________________________________________________________________________

POSITION PURPOSE

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.

_____________________________________________________________________________________________________

ESSENTIAL FUNCTIONS AND BASIC DUTIES

Data Engineering and Integration

1. Design and build data pipelines using SQL Server, SSIS, and other tools to ingest, transform, and load data from diverse sources

1. Develop and maintain data models (e.g., star schema, snowflake schema) to support analytics and reporting

1. Build and enhance stored procedures, views, and SQL code to deliver business and project data requests

1. Modify existing code (procedures, views, staging logic) to add columns, fixjoins, or improve performance

1. Integrate data from APIs and external systems, ensuring consistency and quality

1. Maintain and harden existing SQL Server Integration Services packages for reliability including logging and automated error recovery

1. Optimize data infrastructure and queries for performance, scalability, and cost efficiency

1. Keep database objects and job scripts in source control and participate in CI/CD deployment processes

1. Support AI/ML initiatives by preparing and structuring data for machine learning models and LLM applications

1. Research and prototype AI/ML solutions including natural language query interfaces, semantic layer technologies, and LLM applications for credit union analytics

Business Intelligence Development

1. Design and develop reports, dashboards, and visualizations in Power BI to meet business needs

1. Collaborate with stakeholders to translate business requirements into data and reporting solutions

1. Build Power BI datasets and implement DAX calculations to enhance reporting capabilities

1. Ensure consistency and usability of visualizations through adherence to established design standards

1. Gather requirements directly from business stakeholders and design solutions independently

1. Provide technical support to analysts and end users, assisting with the use of data and reports

1. Mentor business unit personnel on data understanding, report structure, and dashboard usage

SQL Platform Support

1. Review, debug, and optimize T-SQL stored procedures and functions using execution plans and Dynamic Management Views (DMVs)

1. Design and maintain indexing strategies including clustered, non-clustered, and filtered indexes

1. Manage statistics, mitigate parameter sniffing, and optimize temp db usage

1. Support SQL Server Agent jobs, schedules, and automation tasks

1. Monitor key data quality indicators and alerts for priority tables; perform root cause analysis and drive corrective actions

1. Implement and tune monitoring and alerting for performance and job health

1. Write clear runbooks, documentation, and technical specifications

Collaboration and Communication

1. Partner with business and technical teams to identify opportunities to leverage data for decision-making

1. Communicate effectively with Security, Infrastructure, Analytics, and Data Governance teams

1. Maintain documentation for data pipelines, models, and reporting assets to promote team collaboration

Project Management

1. Lead and self-manage medium-sized data and analytics projects involving multiple business and technical stakeholders using Azure Boards and agile sprint methodology

1. Coordinate with cross-functional teams to define project scope, timelines, and deliverables

1. Manage competing priorities and communicate project status to stakeholders and leadership

Compliance and Security

1. Ensure all data engineering and analytics activities comply with regulatory requirements and internal standards

1. Implement and maintain data security practices to safeguard sensitive information

1. Maintain compliance with FSCU's established policies, procedures, and applicable regulations including BSA, AML, MIP, and OFAC

Continuous Improvement

1. Stay current on emerging tools, technologies, and best practices in data engineering and analytics

1. Identify opportunities to streamline data workflows and improve data accessibility for business users

1. Explore and experiment with emerging AI/ML technologies including LLMs and their applications to credit union data and analytics

_____________________________________________________________________________________________

QUALIFICATIONS

Education/Certification: Bachelor’s degree in Business, Finance, Accounting, Statistics, Mathematics, Computer Science, or minimum 5 years of equivalent work experience.

required knowledge:

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)

experience required: 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

skills/abilities:

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

PHYSICAL ACTIVITIES AND REQUIREMENTS OF THIS POSITION

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.

WORKING CONDITIONS

NONE: No hazardous or significantly unpleasant conditions. (Such as in a typical office.)

MENTAL ACTIVITIES AND REQUIREMENTS OF THIS POSITION

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.

INTENT AND FUNCTION OF JOB DESCRIPTIONS

Job descriptions assist organizations in ensuring that the hiring process is fairly administered and that qualified employees are selected.  They are also essential to an effective appraisal system and related promotion, transfer, layoff, and termination decisions.  Well-constructed job descriptions are an integral part of any effective compensation system.  

All descriptions have been reviewed to ensure that only essential functions and basic duties have been included.  Peripheral tasks, only incidentally related to each position, have been excluded.  Requirements, skills, and abilities included have been determined to be the minimal standards required to successfully perform the positions.  In no instance, however, should the duties, responsibilities, and requirements delineated be interpreted as all inclusive.  Additional functions and requirements may be assigned by supervisors as deemed appropriate.  

In accordance with the Americans with Disabilities Act, it is possible that requirements may be modified to reasonably accommodate disabled individuals.  However, no accommodations will be made which may pose serious health or safety risks to the employee or others or which impose undue hardships on the organization.

Job descriptions are not intended as and do not create employment contracts.  The organization maintains its status as an at-will employer.  Employees can be terminated for any reason not prohibited by law.