Senior Data Engineer, Information Technology

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 97500 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 CREAs transition to a modern Azure Fabric data ecosystem unlocking data-driven insights across the organization.

What Youll 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 Youll 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

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

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: $97000 $118000 (midpoint: $106000)
• Boston MA: $118000 $143000 (midpoint: $129000)