Business Intelligence Developer

Socket.dev; Portsmouth (NH); On-site; USD 110,000 - 140,000; Full time

Benefits offered by this job

9/80 work schedule

Top-tier benefits

401(k) match

Job summary

Albany International is seeking an Analytics Developer to advance its Microsoft-based analytics stack, focusing on SQL Server, SSAS/SSRS, and Power BI. You’ll work within an established architecture to migrate assets to Microsoft Fabric and Azure Synapse, transforming SAP S/4HANA data into analytics-ready models and reports.

The role emphasizes data governance, security, and collaboration with architects and stakeholders to deliver scalable analytics solutions that enable self-service insights.

Qualifications

• 5+ years designing analytics and reporting in a Microsoft data environment.
• Hands-on with SQL and Microsoft BI technologies (SSAS/SSRS) in enterprise reporting.
• Experience with SAP S/4HANA data as a source for analytics.
• Familiarity with Microsoft Fabric and Azure Synapse.
• Knowledge of data modeling, ETL/ELT, and governance.

Responsibilities

• Support and enhance BI solutions across SQL Server, SSAS, and SSRS ensuring performance and data accuracy.
• Migrate legacy analytics assets to Microsoft Fabric, including data models and pipelines.
• Develop scalable data models and semantic layers transforming SAP data into analytics-ready structures.
• Build and maintain data ingestion and transformation pipelines in the Microsoft ecosystem.
• Develop and maintain dashboards and reporting solutions for insights and self-service analytics.
• Integrate Microsoft AI capabilities (Fabric AI, Azure AI, Foundry) into analytics workflows.
• Apply standards for data modeling, performance, and development lifecycle.
• Collaborate with teams to deliver analytics solutions aligned with requirements.
• Support data governance, security, and compliance across platforms.

Skills

SQL

MS BI

SSAS/SSRS

Power BI

Azure Synapse

Microsoft Fabric

SAP S4HANA

Data modeling

Tools

Microsoft Fabric

Azure Synapse

Power BI

SQL Server

Job description

Who we are: About Albany International

Albany International is a leading developer and manufacturer specializing in engineered components and advanced materials processing. The company operates two core businesses: Albany Machine Clothing, producing essential custom fabrics and process belts for paper manufacturing, and Albany Engineered Composites, delivering advanced materials-based components for aerospace, supporting commercial and military platforms.

About Global Information Services (GIS)

GIS provides cutting-edge information systems and technology solutions to Albany’s internal teams and customers. Services include strategy, software development, and maintenance, with a strong focus on customer service for business segments and corporate staff.

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

We are an equal opportunity employer. Minority/Female/Disabled/Veteran

Except where prohibited by state law, all offers of employment are conditioned upon successfully passing a drug test. This employer uses E-Verify.