BI Developer

United States /
Keller Williams Realty International – Technology /
Full-Time
Keller Williams Realty, Inc. (KWRI)
Keller Williams Realty, Inc. is the foremost provider of real estate solutions, offering the most comprehensive end-to-end portfolio of products, services, and training in the industry.   KWRI is made up of a diverse team of more than 300 passionate professionals who are redefining the global real estate industry.  KWRI supports and innovates on behalf of over 180,000 Keller Williams real estate professionals around the world.  KWRI’s headquarters employs a diverse group of strategists, innovators, storytellers, and technologists who help transform the way agents market, sell, and interact with their clients.  KWRI’s on-site learning center and extensive Career Visioning program support the company’s emphasis on teamwork while allowing individuals with all backgrounds to explore and grow together.
 
Keller Williams Core Values ResponsibilityEvery member of the Keller Williams leadership team is responsible for leading and modeling diverse, equitable, and inclusive practices in the workplace relative to hiring, promoting, paying, and managing people. Leaders are expected to treat all people with civility, respect, and dignity and demonstrate the 10 core values that form our belief system.



As the largest real estate franchise company in the United States, our goal is to lead with technology that is disruptive in the real estate industry. You will be joining fast-paced teams in developing SaaS applications for our franchise (US and Worldwide) offices and real estate agents to operate their independent real estate businesses.

We’re looking for an innovative, talented team member who has been working as a BI Developer at an enterprise level for more than 3 years to join our team! You will contribute to our data pipelines that are used everyday in our internal and external products and services.

Essential Duties and Responsibilities:

    • Take an active role aiding in the shaping and delivery of our long-term BI platforms and strategy that will support the delivery of Business Intelligence solutions
    • Oversee or aid in the oversight of the design, development, and maintenance of various reporting & analytical solutions
    • Work with the BI developers on staff to coordinate efforts for delivering the right solutions at the right time. Providing both ongoing support and future developments
    • Taking an active role in the design, development, testing, and validation of all aspect of analytical solutions as outlined by technical and functional requirements
    • Work directly with external vendors and resources for daily and project activities, as needed
    • Take an active role in maintaining and improving BI \ Report Development practices, standards, procedures, and controls
    • Maintaining data loads for 500 disparate sources from multiple providers
    • Create, develop and document data mapping rules
    • Work with the downloader development team to give direction for how we want to download data using industry standard best practices
    • Develop data cleansing and transformation automation
    • Make improvements and logging for the transformation process
    • Utilize tools and programs to analyze and convert data to a standardized format
    • Develop continuous process improvements
    • Identify and fix “data bugs” and improve the overall quality of information
    • Recommend process improvements

Minimum Qualifications:

    • Database development experience (Oracle, PostgreSQL, MongoDB, BigQuery)
    • Advanced SQL knowledge
    • Programming experience with Python with a focus on working with unstructured data
    • Experience programming in a Linux/UNIX environment including shell scripting
    • Experience with Bash scripts
    • Ability to develop analytical models (e.g., regression, simulation, statistical, etc.) for structured and unstructured data sets with a focus on data lineage to proactively identify risk areas and identify/catch outliers, trends and/or projections, where appropriate
    • Cloud experience in Google GCP and/or Amazon AWS

Preferred Qualifications:

    • 3+ years database development experience (Oracle, PostgreSQL, MongoDB, BigQuery)
    • 3+ years experience with additional languages such as Python, Bash shell
    • Experience Github
    • GCP experience with GCS, Cloud functions, Dataflow, Cloud Composer, Bigquery
    • Ability to develop analytical models (e.g., regression, simulation, statistical, etc.) for structured and unstructured data sets with a focus on data lineage to proactively identify risk areas and identify/catch outliers, trends and/or projections, where appropriate
    • Cloud experience in Google GCP and/or Amazon AWS
    • 3+ years of experience with data architecture, data modeling, schema design, and/or software development
KW is committed to creating a diverse environment and is proud to be an Equal Opportunity Employer. kwx recruits, employs, trains, compensates and promotes regardless of race, religion, color, national origin, gender, gender identity or expression, sexual orientation, national origin, genetics disability, age, veteran status, or other protected status as required by applicable law. All qualified applicants will receive consideration for employment.