Data Engineering Lead

About this role

<div class="content-intro"><p>Citian is a fast growing, venture backed SaaS technology company based in Washington, DC. Our software solutions revolutionize how our transportation and infrastructure systems – roads, rail, transit, bicycle, pedestrian – operate.</p> <p>Our tech solutions:</p> <ul> <li><strong>Reduce traffic fatalities</strong></li> <li><strong>Enhance pedestrian accessibility</strong></li> <li><strong>Empower system operators to save time &amp; money</strong></li> </ul> <p>You’ll work with some of the brightest minds in the software and transportation industries. Our engineers and data scientists apply the latest in emerging tech, Artificial Intelligence, and Machine Learning to build smarter, more advanced tools for our diverse client base. We work with clients across the United States, with global ambitions in the years ahead.</p></div><p><strong>Who You Are:</strong></p> <p>We are looking to hire a Data Engineering Lead who thrives in a startup environment. You are someone who enjoys working in a fast-paced and agile setting, where you can make a significant impact and help shape the direction of our data engineering initiatives. You exhibit excellent knowledge of data engineering disciplines, including experience working with large datasets in a Python/SQL environment. You will also have hands-on knowledge of the latest data programming approaches, data structures, distributed DBMS and DB modeling and access languages. Additionally, your ability to architect and build pipelines will contribute to the development of our data-driven solutions.</p> <p>As a self-starter, you are not afraid to take ownership of projects and can handle the challenges that come with a rapidly evolving startup. You are resourceful, innovative, and continuously seek opportunities to improve processes and drive efficiency. Your strong communication and collaboration skills enable you to work effectively with cross-functional teams and stakeholders. If you are passionate about data engineering and are eager to contribute to the success of a startup, we would love to hear from you.</p> <p>&nbsp;</p> <p><strong>Expected Duties:</strong></p> <ul> <li>Collaborate closely with data scientists, software engineers, and other stakeholders to develop and implement data-driven solutions that transform transportation systems.</li> <li>Architect and build scalable and efficient data pipelines and ETL processes to collect, process, and store large volumes of data, playing a crucial role in laying out the processes and foundations of our Data Engineering initiatives</li> <li>Optimize database structures and data models for performance and scalability.</li> <li>Ensure data quality and integrity by implementing data validation and cleansing techniques.</li> <li>Establishing policies, processes, and controls in data governance to ensure the integrity, quality, and security of data assets in a way that achieves regulatory compliance.</li> <li>Work with cloud computing infrastructure to adequately scale data pipelines while actively maintaining cost efficiency and speed.</li> <li>Adapt quickly to changing requirements and priorities in a startup environment.</li> <li>Mentor and guide junior engineers, fostering a culture of continuous learning and growth within the team.</li> <li>Collaborate closely with cross-functional teams to align engineering efforts with product and business objectives.</li> <li>Drive innovation and brainstorming sessions to tackle transportation engineering challenges and develop cutting-edge solutions.</li> <li>Implement modern solutions and tools to enhance the efficiency and effectiveness of our software development processes.</li> <li>Ensure the team meets tight deadlines and delivers high-quality software solutions consistently.</li> <li>Scale yourself by effectively coordinating solutions for operational problems, bugs, requirements, and processes.</li> <li>Challenge team members to achieve their best while fostering a culture of productivity and excellence.</li> <li>Engage in data science work, leveraging your expertise to contribute to the development of data driven solutions.</li> </ul> <p>&nbsp;</p> <p><strong>Required Skills &amp; Experience:</strong></p> <ul> <li>Bachelor's in Computer Science, Data Science, or a related field</li> <li>7+ years of experience in data engineering, preferably in a startup or fast-paced environment, with prior leadership roles</li> <li>Strong proficiency in SQL (for DDL operations, DML operations, data architecture, etc.)&nbsp;</li> <li>Strong proficiency in Python and Jupyter (for exploratory data analysis, writing scripts, aggregating datasets, working with data scientists/GIS developers, etc.)</li> <li>Knowledge of data modeling, data warehousing, and ETL processes</li> <li>Leadership experience preferred</li> </ul> <p>&nbsp;</p> <p><strong>Experience with cloud-based data platforms such as Snowflake and AWS&nbsp;</strong></p> <ul> <li>Experience working with DBMSs such as PostgreSQL and MySQL</li> <li>Familiarity with extracting, analyzing, and mapping geospatial data and GIS systems&nbsp;</li> </ul> <p>&nbsp;</p> <p><strong>Familiarity with distributed systems and big data technologies such as Apache Spark</strong></p> <ul> <li>Understanding of data visualization concepts and tools</li> <li>Strong problem-solving and analytical skills</li> <li>Excellent communication and collaboration skills</li> <li>Ability to work independently and adapt to changing priorities</li> <li>Passion for learning and keeping up with the latest trends in data engineering and technology</li> </ul> <p>&nbsp;</p><div class="content-conclusion"><p><strong>Your Citian Advantage:</strong></p> <ul> <li>Competitive salary and benefits package including medical, dental, and vision insurance and generous PTO.</li> <li>401(k) company match and monthly commuter transportation benefit</li> <li>On-site gym and free snacks in the office</li> <li>High-growth potential and opportunit