Data Analyst

MRIS

Bright MLS is integral to the real estate market in the Mid-Atlantic U.S., facilitating over $100 billion in transactions annually. Recognized for its diversity, Bright MLS offers innovative technology solutions that create an accessible marketplace for real estate transactions. The Data Analyst role on the Data Operations team is vital to enhancing these services by ensuring efficient data processes.

In this role you can expect to have the responsibilities:

• Conduct ETL processes on raw data using Excel, SQL server, and Talend.
• Operate AWS Glue jobs and SQL scripts for automated ETL processing.
• Enhance legacy Python, Glue, and SQL scripts in collaboration with data engineers.
• Maintain ETL scripts in Git repositories.
• Collaborate with Data Engineering and Business Intelligence teams for data solutions.
• Provide ad hoc data analyses using Excel, Python, and SQL.
• Document ETL processes in Confluence.
• Perform data mapping for new integrations.
• Identify and troubleshoot data issues.
• Participate in agile scrum environments to meet project deadlines.

This role comes with the following benefits:

• Annual performance-based bonuses.
• Health, vision, and dental coverage for individuals and families.
• 401(k) plan with employer matching.
• Paid Time Off (PTO) and holidays.

This role requires you to have:

• Proficiency in Microsoft Excel and data datasets.
• Three years experience with relational databases such as MSSQL, MySQL, or MariaDB.
• Understanding of structured and semi-structured data and data modeling.
• Intermediate skills with Python.
• Experience with Git for versioning.

You would benefit from having:

• Experience with AWS Glue and PySpark.
• Understanding business data requirements and de-duplication.
• Familiarity with Business Intelligence tools.
• Experience with Atlassian JIRA and Confluence.
• Knowledge of Single Sign-On technologies like OAuth2 and SAML2.
• Experience with RESTful and OData APIs.
• Real Estate industry experience with MLS understanding.
• Associate degree in computer science or related field.

Bright MLS is committed to a diverse workplace, hiring and promoting individuals without discrimination based on race, religion, gender identity, or other protected characteristics.