Note: The job is a remote job and is open to candidates in USA. Five Star Credit Union is seeking an Analytics Engineer to design and build data pipelines, develop dimensional models, and create Power BI reports and dashboards to deliver data-driven solutions. The role emphasizes hands-on SQL Server development and BI delivery while supporting platform performance and data quality. The position requires collaboration with business and technical stakeholders to translate requirements into technical solutions and support AI/ML initiatives.
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, 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 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
Skills
- 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
- Credit union products, services, and core banking systems (Symitar/ARCU strongly preferred)
Benefits
- This position is open to remote, hybrid, and onsite candidates.
Company Overview