Data Engineer
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.
Our tech solutions:
- Reduce traffic fatalities
- Enhance pedestrian accessibility
- Empower system operators to save time & money
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.
***Must be located with D.C. Metro region
Who You Are:
We are looking for a versatile and adaptable Data Engineer 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.
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.
Expected Duties:
- Collaborate closely with data scientists, software engineers, and other stakeholders to develop and implement data-driven solutions that transform transportation systems.
- 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
- Optimize database structures and data models for performance and scalability.
- Ensure data quality and integrity by implementing data validation and cleansing techniques.
- 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.
- Work with cloud computing infrastructure to adequately scale data pipelines while actively maintaining cost efficiency and speed.
- Research and evaluate emerging technologies, tools, and frameworks to enhance data engineering processes.
- Adapt quickly to changing requirements and priorities in a startup environment.
- Mentor and guide junior engineers, fostering a culture of continuous learning and growth within the team.
- Collaborate closely with cross-functional teams to align engineering efforts with product and business objectives.
- Drive innovation and brainstorming sessions to tackle transportation engineering challenges and develop cutting-edge solutions.
- Implement modern solutions and tools to enhance the efficiency and effectiveness of our software development processes.
- Ensure the team meets tight deadlines and delivers high-quality software solutions consistently.
- Scale yourself by effectively coordinating solutions for operational problems, bugs, requirements, and processes.
- Adapt to change and be flexible in expectations, goal settings, and technology choices.
- Challenge team members to achieve their best while fostering a culture of productivity and excellence.
- Engage in data science work, leveraging your expertise to contribute to the development of data driven solutions.
Required Skills & Experience:
- Bachelor's in Computer Science, Data Science, or a related field
- 2+ years of experience in data engineering, preferably in a startup or fast-paced environment, with prior leadership roles
- Strong proficiency in SQL (for DDL operations, DML operations, data architecture, etc.)
- Strong proficiency in Python and Jupyter (for exploratory data analysis, writing scripts, aggregating datasets, working with data scientists/GIS developers, etc.)
- Knowledge of data modeling, data warehousing, and ETL processes
Experience with cloud-based data platforms such as Snowflake and AWS
- Experience working with DBMSs such as PostgreSQL and MySQL
- Familiarity with extracting, analyzing, and mapping geospatial data and GIS systems
Familiarity with distributed systems and big data technologies such as Apache Spark
- Understanding of data visualization concepts and tools
- Strong problem-solving and analytical skills
- Excellent communication and collaboration skills
- Ability to work independently and adapt to changing priorities
- Passion for learning and keeping up with the latest trends in data engineering and technology
Your Citian Advantage:
- Competitive salary and benefits package including medical, dental, and vision insurance and generous PTO.
- 401(k) company match and monthly commuter transportation benefit
- On-site gym and free snacks in the office
- High-growth potential and opportunities for advancement within a fast growing, venture-backed SaaS startup!
Let's build smarter cities together! Learn more about Citian here: www.citian.co
** Citian is an organization committed to diversity and inclusion to drive our business results and create a better future every day for our diverse employees, clients, partners, and communities. We believe a diverse workforce allows us to match our growth ambitions and drive inclusion across the business. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, age, national origin, or protected veteran status and will not be discriminated against on the basis of disability.
Equal Opportunity/Affirmative Action Employer Minorities/Females/Protected Veterans/Persons with Disabilities