Data Engineer
Full Time
Professional
Remote, US
Company Overview
Protos Security (“Protos” or the “Company”) is the largest technology-enabled Security Officer Management company in the U.S. Protos offers its clients a customized and integrated approach to managing security officer programs, video monitoring solutions and video equipment services through over 4,000 vendors, comprising the industry’s largest network of screened and vetted security officers, combined with state-of-the-art technology and data analytics. The Company also offers security officers through its in-house manned guard division and provides clients with workforce and vendor management software solutions. Protos delivers holistic security risk mitigation services to Fortune 500 clients throughout North America, Puerto Rico and the Caribbean.
Protos was the first, and remains the only, security management company to provide clients with uniformity in timekeeping, incident reporting and useful data analytics that are accessible 24/7 through its proprietary platform. When coupled with a dedicated Client Account Manager, Protos provides a full suite of security solutions that (i) reduces the client’s administrative burden, (ii) improves the quality of service through a flexible, deep vendor network, (iii) enables clients to gain actionable insights/analytics on performance, and (iv) yields superior customer service when compared to other national competitors.
The software division of Protos Security is known as Protos Labs. Protos Labs is a continuous delivery software organization, averaging six releases to production components or operational software per day. We host in Amazon Web Services, leveraging DynamoDB, Lambda, Elastic Search, Aurora, RDS, SQS, Elastic Beanstalk and others.
Position Overview
We are seeking a skilled and motivated SQL, Python, and DBT Developer with a strong background in data warehousing and ELT (Extract, Load, Transform) processes to join our Data Services team. The ideal candidate will have hands-on experience in building databases within Snowflake, integrating FiveTran pipelines, and leveraging DBT for transformation and modeling.
Responsibilities
- Collaborate closely with cross-functional teams to design, develop, and optimize ELT processes within a cloud-based Data Warehouse environment.
- Utilize your strong understanding of DBT to stage, clean, transform, and test data; create and maintain data models; develop macros and operations; follow version control and CICD best practices that ensure efficient and accurate data processing and consumption.
- Work with extraction/load tools such as FiveTran to ensure smooth data extraction and loading from various source systems into Snowflake.
- Craft, implement, and optimize SQL queries and python scripts to extract, clean, transform, aggregate, join, analyze, test, and troubleshoot data effectively, while ensuring data quality and integrity.
- Perform Datawarehouse Quality Assurance tasks including developing automated testing, validating data inputs and analytical results, ensuring referential integrity and other constraints are always met, diagnosing and resolving errors, among other tasks.
- Create data visualizations to validate, analyze, and consume the information available in the Datawarehouse.
- Work with stakeholders to gather requirements, understand data-related needs, and translate them into technical solutions using DBT and Snowflake.
- Design, develop, and maintain documentation for data models, transformations, and processes to ensure knowledge sharing and team collaboration.
- Monitor and troubleshoot data integration, transformation, and loading processes to identify and resolve issues proactively.
- Assist with the refactoring and optimization of architectural integrities and analytics ready tables to improve data quality within the data warehouse.
Necessary Qualifications and Skills
- Bachelor's Degree in Computer Science, Information Technology, or a related field, or equivalent work experience.
- Minimum of 3 years of Data Engineering experience.
- Proven experience as a DBT Developer or similar role with a focus on data transformation processes and Snowflake data warehousing.
- Strong command of SQL and python for data manipulation, querying, and transformation.
- Familiarity with cloud-based Data Warehousing solutions, particularly Snowflake.
- Excellent problem-solving skills and attention to detail in ensuring data accuracy and quality.
- Effective communication skills to collaborate with technical and non-technical stakeholders.
- Ability to work independently and as part of a team in a fast-paced, dynamic environment.
- Prior experience in optimizing and troubleshooting data processes for performance and reliability.
- Familiarity with agile development methodologies and version control systems is a plus.
- Experience with Git and CI/CD.
Preferred Qualifications and Skills
- Certification in Snowflake or DBT is highly desirable.
- Experience with other cloud platforms such as AWS Aurora
- Previous exposure to FiveTran or similar data integration tools.
- Knowledge of data governance practices and data security considerations in a cloud environment.
- Experience developing big-data pipelines in pySpark or similar technology for batch or near-real-time (streaming) use cases.
Compensation
Compensation includes base salary and a discretionary and performance based year-end bonus. The Company offers a competitive benefits package including medical, dental, vision, 401(k), disability, PTO, etc.
