Data Integration Principal

Description

Who We Are:

Dedicated to making a difference in law enforcement agencies across the U.S., our mission is to transform policing by elevating officer performance with a preventative-based early intervention system. Driven by data science and powered by machine learning, our offering analyzes officer performance data in order to identify potentially problematic behavior. In partnership with the University of Chicago, we’ve developed the world’s largest multi-jurisdictional officer performance database, and the only research-driven, evidence-based early intervention system available in policing today.

We’re also the only provider of a fully integrated, cloud-based Software-as-a-Service (SaaS) platform that simplifies essential policing workflows. This platform is designed to be a single-source solution for all operational needs, driving extensive efficiency gains and providing best-in-class advanced analytics and insights.

Benchmark Analytics provides a comprehensive, all-in-one solution that is advancing police force management through state-of-the-art technology and market-leading data and analytics.

The Role

We are currently seeking a talented Data Integration Principal to join us as we develop our data driven, analytic focused and predictive products to help revolutionize the law enforcement sector.

Responsibilities

• Design and implement efficient data extraction processes that meet client, and internal stakeholder needs while maintaining data accuracy and completeness
• Extract data from diverse client source systems to ensure effective and complete transfer of data
• Work directly with clients (onsite and/or remotely) to identify and extract data from numerous distinct data systems
• Create data extraction processes within client systems which enable the continual delivery of client data from source system to target system
• Document data extraction processes and provide support to clients as needed to ensure effective and continual delivery of data
• Analyze and manipulate large file-based and server-based datasets using data transformation tools (Sagemaker, Clover, Athena, Etc.) to effectively map data from source systems to target systems
• Continuously optimize these processes to increase efficiency, scalability and quality of data
• Import received data into internal Benchmark Data Systems, ensuring completeness and retention of data meaning.
• Validate received/extracted data for completeness to ensure that data meets data science and system requirements
• Troubleshoot and resolve any data extraction issues that may arise
• Identify data quality issues, investigate and complete root cause analyses and work with the appropriate teams to resolve them
• Monitor data integration and extraction processes to ensure they are running efficiently and effectively
• Work with the research, product, and engineering teams to critique and iteratively improve data extraction and integration processes, to ensure that data is being collected and stored in an efficient, accurate, and scalable manner
• Develop and maintain data models and schemas that enable efficient data access and analysis
• Periodic travel within the United States required
  
  

Job Qualifications

• Bachelor's or Master’s degree in computer science, data science, or related fields
• 8 years of experience in databases, data extraction, data integration, or a related field
• Ability and willingness to teach/coach others
• Proficiency in SQL, Python, and other scripting languages
• Strong understanding of data integration and extraction technologies and processes
• Strong understanding of data warehousing concepts, ETL tools, and data modeling techniques
• Experience with data validation and quality assurance processes
• Strong analytical and problem-solving skills
• Experience at a consulting company preferred
• Excellent written and verbal communication skills
• Ability to work independently and as part of a team
• Strong organizational skills and attention to detail
• Ability to work in a fast-paced environment and manage multiple projects simultaneously
• Fluent Proficiency in Spanish Preferred
  
  

What We Offer

• A competitive salary and benefits package.
• Unlimited paid time off (PTO).
• Ability to work in a fully remote environment (must be based in the U.S. and willing to work in Central Time Zone).
• Medical, dental, and vision plan offerings along with 401(k).
• Employer-paid Short-Term Disability, Long-Term Disability, and Life Insurance.
• Other Voluntary Benefits include additional Life Insurance, Spouse Life Insurance, and Accident Insurance.
• The satisfaction that comes with being part of a solution that has real impact in the world.
• A diverse workforce and inclusive environment that embraces unique contributions and experiences.
• An empowered culture that encourages creativity and professional growth.
  
  

How To Apply

• Benchmark Analytics is an Equal Opportunity Employer. We value diversity of all kinds in our effort to create a stellar workforce of committed and passionate team members.
• Unfortunately, we are not able to sponsor employment visas at this time, so we can only accept applications from candidates who are authorized to work in the U.S.
• If interested, please apply online and/or email your resume to v.lauren.ritter@benchmarkanalytics.com