Citian's software solutions revolutionize how transportation systems operate, aiming to reduce traffic fatalities, enhance pedestrian accessibility, and empower system operators to save time and money. The company is seeking a Senior Data Engineer to help shape the direction of their data engineering initiatives and build smarter, more advanced tools for their clients.
Requirements
- 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
Responsibilities
- 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.
Other
- Versatile and adaptable Senior Data Engineer who thrives in a startup environment.
- 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.
- Self-starter, not afraid to take ownership of projects and can handle the challenges that come with a rapidly evolving startup.
- Resourceful, innovative, and continuously seek opportunities to improve processes and drive efficiency.
- Strong communication and collaboration skills enable you to work effectively with cross-functional teams and stakeholders.
