Senior Data Engineer

Senior Data EngineerCREA, 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.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 DoData Platform & EngineeringDesign, build, test, deploy, and maintain scalable, secure, and reliable data pipelines and integrationsDevelop and maintain ETL/ELT processes for structured and semi-structured data, including orchestration and documentationIngest, transform, and integrate structured and unstructured data into centralized data platforms (warehouse/lakehouse)Build reusable code and automation to streamline data processing and managementCloud Modernization & ArchitectureLead and support migration of on-prem SQL Server workloads to Azure/Microsoft FabricParticipate in data architecture decisions, standards, and platform/tool selectionMaintain and optimize performance, reliability, and monitoring across cloud and hybrid environmentsAnalytics, Reporting & Business SupportDevelop and support data solutions that enable analytics, reporting, and business operationsProduce dashboards and reports; communicate insights to stakeholdersServe as a subject matter expert, partnering with IT and business teams to solve key data challengesGovernance, Quality & SecurityImplement data quality, validation, and monitoring controls; perform root cause analysisEstablish and support data governance practices to ensure integrity and business valueChampion data security, compliance, and adherence to company guidelinesDrive Power BI/Fabric governance, including semantic models and workspace managementWhat You'll GainOpportunity to lead enterprise-level cloud and data modernization initiativesHands-on experience with cutting-edge tools (Azure Fabric, Power BI, AI-enabled analytics)Collaboration with cross-functional teams across IT and business functionsAbility to influence data strategy, governance, and platform directionCareer growth within a stable, impact-driven organizationRequirementsBachelor's degree in Engineering, Computer Science, or related field required; advanced degree preferred7+ years of experience in data engineering or development with increasing responsibilityProven experience building and evolving data platforms and supporting business decision-makingIndustry experience in Real Estate, Financial Services, Banking, or FinTech preferredTechnical ExpertiseStrong experience designing, integrating, securing, monitoring, and optimizing data platformsExperience with APIs for system integration and data exchangeExperience leveraging AI-enabled tools for analytics, automation, or solution developmentTechnical SkillsAzure 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 FabricAnalytics & Reporting: Power BI, Power Query, DAXBusiness Applications: Microsoft 365 (O365, SharePoint, OneDrive), VSTO/C#.NET Add-insDevelopment & DevOps: GitHub, CI/CD pipelines, Visual Studio, Power BI Deployment Pipelines, Monday.comAdditional ExpectationsAbility to travel up to 5% as neededCore CompetenciesData 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 AuthorizationNo visa sponsorship availableCompensationCompensation 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)