Data Architect

ProSearch; Burlington (ME); On-site; USD 124,000 - 179,000; Full time

Job summary

ProSearch seeks a Senior Data Architect to modernize an enterprise data and reporting environment in the United States. You will assess the current landscape, define a future-state architecture, and help implement a scalable Microsoft-based data platform using Azure, Fabric, and Power BI.

Responsibilities include governance, data modeling, ETL/ELT pipelines, and enabling self-service analytics for executives.

Qualifications

• Experience in data architecture design and data governance.
• Strong SQL, Python, and ETL/ELT skills.
• Experience with analytics platforms (Power BI) and Microsoft data stack.

Responsibilities

• Assess current data, integration, and reporting environment.
• Gather business and technical requirements.
• Design future-state data architecture and roadmap.
• Define data lake/warehouse/labricot architecture.
• Implement initial data platform, pipelines, and integrations.
• Establish scalable ETL/ELT and data governance.

Job description

We are seeking an experienced Senior Data Architect to help modernize an enterprise data and reporting environment. This individual will assess the current landscape, define a future-state architecture, and help implement a scalable Microsoft-based data platform.

The organization currently has data distributed across ERP, HR, payroll, project management, marketing, and other business systems. Existing reporting relies heavily on SQL extracts, Python-based ETL processes, Excel, and internally developed solutions.

The goal is to create a centralized and governed data environment using Azure, Microsoft Fabric, and Power BI, providing a stronger foundation for financial, operational, and executive reporting.

What You'll Do

Assess the current data, integration, and reporting environment.

Gather business and technical requirements.

Design the future-state data architecture and phased roadmap.

Define the appropriate data lake, warehouse, or lakehouse strategy.

Help implement the initial data platform, pipelines, and integrations.

Establish scalable ETL/ELT, governance, and data quality practices.

Enable Power BI reporting and self-service analytics.

Provide strategic recommendations while remaining hands-on through implementation.

Must-Have Technologies & Experience

• Current-state assessments and future-state architecture
• Data governance
• Enterprise reporting architecture

Microsoft Data Platform

• Microsoft Fabric
• Azure Data Lake, Lakehouse, or Data Warehouse architecture
• Power BI
• SQL Server
• Python
• ETL / ELT
• Data pipelines and ingestion frameworks
• Data modeling
• API and system integrations

Engagement

This engagement is expected to begin with an initial assessment, architecture, and implementation phase of at least three months, with potential for longer-term consulting, contract extension, or conversion to a permanent role.

Pay Rate Starts at $90.00/ hour depending on experience and expertise

Salary Disclaimer

The salary range for this role reflects the minimum and maximum compensation for the role. Offers are typically made between the range minimum and the range midpoint. Actual compensation will be determined based on job-related skills, experience, and expertise, as evaluated during the interview process. Compensation may also vary based on where a role is performed.

Equal Opportunity Statement

ProSearch is an Equal Opportunity Employer and considers all qualified applicants for employment without regard to legally protected characteristics. All employment decisions are based on business needs, job requirements, and individual qualifications.