Job Title: Data Warehouse Developer - Mid Level (3-5 yrs.)
Location: Denver, CO / Open to Remote
Duration: 7 Months with possible extension
Job Summary:
In this role you will be contracted to build and maintain scalable data pipelines on Google Cloud Platform (GCP) to serve our cyber security data mart customers in building an asset inventory. You will work closely with cross-functional teams to ensure data integrity, reliability, and scalability. Your expertise in Google BigQuery, Google Cloud Storage, Cloud Composer, Python, and SQL will be crucial in developing effective data solution that support our security analytics and reporting efforts.
What you're good at: • Design, build, and maintain scalable data pipelines using Google Cloud Platform tools such as BigQuery, Cloud Storage, and Cloud Composer. • Develop and optimize SQL queries to support data extraction, transformation, and loading (ETL) processes. • Collaborate with cross-functional teams, including business customers, Subject Matter Experts, to understand data requirements and deliver effective solutions. • Implement best practices for data quality, data governance and data security. • Monitor and troubleshoot data pipeline issues, ensuring high availability and performance. • Contribute to data architecture decisions to provide recommendations for improving the data pipeline. • Stay up to date with emerging trends and technologies in cloud-based data engineering and cyber security. • Exceptional communication skills, including the ability to gather relevant data and information, actively listen, dialogue freely, and verbalize ideas effectively. • Ability to work in an Agile work environment to deliver incremental value to customers by managing and prioritizing tasks. • Proactively lead investigation and resolution efforts when data issues are identified taking ownership to resolve them in a timely manner. • Ability to interoperate and document processes and procedures for producing metrics.
Must Have: • Bachelor's or master's degree in computer science, Information Systems, Engineering, or related field. • 3 - 5 years of hands-on experience with data management in gathering data from multiple sources and consolidating them into a single centralized location. Transforming the data with business logic in a consumable manner for visualization and data analysis. • Strong expertise in Google BigQuery, Google Cloud Storage, Cloud Composer, and related Google Cloud Platform (GCP) services. • Proficiency in Python and SQL for data processing and automation. • Experience with ETL processes and data pipeline design. • Excellent problem-solving skills and attention to detail. • Strong communication and collaboration.
Nice to Have • Experience with other GCP Services like Dataflow, Pub/Sub, or Data Studio. • Knowledge of DevOps practices and tools such as Terraform. • Familiarity with data visualization tools such as Tableau, Grafana, and/or Looker. • Understanding Cyber Security data tools and analysis methodologies. • One or more of the following certifications preferred: CompTIA Sec+, CISM, CISSP, CRISC and / or CISA. • Understanding of security control frameworks such as NIST, CIS controls, COBIT, ISO etc.
About Us: Established in 2004, SPECTRAFORCE® is one of the largest and fastest-growing diversity-owned staffing firms in the US. The growth of our company is a direct result of our global client service delivery model that is powered by our state-of-the-art A.I. proprietary talent acquisition platform, robust ISO 9001:2015/ISO 27001 certified processes, and strong and passionate client engaged teams. We have built our business by providing talent and project-based solutions, including Contingent, Permanent, and Statement of Work (SOW) services to over 140 clients in the US, Canada, Puerto Rico, Costa Rica, and India. Key industries that we service include Technology, Financial Services, Life Sciences, Healthcare, Telecom, Retail, Utilities and Transportation. SPECTRAFORCE is built on a concept of "human connection," defined by our branding attitude of NEWJOBPHORIA®, which is the excitement of bringing joy and freedom to the work lifestyle so our people and clients can reach their highest potential. Learn more at: http://www.spectraforce.com
Benefits: SPECTRAFORCE offers ACA compliant health benefits as well as dental, vision, accident, critical illness, voluntary life, and hospital indemnity insurances to eligible employees. Additional benefits offered to eligible employees include commuter benefits, 401K plan with matching, and a referral bonus program. SPECTRAFORCE provides unpaid leave as well as paid sick leave when required by law.
Equal Opportunity Employer: SPECTRAFORCE is an equal opportunity employer and does not discriminate against any employee or applicant for employment because of race, religion, color, sex, national origin, age, sexual orientation, gender identity, genetic information, disability or veteran status, or any other category protected by applicable federal, state, or local laws. Please contact Human Resources at LOA@spectraforce.com if you require reasonable accommodation.
California Applicant Notice: SPECTRAFORCE is committed to complying with the California Privacy Rights Act ("CPRA") effective January 1, 2023; and all data privacy laws in the jurisdictions in which it recruits and hires employees. A Notice to California Job Applicants Regarding the Collection of Personal Information can be located on our website. Applicants with disabilities may access this notice in an alternative format by contacting NAHR@spectraforce.com.
LA County, CA Applicant Notice: If you are selected for this position with SPECTRAFORCE, your offer is contingent upon the satisfactory completion of several requirements, including but not limited to, a criminal background check. We consider qualified applicants with arrest or conviction records for employment in accordance with all local ordinances and state laws, including the Los Angeles County Fair Chance Ordinance for Employers (FCO) and the California Fair Chance Act (FCA). The background check assessment will consider whether a criminal history could reasonably have a direct, adverse impact on the job-related safety, security, trust, regulatory compliance, or suitability for this role. Such findings may result in withdrawal of a conditional job offer.
At SPECTRAFORCE, we are committed to maintaining a workplace that ensures fair compensation and wage transparency in adherence with all applicable state and local laws.