Senior Data Engineer, Information Technology

Description

CREA, LLC is a full-service low-income housing tax credit (LIHTC) syndicator forming long-term relationships with investors and developers that cultivate success and improve lives. With 25 years in affordable housing, CREA has raised $13.5 billion, resulting in the formation of over 97,500 homes within 1059 communities across the country. Thanks to the contributions of over 135 employees, CREA continues to seek talented, passionate individuals eager to grow with us. 

Physical Presence: In-Office | Tue – Thu; Flexible | Mon & Fri

Open to: Boston, MA, or Indianapolis, IN

Reports to: Senior Vice President, Business Intelligence & Analysis

We are seeking a Senior Data Engineer to lead the design, development, and modernization of enterprise data platforms supporting LIHTC and real estate finance operations. This role is ideal for a seasoned data professional who thrives in building scalable data solutions, driving cloud transformation, and enabling advanced analytics. You will play a key role in CREA’s transition to a modern Azure Fabric data ecosystem, unlocking data-driven insights across the organization.

What You'll Do

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

Requirements

• 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)