Senior Enterprise Applications Engineer

firstPRO US; Boston (MA); On-site; USD 120,000 - 180,000; Full time

Job summary

firstPRO US is seeking a Senior Enterprise Applications Engineer to join our Boston, MA office. You will design, build, and support data platforms, dashboards, and integrations across the firm while advancing AI-driven automation to optimize workflows and connect enterprise systems.

You will lead end-to-end solutions, collaborate with stakeholders, and deliver reliable, scalable BI and data solutions using modern data, AI, and application technologies.

Qualifications

• Bachelor’s degree in Computer Science or related field.
• 5+ years of experience across a diverse technology base.
• Advanced proficiency in T-SQL and SQL Server.
• Experience with Python, AI technologies, and automation.
• Experience creating executive dashboards with Power BI/SSRS.
• Data warehousing, data lakes, and analytics experience.
• ETL pipelines with Azure Data Factory and SSIS.

Responsibilities

• Design and develop data solutions including data warehouse and BI solutions.
• Lead design and implementation of system integrations using APIs and data interfaces.
• Develop and maintain dashboards, reports, and analytics using Power BI, SSRS, and SQL.
• Build ETL pipelines with Azure Data Factory, SSIS, and Databricks.
• Develop applications and automation workflows using Python, C#, and AI tools.
• Lead AI-driven workflows and promote best practices across the firm.
• Serve as a technical lead on projects from requirements through delivery.
• Collaborate with stakeholders to translate business needs into technical solutions.
• Support and enhance enterprise applications, databases, and reporting environments.

Skills

T-SQL

Python

C#

Power BI

SSRS

SQL Server

Azure Data Factory

SSIS

Databricks

APIs & integrations

AI technologies

SharePoint

Power Platform

Education

Bachelor’s degree in Computer Science or related field

Tools

Azure Data Factory

SSIS

SSRS

SharePoint

Power Platform

Power BI

Job description

Senior Enterprise Applications Engineer to join our Boston, MA office.

Seeking an experienced Senior Enterprise Applications Engineer to join our Information Technology team. This role plays a critical part in designing, building, and supporting data platforms, data visualizations solutions, integrations, and business-critical applications across the firm, while advancing the firm's use of AI and automation to optimize workflows and connect enterprise systems. You will serve as a technical leader, owning end-to-end solutions that integrate enterprise systems, enable analytics and reporting, and automate business processes. This is a hands-on role for someone who enjoys solving complex problems, collaborating with stakeholders, and building reliable, scalable solutions using modern data, AI and application technologies.

Some of the day-to-day responsibilities of this role include:

• Design and develop data solutions including data warehouse and business intelligence solutions
• Lead the design and implementation of system integrations using APIs, web services, and data interfaces
• Lead the design, development, and maintenance of advanced, interactive dashboards, data visualizations, reports, and analytical solutions using Power BI, SSRS, T-SQL, and other business intelligence tools to transform data into actionable insights
• Develop and optimize ETL and data integration pipelines using SQL, Azure Data Factory, SSIS, Databricks, and related tools
• Develop applications, automation workflows, and data solutions using Python, C#, and emerging AI-enabled tools
• Design, develop and implement AI-driven workflows, agents, and automation solutions to improve business processes and operational efficiency
• Serve as a resource for AI technologies, promoting best practices, sharing knowledge, and supporting adoption across the firm
• Act as technical lead on projects, guiding solution design and implementation from requirements through delivery
• Partner with business stakeholders to gather requirements and translate business needs into effective technical solutions
• Support and enhance critical business systems, custom applications, databases, and reporting environments
• Administer and develop SharePoint solutions in Microsoft-365 and On-Prem environments
• Troubleshoot complex technical issues and deliver practical, reliable solutions
• Contribute to continuous improvement of development standards, tools, and processes

THE CANDIDATE

• Bachelor’s degree in Computer Science or related field
• 5+ years of experience working across a diverse technology base
• Advanced proficiency in T-SQL and SQL Server, including performance tuning and optimization
• Strong experience developing applications, automation solutions, and data workflows using Python; experience with AI technologies, tools, and workflows is highly desirable
• Advanced experience creating executive-level dashboards, interactive visualizations, KPI reporting, and self-service analytics/reporting solutions using Power BI, SSRS, and other business intelligence platforms
• Proven experience designing and building data warehousing, data lakes and analytics solutions
• Hands-on experience developing ETL pipelines using Azure Data Factory and SSIS (or equivalent tools)
• Experience supporting and integrating enterprise applications
• Demonstrated ability to lead technical workstreams and own solutions end to end
• Excellent analytical, troubleshooting, and problem-solving skills
• Strong communication skills with the ability to work effectively with technical and non-technical stakeholders
• SharePoint administration and development experience (Microsoft 365 and on-prem) is a plus
• Experience with Microsoft Power Platform (PowerApps, Power Automate, etc.) is a plus
• Proactive, self-directed, and comfortable working independently and as part of a dynamic team
• Strong customer-service mindset with effective time management and strict attention to detail
• Able to manage multiple priorities in a fast-paced environment
• Collaborative team player who communicates clearly and professionally
• Comfortable working under pressure while maintaining high standards of quality
• A desire to problem solve, research tools and applications to automate work
• Excellent analytical, troubleshooting, and problem solving skills