Mill Creek Residential
At Mill Creek Residential we are committed to building a diverse, equitable and inclusive workplace where our associates can grow and bring their whole selves to work. This starts with our recruiting and hiring process. We want you to know that we encourage you to apply if this job excites you, even if you dont meet 100% of the requirements. You may just be the right candidate for this role, or another role and make your mark at Mill Creek.
Essential Functions/Responsibilities
Support and maintain the existing SQL Server 2017 environment, ensuring data availability, performance, and reliability for ongoing business operations.
Design and implement scalable, secure, and efficient data solutions in Microsoft Azure, including Azure SQL, Data Factory, Synapse, and related services.
Develop and optimize data pipelines, ETL/ELT processes, and integrations between systems using modern tools and best practices.
Build and maintain Power BI dashboards and data models to support business intelligence and reporting needs.
Collaborate with cross-functional teams to gather requirements, understand data needs, and deliver effective solutions.
Ensure data quality, security, and governance across both legacy and modern data platforms.
Document data architecture, processes, and workflows to support maintainability and knowledge sharing.
Monitor and troubleshoot data systems and integrations, proactively identifying and resolving issues.
Contribute to the planning and execution of the data platform migration strategy, balancing short-term support with long-term transformation goals.
Stay current with industry trends and Azure technologies, recommending improvements and innovations where appropriate.
Understand, debug and troubleshoot SQL, SQL Server databases, Python code and APIs
Education and/or Experience Bachelors degree in Computer Science, Information Systems, Data Engineering, or a related field (Masters degree preferred).
7+ years of experience in data engineering, data development, or database administration roles.
3+ years of experience working with Microsoft Azure data services, including Azure SQL, Data Factory, Synapse, or equivalent.
Strong understanding of data modeling
Strong background in SQL Server, including performance tuning, stored procedures, and database design.
Proven experience developing and maintaining Power BI dashboards and data models.
Development experience using Microsoft T-SQL, Power BI, SSRS, SSIS, Python and API technologies
Hands-on experience with data integration tools and building ETL/ELT pipelines.
Experience supporting and modernizing legacy data systems while transitioning to cloud-based platforms.
Exposure to different database management systems, including RDBMS system (e.g. PostgreSQL), NoSQL technologies, and columnar databases, with a willingness to deepen expertise as needed.
Familiarity with data governance, security, and compliance best practices in cloud environments.
Experience working in cross-functional teams and translating business requirements into technical solutions.
Background in Construction, Single Family, Multi-Family, and/or Commercial Property Management and/or Accounting is a plus
Familiarity with CI/CD practices and tools (e.g., Azure DevOps) for deploying data pipelines, infrastructure as code, and analytics solutions.
Skills/Specialized Kno w ledge Excellent communication, time management and organizational skills
Solid understanding of data structures and design patterns
Strong analytical and problem-solving skills
Ability to work in a deadline driver fast paced environment and handle multiple projects simultaneously with a high level of autonomy while being a team player
Willingness and ability to learn and research independently
Sense of Urgency of delivery and ownership of work products
Mill Creek is an Equal Opportunity Employer Are you ready to contribute to the success of Mill Creek Residential? If so, apply today and become part of an organization that believes in uncompromising integrity, celebrating successes, continuous improvement, and working hard, smart and together! #J-18808-Ljbffr
Design and implement scalable, secure, and efficient data solutions in Microsoft Azure, including Azure SQL, Data Factory, Synapse, and related services.
Develop and optimize data pipelines, ETL/ELT processes, and integrations between systems using modern tools and best practices.
Build and maintain Power BI dashboards and data models to support business intelligence and reporting needs.
Collaborate with cross-functional teams to gather requirements, understand data needs, and deliver effective solutions.
Ensure data quality, security, and governance across both legacy and modern data platforms.
Document data architecture, processes, and workflows to support maintainability and knowledge sharing.
Monitor and troubleshoot data systems and integrations, proactively identifying and resolving issues.
Contribute to the planning and execution of the data platform migration strategy, balancing short-term support with long-term transformation goals.
Stay current with industry trends and Azure technologies, recommending improvements and innovations where appropriate.
Understand, debug and troubleshoot SQL, SQL Server databases, Python code and APIs
Education and/or Experience Bachelors degree in Computer Science, Information Systems, Data Engineering, or a related field (Masters degree preferred).
7+ years of experience in data engineering, data development, or database administration roles.
3+ years of experience working with Microsoft Azure data services, including Azure SQL, Data Factory, Synapse, or equivalent.
Strong understanding of data modeling
Strong background in SQL Server, including performance tuning, stored procedures, and database design.
Proven experience developing and maintaining Power BI dashboards and data models.
Development experience using Microsoft T-SQL, Power BI, SSRS, SSIS, Python and API technologies
Hands-on experience with data integration tools and building ETL/ELT pipelines.
Experience supporting and modernizing legacy data systems while transitioning to cloud-based platforms.
Exposure to different database management systems, including RDBMS system (e.g. PostgreSQL), NoSQL technologies, and columnar databases, with a willingness to deepen expertise as needed.
Familiarity with data governance, security, and compliance best practices in cloud environments.
Experience working in cross-functional teams and translating business requirements into technical solutions.
Background in Construction, Single Family, Multi-Family, and/or Commercial Property Management and/or Accounting is a plus
Familiarity with CI/CD practices and tools (e.g., Azure DevOps) for deploying data pipelines, infrastructure as code, and analytics solutions.
Skills/Specialized Kno w ledge Excellent communication, time management and organizational skills
Solid understanding of data structures and design patterns
Strong analytical and problem-solving skills
Ability to work in a deadline driver fast paced environment and handle multiple projects simultaneously with a high level of autonomy while being a team player
Willingness and ability to learn and research independently
Sense of Urgency of delivery and ownership of work products
Mill Creek is an Equal Opportunity Employer Are you ready to contribute to the success of Mill Creek Residential? If so, apply today and become part of an organization that believes in uncompromising integrity, celebrating successes, continuous improvement, and working hard, smart and together! #J-18808-Ljbffr