Position Overview

Reporting to the Manager, Enterprise Analytics, the Analytics Developer contributes to the development, enhancement, and support of Albany's enterprise analytics ecosystem, with a strong emphasis on Microsoft technologies. This role works within an established architecture to deliver and optimize Microsoft-based analytics solutions, leveraging SAP as the primary enterprise data source, particularly from the SAP S/4HANA platform.

The role supports ongoing modernization initiatives through the adoption of Microsoft's analytics stack, including Microsoft Fabric and Azure-based services, helping to integrate SAP data into a scalable, governed, and high-performing data platform. While SAP remains the core system of record, this position focuses on building and maintaining data pipelines, models, and reporting solutions within the Microsoft ecosystem, with occasional use of third-party tools as required.

Additionally, the developer applies established standards, architectural patterns, and governance practices to ensure consistency, quality, and alignment with Albany's analytics strategy and evolving business needs, while collaborating closely with team members, architects, and stakeholders to deliver effective data and analytics solutions.

Key Responsibilities

• Support and enhance existing Microsoft BI solutions across SQL Server, SSAS, and SSRS, ensuring performance, reliability, and data accuracy
• Contribute to the migration of legacy analytics assets to Microsoft Fabric, including data models, data pipelines, and reporting solutions
• Develop and maintain scalable data models and semantic layers that transform enterprise data (e.g., SAP) into analytics-ready structures
• Build and support data ingestion and transformation pipelines within the Microsoft ecosystem
• Develop and maintain dashboards and reporting solutions to enable business insights and self-service analytics
• Assist in integrating Microsoft AI capabilities (e.g., Microsoft Fabric AI features, Azure AI services, and Foundry) into analytics workflows to enhance insights and automation
• Apply established standards and best practices for data modeling, performance optimization, and development lifecycle management
• Collaborate with team members, architects, and stakeholders to deliver analytics solutions aligned with business requirements
• Support data governance, security, and compliance requirements across analytics platforms

In performing their respective tasks and duties, all employees are expected to adhere to Albany's current values: Albany Wins Together, Count on Each Other, Own Your Actions, Care About Each Other, and Share Your Enthusiasm. Safety must always come first; we never compromise on safety for the sake of achieving another objective. Employees are also responsible for the health and safety of themselves and each other.

Desired Skills

• Understanding of business processes and KPIs in a manufacturing or enterprise environment
• 5+ years of experience developing analytics and reporting solutions in an enterprise Microsoft data environment
• Hands-on experience with SQL and Microsoft BI technologies (SSAS, SSRS, or similar), supporting enterprise-scale reporting solutions
• Experience working with ERP solutions, specifically SAP S/4HANA data as a source for analytics and reporting solutions
• Exposure to modern Microsoft analytics tooling such as Microsoft Fabric, Azure Synapse, or Power BI within implementation or support roles
• Working knowledge of data modeling concepts including dimensional modeling, basic semantic layer design, and ETL/ELT processes
• Familiarity with data pipeline development, orchestration concepts, and performance optimization in data workflows
• Understanding of data governance, security, and compliance practices in enterprise environments
• Ability to collaborate effectively within cross-functional teams and contribute to delivery of larger analytics programs
• US citizen or permanent resident Preferred:
• Experience integrating SAP CDS views, ABAP-managed CDS, and OData with modern data lake architectures.
• Familiarity with CI/CD, Infrastructure-as-Code, and FinOps for cloud analytics cost
• Knowledge of compliance frameworks (SOX, CMMC) and coordination with GIS Compliance and Cybersecurity.

The Benefits

Reverse commute to the New Hampshire seacoast area. Top notch benefits program including generous 401(k) match, vacation time, sick time, personal days, flexible schedule and strong commitment to work/life balance.

We offer a flexible 9/80 work schedule, where you'll enjoy an extra day off every other week. This structure balances full-time hours with more personal time, supporting both productivity and work-life balance.

• Location: Portsmouth, NH, full-time in office with a 9/80 schedule (Week 1: 9 hours Mon-Thu, 8 hours Week 2: 9 hours Mon-Thu, Friday off)
• Compensation: Will be structured to attract and retain the best possible
• Please Note: Due to the restricted nature of work, only US Citizens and US Persons (permanent residents) will be considered for this role. We cannot at this time sponsor employment visas (e.g. H-1B visa status).

Physical Working Conditions

• Sit and use their hands and fingers to handle or feel and to manipulate keys on a keyboard on a frequent basis
• Occasionally stand, walk, reach with arms and hands, climb, balance, stoop, kneel, crouch or crawl to work with the documentation and work within the business environment
• Have close vision
• Talk and hear to interact with internal and external customers

Work Environment for the MS Business Intelligence Developer Position

The noise level in the work environment is usually quiet to moderate.

Safety and Procedures of the MS Business Intelligence Developer Position

• Follow all publicized safety policies/procedures applicable to the job
• Use appropriate PPE that has been identified on the Hazard Analysis for the department/role
• Attend and participate in all safety training, safety meetings, audits and Behavior Based Safety programs assigned
• Report all safety hazards observed. If capable, correct the safety hazard identified
• Physical Demands of the MS Business Intelligence Developer Position