Principal Engineer

1872 Consulting; Chicago (IL); Remote; USD 150,000 - 200,000; Full time

Job summary

A leading consultancy in real estate is hiring a Principal Engineer to develop and oversee data systems. The role requires expertise in data architecture and a deep understanding of scalable database solutions. Candidates should possess over 10 years of experience with tools like Snowflake and be capable of mentoring others. This is a fully remote position offering significant contributions to improving the company's data analytics capabilities.

Qualifications

• 10+ years of success in data architecture, data warehousing and data governance.
• Experience with responsive data structures and metadata capture strategy.
• Familiarity with event-driven architectural experience.

Responsibilities

• Develop, optimize, and oversee data systems.
• Create domain and database design reports.
• Ensure system performance through monitoring and development.

Skills

Data architecture

Data warehousing

Data governance

Event-Driven architecture

Transformative data modeling

Tools

Snowflake

Databricks

Spark

Redshift

GBQ

Job description

Principal Engineer - 100% Remote

An industrial real estate supply chain platform we have one of the largest portfolios of industrial space in the US, with over 400 million square feet of high-quality, well-located industrial assets. We actively construct and manage our portfolio to benefit from the shift in consumer expectations for the rapid and direct delivery of goods and the related surge in demand for real estate that addresses the need for "last-mile” distribution. A critical component of our Company's growth is the build out of our financial and data analytics capabilities.

Role Summary

As Principal Engineer, your primary responsibilities will be to develop, optimize, and oversee our company's conceptual and logical data systems. You proactively engage stakeholders to understand internal and external needs, fulfilling requirements with a focus on improving data quality, accessibility and security. This may include demos, solution designs, implementation plans and proof of concepts.

What you'll be doing

• Create domain and database design, and architecture reports for management and executive teams
• Develop solutions to improve new and existing database systems
• Design and implement effective database solutions and models to store and retrieve company data
• Ensure system performance via proactive design, monitoring, troubleshooting and development of new features
• Maintain technical skills and knowledge of market trends and competitive insights; collaborate and share with the technical community
• Be an IT evangelist with customers, stakeholders, partners and communities
• Must be a player-coach, able to architect as well as mentor, lead and help development

Requirements

• 10+ years of success in data architecture, data warehousing and data governance
• Experience with responsive data structures, ontologies, metadata capture strategy
• Event-Driven architectural experience (as opposed to transactional)
• Experience with Transformative data modeling (preferably with Snowflake)
• Scalable distributed systems and databases (e.g. Snowflake, Databricks, Spark, Redshift, GBQ)

Nice to Have's

• Familiarity with TOGAF (The Open Group Architectural Framework)
• Master Data Management in operations, analytics and governance
• Software development practices like DevOps and CI/CD tool chains (i.e. Jenkins, Spinnaker, Azure DevOps, GitHub)
• Familiarity with modern analytics and metadata management tools (e.g. DBT, Looker)
• One or more of the following programming languages preferred: Python, Spark Scala, pyspark, SQL