Job Type
Full-time
Description
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.
Physical Presence: In-Office | Tue - Thu; Flexible | Mon & Fri
Open to: Boston, MA, or Indianapolis, IN
Reports to: Senior Vice President, Business Intelligence & Analysis
What You'll DoData 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
CompensationCompensation 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)
