Job Title: Data Engineer
Location: Remote
Salary: $80,000 - $120,000, depending on skills and experience
Position Overview: CAP Index is seeking a highly skilled Data Engineer to join the Research & Innovation team to significantly enhance the collaborative growth between R&I and the Systems Development team. This role provides an opportunity to engage in creative engineering of data processes in the field of crime and public safety. The position involves developing and refining data systems that build risk models for the United States, Canada, Mexico, and the United Kingdom, as well as sophisticated custom risk models for individual corporations. The candidate will play a key role in enhancing data architecture and pipeline systems to effectively handle and interpret complex datasets, aiding in decision-making for businesses, government, and organizations regarding safety and security measures.
Qualifications:
- Advanced Degree preferred in Computer Science, Information Technology, or Data Science. Alternatively, a degree in a social science field with a strong quantitative focus qualifies. This degree should ideally be supplemented with additional coursework, certifications in data analysis or computer programming, and/or a work portfolio.
- 5+ years of experience in building and optimizing 'big data' pipelines, architectures, and data sets to support business growth and analytics initiatives.
- Proficiency in SQL and experience with scripting languages such as Python or Java; familiarity with SAS is a plus but not required.
- Demonstrated strength in using Microsoft Azure cloud services for data solutions, including O365, Teams, Sharepoint, Azure Data Factory, Azure Databricks, and Azure SQL Database.
- Practical knowledge of message queuing, stream processing, and highly scalable 'big data' stores on Azure.
- Solid experience with relational SQL and NoSQL databases, including MSSQL and PostgreSQL.
- Experience with data modeling, data warehousing, and building ETL pipelines using Azure-based tools.
- Proficiency in Geographic Information Systems (GIS) and tools like ArcGIS or QGIS for spatial data analysis.
- Strong understanding of data governance principles, data security, and compliance requirements.
Key Responsibilities:
- Data Systems and Architecture: Design, implement and optimize data engineering processes to efficiently collect, integrate, and manage neighborhood-level crime and public safety data. Design and build scalable data pipelines that support the extraction, transformation, and loading (ETL) of large datasets into systems for analysis and modeling. Utilize these pipelines to facilitate the creation of predictive models and risk assessments, ensuring data accuracy and accessibility for timely and effective decision-making.
- Data Quality Management: Ensure the integrity and accuracy of data through rigorous quality control, including the development of automated validation processes.
- Client-Focused Solutions: Design and engineer robust data pipelines and architectures that facilitate the creation of client-specific tools and indices. These solutions will leverage crime, public safety, and client data to help stakeholders understand and mitigate risks associated with their specific industries and locations. Focus on integrating and transforming diverse data sources into actionable insights and predictive models that support decision-making and strategic planning for enhanced security measures.
- Collaboration and Communication: Work with cross-functional teams within the organization and maintain communication with external stakeholders, including law enforcement, businesses, and academic partners, to align data engineering efforts with broader research and operational goals.
This position is ideal for a candidate passionate about using their technical skills to make significant contributions to public safety and crime prevention. If you are ready to use your expertise in data engineering to help shape safer communities and work environments, we encourage you to apply.
To do so, please submit your resume detailing your relevant experience and any supporting materials (e.g., portfolio, certifications) through this form – Click Here. If there are any questions, please reach out to Grant Drawve at gdrawve@capindex.com.
CAP Index provides the products and services organizations need to intelligently develop and manage security programs. We provide site-specific data, consulting, analytics, and security management technology to accurately assess the risk of crime and loss at business, government, and residential locations. CAP Index is an equal opportunity employer. We value diversity and encourage applications from candidates of all backgrounds and experiences.
For more information about CAP Index, see https://capindex.com/
