Cloud Data Engineer SQL Developer

We Care. We Deliver. Our purpose is to create communities our residents are proud to call home. We currently own or manage over 70,000 units in North America and continue to grow.

Bell Partners, https://bellpartnersinc.com/overview/a national leader in multi-family housing, our mission is to be the apartment company of choice by creating value and honoring commitments to our residents, partners, and associates.

*Not A Remote Position

The Cloud Data Engineer/SQL Developer understands the criticality of database integrity in terms of architecture, security, efficiency, and maintainability. A strong working knowledge of relational database management systems will be required. Works well from written specifications and pre-established guidelines to perform the functions of the job and maintains documentation of process flow.

The Cloud Data Engineer/SQL Developer understands the criticality of database integrity in terms of architecture, security, efficiency, and maintainability. A strong working knowledge of relational database management systems will be required. Works well from written specifications and pre-established guidelines to perform the functions of the job and maintains documentation of process flow.

Essential Functions and Responsibilities

• Be able to perform his/her duties under pressure, be self-motivated and possess the ability to work independently with minimum supervision.
• Participate in Scrum meetings to properly plan, report, and execute work.
• Works closely with key members of other job functions to gather and discuss requirements.
• Investigates new technologies that may add impactful value to development process.
• Assists in creation of database management procedures.
• Develop documentation around existing database architecture.
• Act as mentor to colleagues through code reviews and technical discussions
• Collaborate with other developers to produce high quality software products that delivers business value and follows established design patterns.
• Develop, code, test, and debug application programs of varying degree of complexity.
• You may provide guidance, assistance, and technical leadership to junior level software engineers on more complex/large projects.
• Interacts internally/externally on an as needed basis to exchange information.
• Experience of database design/modelling, knowledge of RDBMS concepts is required.
• Works closely with the project manager and assigned project team to review and ensure the on-time delivery of complex IT solutions.

Additional Functions and Responsibilities

• Ability to travel as business needs dictate.
• Assists with other tasks and projects as requested.

Knowledge/Skills/Abilities

• 5+ years of hands-on experience in MS SQL Server writing complex T-SQL queries, stored procedures, functions etc.
• 5+ years of ETL development using Azure Data Factory (experience with SSIS a plus)
• 5+ years of experience with building data pipelines and analytics solution to stream and process datasets at low latencies.
• 5+ years of experience with complex data modelling, ELT/ETL design, and using large databases in a business environment. Experience ingesting data from various source formats viz. Parquet, csv, SQL databases, SharePoint, APIs etc. to Azure SQL databases.
• 3+ years of experience with SSAS (SQL Analysis Services) Tabular and Multi-Dimensional cubes/models. Experience writing DAX expressions a plus.
• Expertise in ELT/ETL optimization, designing, coding, and tuning big data processes using Azure Data Factory.
• Advanced experience in SQL Server relational database management systems
• Extensive understanding and knowledge in data analytics and reporting (TSQL, SSRS, Power BI, etc.)
  • Strong Knowledge of data warehousing frameworks and methodologies.
• Knowledge of Data Engineering and Data Operational Excellence using standard methodologies.
• Knowledge & experience with CI/CD processes.
• Knowledge & experience with Azure DevOps.
  • Knowledge of QA tools (manual and automated)
• Experience in data mining, profiling, and analysis
• Experience with usage of source control within a team environment (Git, TFS etc.)
• A strong understanding of database design best practices
• Experience with Azure - setting up and monitoring databases, users & access rights.
• Experience with Yardi system is a big plus.

Education & Background

• An advanced knowledge of SQL, as well as experience with advanced financial modeling tools, is preferred.
• Candidate must have a bachelor's degree or master's degree in a related field, or equivalent work experience.
• Knowledge of Microsoft Excel is required, as well as general knowledge of other Microsoft Office 365 applications.
• Candidate must be a strong communicator and be comfortable dealing with all levels.
• Experience in the multifamily industry preferred

Bell Partners, Inc. ("BPI" or the "Company") is an equal employment opportunity employer. BPI's policy is not to discriminate against any applicant or employee based on race, color, sex, religion, national origin, age, disability, pregnancy, military/veteran status, marital status, genetic information, gender identity, sexual orientation or any other basis protected by applicable federal, state, or local laws. BPI also prohibits harassment of applicants or employees based on any of these protected categories. It is BPI's policy to comply with all applicable state and federal laws respecting consideration of unemployment status in making hiring decisions.

Note to Applicants: Smoking is prohibited in all indoor areas of Bell Partners Inc. unless designated smoking areas have been established by a particular location in accordance with applicable state and local law.