What are the responsibilities and job description for the Data Engineer - Technical Lead position at KEA?
We have an immediate opportunity for a Data Engineer to join our technology team in a technical lead capacity. In this role, you will be responsible for creating, maintaining, and scaling data systems & processes that are essential to the success of our business. This position, and KE Andrews as a company, is geared towards individuals with a long-term outlook that want to turn a role into a career, not just work a job.
Responsibilities
- Work with public & private commercial real estate and oil & gas data, such as leasing, sales, and ownership details.
- Collaborate with multi-department teams to identify requirements for the data-oriented components of larger systems.
- Create & maintain data-oriented system components and processes. This includes ETL processes & data pipelines in our on-prem hardware & software environment, and similar data components on Databricks. There is a big opportunity for leadership in the Databricks space - we have only scratched the surface of what we can do on this platform.
- Collaborate with business stakeholders to determine requirements for smaller data analysis or support tasks.
- Support business stakeholders by performing data analysis and resolving technical issues.
- Serve as a technical mentor for other members of our data team.
Preferred Qualifications
- Bachelor's degree in Data Science, Computer Science, or a related field.
- Proficiency with GitHub and experience working in version-controlled software development workflows.
- Strong Python skills, especially in team-oriented settings. You use type hints, manage virtual environments, and have built Python applications that are portable across different systems and environments.
- Strong SQL and data modeling skills. You design well-structured databases, normalize data appropriately, and create efficient schemas and tables to model complex relationships. You write optimized queries and use strategic indexes to ensure performance and scalability.
- Experience and interest in designing and developing on Databricks.
- Familiarity with Tableau, Alteryx.
- Ability to communicate effectively with technical and non-technical team members.
- The belief that lifelong learning is one of the most appealing aspects of software and data engineering.
Our current technology environment:
Here is a more complete picture of the technologies we work with. Data components interact with all of these in one way or another. There will be opportunities to branch out beyond strictly data engineering tasks if you are interested and capable.
- Frontend: Functional React, Typescript, react-query, ag-grid-react, react bootstrap, bootstrap sass classes
- Backend: C#, .NET Framework, EF6 and Dapper, Service-Repository Pattern
- Persistence: MSSQL, Elasticsearch, RabbitMQ
- Utilities: Python, Powershell
- Devops: On prem hosting (Windows servers), Team City
- Project management: Github, Jira
- Integrations: Microsoft Form Recognizer, GIS data, LLMs
- Data: Python, MSSQL, R, MS Form Recognizer / Document Intelligence, Databricks, Alteryx, Tableau, Excel
Perks:
- 9/80 and 4.5/40 Opportunities
- Hybrid work schedule
- Comprehensive health and dental benefits.
- 401(k) with 4% automatic contribution.
