{bc}
paylocity

Senior Data Engineer, Information Technology

CREA, LLC
Boston, USA
Full-time
Senior · 7+ years experience
Hybrid
USD 97000-143000 yearly / year
Discovered 1 months ago
SQL Server Managed InstanceAzure SQL DatabaseAzure SynapseDataverseMicrosoft FabricOneLake

Full Job Posting

Data Platform & Engineering

Design, build, test, deploy, and maintain scalable, secure, and reliable data pipelines and integrations

Develop and maintain ETL/ELT processes for structured and semi-structured data, including orchestration and documentation

Ingest, transform, and integrate structured and unstructured data into centralized data platforms (warehouse/lakehouse)

Build reusable code and automation to streamline data processing and management

Cloud Modernization & Architecture

Lead and support migration of on-prem SQL Server workloads to Azure/Microsoft Fabric

Participate in data architecture decisions, standards, and platform/tool selection

Maintain and optimize performance, reliability, and monitoring across cloud and hybrid environments

Analytics, Reporting & Business Support

Develop and support data solutions that enable analytics, reporting, and business operations

Produce dashboards and reports; communicate insights to stakeholders

Serve as a subject matter expert, partnering with IT and business teams to solve key data challenges

Governance, Quality & Security

Implement data quality, validation, and monitoring controls; perform root cause analysis

Establish and support data governance practices to ensure integrity and business value

Champion data security, compliance, and adherence to company guidelines

Drive Power BI/Fabric governance, including semantic models and workspace management

What You'll Gain

Opportunity to lead enterprise-level cloud and data modernization initiatives

Hands-on experience with cutting-edge tools (Azure Fabric, Power BI, AI-enabled analytics)

Collaboration with cross-functional teams across IT and business functions

Ability to influence data strategy, governance, and platform direction

Career growth within a stable, impact-driven organization

Bachelor’s degree in Engineering, Computer Science, or related field required; advanced degree preferred

7+ years of experience in data engineering or development with increasing responsibility

Proven experience building and evolving data platforms and supporting business decision-making

Industry experience in Real Estate, Financial Services, Banking, or FinTech preferred

Technical Expertise

Strong experience designing, integrating, securing, monitoring, and optimizing data platforms

Experience with APIs for system integration and data exchange

Experience leveraging AI-enabled tools for analytics, automation, or solution development

Technical Skills

  • Azure Data Platform: SQL Server Managed Instance, Azure SQL Database, Azure Synapse, Dataverse, Microsoft Fabric (OneLake, Fabric Warehouse, Data Factory)
  • Data Integration: Azure Data Factory, Microsoft Fabric
  • Analytics & Reporting: Power BI, Power Query, DAX
  • Business Applications: Microsoft 365 (O365, SharePoint, OneDrive), VSTO/C# .NET Add-ins
  • Development & DevOps: GitHub, CI/CD pipelines, Visual Studio, Power BI Deployment Pipelines, Monday.com

Additional Expectations

Ability to travel up to 5% as needed

Core Competencies

Data Engineering – Designs and optimizes scalable data pipelines and integrations.

Data Modeling – Applies relational and dimensional modeling principles for analytics.

Data Quality & Governance – Ensures data integrity through quality controls and governance practices.

Problem Solving – Analyzes complex data issues and implements effective solutions.

Cloud Platforms – Demonstrates working knowledge of modern cloud data environments.

Collaboration – Partners with stakeholders to translate business needs into data solutions.

Communication – Communicates technical concepts and insights clearly to non-technical audiences.

Continuous Improvement – Identifies opportunities to enhance processes and data capabilities.

Our Values

We work as a family, investing in each other, worthy causes, and the communities we serve.

We have integrity in all that we do; we embrace differences and treat others with kindness and respect.

We believe that, with teamwork, we can accomplish anything and pursue inventive solutions for our clients.

Work Authorization

No visa sponsorship available

Compensation

  • Compensation for this position is determined based on factors such as education, qualifications, relevant experience, and geographic location.
  • Indianapolis, IN: $97,000 – $118,000 (midpoint: $106,000)
  • Boston, MA: $118,000 – $143,000 (midpoint: $129,000)

Apply for this job in 1 click

Skip the repetitive application forms

Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.

Sarah M.James T.Maya R.

Trusted by over 500,000 job seekers on Base Career

Start Free Today

More from this employer

More jobs at CREA, LLC