Data Warehouse Engineer

3 weeks ago

Denver, Colorado, United States SPECTRAFORCE Full time
Job Title: Data Warehouse Developer - Mid Level (3-5 yrs.)

Location: 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 solutions that support our security analytics and reporting efforts.

Key Responsibilities:
  • 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.
Requirements:
  • 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:

SPECTRAFORCE is a leading provider of 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. We have built our business by providing talent and project-based solutions to key industries such as Technology, Financial Services, Life Sciences, Healthcare, Telecom, Retail, Utilities, and Transportation.

We are committed to maintaining a workplace that ensures fair compensation and wage transparency in adherence with all applicable state and local laws.

Benefits:

SPECTRAFORCE offers ACA compliant health benefits, 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.

We provide 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.

  • Data Warehouse Solutions Architect

    4 weeks ago

    Denver, Colorado, United States Randstad Full time

    Job Title: Data Warehouse Solutions ArchitectWe are seeking an experienced Data Warehouse Solutions Architect to join our team in Denver, CO.This role will involve designing, developing, and implementing data warehouses, data marts, and data stores using various technologies, including AWS Data Services, Data Bricks, Informatica Cloud Application...

  • Data Warehouse Solutions Architect

    4 weeks ago

    Denver, Colorado, United States Randstad Full time

    Job Title: Data Warehouse Solutions ArchitectWe are seeking an experienced Data Warehouse Solutions Architect to join our team in Denver, CO.This role will involve designing, developing, and implementing data warehouses, data marts, and data stores using various technologies, including AWS Data Services, Data Bricks, Informatica Cloud Application...

  • Data Warehouse Architect

    4 weeks ago

    Denver, Colorado, United States ITR Group Full time

    Job Title:Senior Data ArchitectJob Description:We are seeking a highly skilled Senior Data Architect to join our team at ITR Group. As a Senior Data Architect, you will be responsible for designing, developing, and implementing technical architectures that support our functional design.You will lead the architecture solutioning for a scrum team and...

  • Data Warehouse Solutions Architect

    4 weeks ago

    Denver, Colorado, United States Randstad Full time

    Job Title: Data Warehouse Solutions ArchitectWe are seeking an experienced Data Warehouse Solutions Architect to join our team in Denver, CO.This role will involve designing, developing, and implementing data warehouses, data marts, and data stores using various technologies, including AWS Data Services, Data Bricks, Informatica Cloud Application...

  • Data Engineer

    2 weeks ago

    Denver, Colorado, United States Snowflake Computing Full time

    About the RoleWe are seeking a highly skilled and experienced Data Engineer to join our team at Snowflake Computing. As a Data Engineer, you will be responsible for designing, building, and maintaining large-scale data systems that meet the needs of our customers.Key ResponsibilitiesDesign and implement data pipelines to collect, process, and analyze large...

  • Data Center Controls Engineer

    3 weeks ago

    Denver, Colorado, United States Prime Data Centers Full time

    Job Title: Data Center Controls EngineerPrime Data Centers is seeking a highly skilled Data Center Controls Engineer to join our team. As a Data Center Controls Engineer, you will be responsible for designing, implementing, and maintaining the control systems for our data centers.Key Responsibilities:Design and implement control systems for data center...

  • Data Warehouse Developer

    4 weeks ago

    Denver, Colorado, United States Procom Full time

    Data Warehouse Developer - Mid LevelWe are seeking a highly skilled Data Warehouse Developer - Mid Level to support our cyber security data mart customers by building and maintaining scalable data pipelines on Google Cloud Platform (GCP).Job DetailsIn this role, you will be responsible for designing, building, and maintaining scalable data pipelines using...

  • Data Center Controls Engineer

    2 weeks ago

    Denver, Colorado, United States Prime Data Centers Full time

    Job Title: Data Center Controls EngineerPrime Data Centers is seeking a highly skilled Data Center Controls Engineer to join our team. As a key member of our engineering team, you will be responsible for designing and implementing controls systems for our data centers.Key Responsibilities:Design and implement controls systems for data centers, including...

  • Data Engineer II

    2 days ago

    Denver, Colorado, United States Ardent Mills Full time

    Job Title: Data Engineer IIAt Ardent Mills, we are seeking a highly skilled Data Engineer II to join our team. As a Data Engineer II, you will play a critical role in designing, developing, and maintaining robust and scalable data pipelines, data architecture, and data warehouses to support business intelligence and analytics initiatives.You will collaborate...

  • Data Warehouse Architect

    4 weeks ago

    Denver, Colorado, United States ITR Group Full time

    Job Title:Senior Data ArchitectJob Description:We are seeking a highly skilled Senior Data Architect to join our team at ITR Group. As a key member of our Payment and Product Data Services Team, you will be responsible for designing, developing, and implementing technical architectures that support our functional design.You will lead the architecture...

  • Data Warehouse Architect

    4 weeks ago

    Denver, Colorado, United States Genesis Corp Dba Genesis10 Full time

    Job Title: Data Warehouse ArchitectGenesis10 is seeking a highly skilled Data Warehouse Architect to join our team. As a Data Warehouse Architect, you will be responsible for designing, developing, and implementing data warehouses and data marts that meet the needs of our clients.Key Responsibilities:Design and develop data warehouses and data marts that...

  • Data Warehouse Architect

    3 weeks ago

    Denver, Colorado, United States Genesis Corp Dba Genesis10 Full time

    Job Description:Genesis10 is seeking a highly skilled Data Warehouse Architect to join our team. As a Data Warehouse Architect, you will be responsible for designing, developing, and implementing data warehouses and data marts that meet the needs of our clients.Key Responsibilities:Design and develop data warehouses and data marts that meet the needs of our...

  • Data Warehouse Solutions Architect

    4 weeks ago

    Denver, Colorado, United States Expleo Full time

    Job Title: Data Warehouse Solutions ArchitectTrissential, a trusted partner for end-to-end quality services and management consulting, is seeking an experienced Data Warehouse Solutions Architect to join our team. As a part of our parent company Expleo, we have a footprint in 30+ countries and a mission to have a positive impact on every person who interacts...

  • Data Engineer

    4 days ago

    Denver, Colorado, United States Slalom Full time

    Job SummaryWe are seeking a highly skilled Data Engineer to join our team at Slalom. As a Data Engineer, you will design and develop data platform solutions that enable our clients to learn from their data and create incredible digital experiences.Key Responsibilities:Partner with clients to solve complex business problems and identify cloud data and...

  • Data Warehouse Architect

    4 weeks ago

    Denver, Colorado, United States Compri Consulting Full time

    Compri Consulting Data Warehouse Architect Job DescriptionWe are seeking a highly skilled Data Warehouse Architect to join our team at Compri Consulting in Denver, CO. This is a 12+ month contract opportunity.Job Summary:The Data Warehouse Architect will be responsible for designing, developing, and documenting the technical architecture that supports the...

  • Data Warehouse Developer

    4 weeks ago

    Denver, Colorado, United States American Auto Shield Full time

    Data Warehouse Developer Job DescriptionWe are seeking a highly skilled Data Warehouse Developer to join our Data Governance and Strategy team at American Auto Shield. As a key member of our team, you will be responsible for designing, developing, and maintaining our data warehouse environment.Key Responsibilities:Design and develop data models to support...

  • Data Warehouse Architect

    3 weeks ago

    Denver, Colorado, United States Mindlance Full time

    Job DescriptionAs a key member of the Mindlance team, the Data Warehouse Architect will be responsible for designing, developing, and implementing technical architectures that support functional designs. This role requires strong leadership and coordination skills to ensure that various technical architects work together effectively.Key...

  • Data Engineer

    4 weeks ago

    Denver, Colorado, United States Evolve Full time

    Job Title: Analytics EngineerAt Evolve, we're a team of innovators passionate about hospitality. Our mission is to make vacation rental easy for everyone. We're looking for a talented Analytics Engineer to join our Data & Analytics Engineering team.About the RoleAs an Analytics Engineer, you'll play a key part in building, supporting, and optimizing data...

  • Data Warehouse Developer

    1 month ago

    Denver, Colorado, United States American Auto Shield Full time

    About the RoleWe are seeking a highly skilled Data Warehouse Developer to join our Data Governance and Strategy team. As a key member of our team, you will be responsible for designing, developing, and maintaining our data warehouse environment.Key ResponsibilitiesIdentify, analyze, and interpret business requirements to design and develop data...

  • Data Warehouse Developer

    1 month ago

    Denver, Colorado, United States American Auto Shield Full time

    About the RoleWe are seeking a highly skilled Data Warehouse Developer to join our Data Governance and Strategy team. As a key member of our team, you will be responsible for designing, developing, and maintaining our data warehouse environment.Key ResponsibilitiesIdentify, analyze, and interpret business requirements to design and develop data...