Data Engineer

Job description

General Summary

The real estate industry has rapidly progressed with new Multiple Listing Service (MLS) programs and tools for Realtors®, retail buyers, and other industry stakeholders. While new entrants to the marketplace continually drive change, at MRED, we believe that MLS providers are a vital part of making the market work. As guardians of MLS data, we regularly pioneer cutting-edge tools to keep real estate professionals at the top of their industry. It is imperative that we provide support on those tools to Realtors®, so they can accomplish their day-to-day business. To assist us with this, we seek a Full-Time Data Analyst to join our team.

Midwest Real Estate Data (MRED) is the innovative MLS that provides real estate professionals in Chicagoland and the surrounding area with the most comprehensive database, technology, and support with which to enable their success. MRED is one of the largest MLSs in the country, a recipient of numerous awards, and is highly recognized as an industry leader. MRED delivers dozens of products and services to its customers, including the top-rated MLS system, connectMLS.

Who You Are…

As a Data Analyst, you are a part of our Technology team, and your excitement to derive insights from our treasure trove of data is what gets you up for every workday. Finding the hidden patterns of the key analytics that give our more than 48,000 Subscribers exclusive insights to share with their clients defines your success in this position. Our Core Values include being a Caretaker of Data, and we take our role as an MLS seriously when it comes to our Subscribers' data.

Your responsibilities will include working towards the current data strategies, building/automating real-time reports to support various verticals in the company, ad-hoc report requests, and maintaining overall data quality. Supporting the Business Intelligence initiatives such as standing up our data lake and subsequent data warehouses with our development and data delivery partners and creating unique datasets around MLS-related traffic data to return to our brokerages. More importantly, we will lean on you to explore more datasets that could guide us to discoveries that create value for our current Subscribers and support future expansion to new markets.

Technically, we are looking for you to be proficient in SQL, Python/R, automation, and ETL processes, with a strong ability to read data models and build curated datasets for analytics. You will also be tasked to extract data from databases and warehouses for reporting and facilitate sharing between multiple data systems.

MRED is a distributed workforce model, looking to hire the best irrespective of the location. Your work schedule can be non-linear with attendance at project/staff meetings to develop and cultivate cross-departmental relationships and knowledge.

Duties and Responsibilities

• Reports to the BI Architect
• Build/maintain ETL pipelines and perform data warehouse support activities
• Writing advanced SQL to effectively query and navigate multiple data domains to produce data analysis findings. Able to use complex joins, subqueries, and analytical functions to return clean, comprehensive, and relevant datasets.
• Ingestion of data from API, streaming, and batch source systems
• Troubleshoot data quality issues and anomalies and offer data findings and analysis outcomes
• Work with current analytics providers to support existing product functionality and design.

Our top behavioral traits of our ideal Data Analyst candidate:

• Curious and always questioning
• Learning is one of your favorite activities
• Effective communicator with various levels of stakeholders
• Ability to actively listen
• Detail and achievement-oriented
• Autonomous self-manager with the right strategic direction in place
• Fun to work with
• Positive attitude

Skills and Qualifications

• Bachelor's degree or higher in Computer Science, Statistics, Engineering, or equivalent experience
• Strong understanding of SQL Server, EDM, SDLC, ETL
• 4+ years of professional experience as a Data Engineer
• 4+ years of experience with SQL, Python
• Working knowledge of Web API, REST, XML/JSON
• Familiarity with GIT
• Experience with Microsoft Azure, SQL Server, Alteryx, ETL/ELT, Data Modeling

Benefits

• 401(k)
• 401(k) Matching
• Dental Insurance
• Flexible Spending Account
• Health Insurance
• Paid Time Off
• Vision Insurance
• Bonus opportunities
• Work Remotely
• Staff parties

Job Type: Full-time

MRED staff can (and do) work remotely.