Sr. Data Engineer (Snowflake) Job at Commercial Programming Systems, Inc., West Sacramento, CA

K2N6bWNxOHNNeFNjNWh0OHppWXRlT2lp
  • Commercial Programming Systems, Inc.
  • West Sacramento, CA

Job Description

Commercial Programming Systems, Inc. (CPS) is an Information Technology consulting and staffing company offering a broad range of services aimed at helping our clients deliver high-quality, cost-effective systems.

We are currently searching for a Sr. Data Engineer (Snowflake) to support our client for a 6-month project to support our State of California client. This is a remote position.

Target hourly pay rate is: $70.00 an hour

The Sr. Data Engineer (Snowflake) will establish a database model for data collection using the Data Vault 2.0 methodology. Using defined templates, develop a data pipeline that will read collected data in CSV format from AWS S3 storage for automated load into Snowflake tables and further curate the data into presentation layer for analytics needs.

Responsibilities:
  • Design and model data from provided data dictionaries.
  • Build data pipelines for quarterly data.
  • Load data into Snowflake.
  • Provide data quality checks and automated testing in development and production environment.
  • Provide data validations of submitted data.
  • Provide a development and production environment that meets staff defined use cases.
  • Calculations such as uptime and other key metrics will be calculated, aggregated, and available in the presentation layer for consumption.
  • Create Infomart views or Tables as a byproduct of the DBT SQL scripts.
  • Automated ELT pipelines built per architecture and tested.
  • Data tested in each layer and end-to-end to ensure consistency and completeness.
  • Infomart views set up with appropriate access and permissions that meets staff defined use cases.
  • Delivery of technical documentation for most current system; workflow diagrams, system infrastructure, and data collection diagrams.
Requirements:
  • Minimum of five (4) years of relevant experience in authoring and monitoring data pipelines in Snowflake.
  • This classification requires the possession of (a) a bachelor’s degree; however, the degree and be substituted with years of experience and certifications.
  • Experience with program management tools such as Azure DevOps.

Contact Information:
Jason.Johnson@cpsinc.com
323-319-6777

Commercial Programming Systems, Inc. (CPS) is an Equal Employment Opportunity Employer. CPS does not permit or condone any form of discrimination or harassment based on race, color, religion, national origin, gender, disability, protected veteran status, sexual orientation, or gender identity by the Company’s managers, associates, or vendors.

Job Tags

Hourly pay, Full time, Remote work,

Similar Jobs

Ferrero

Revenue Growth Planner Job at Ferrero

About the Role: With new innovations and exciting expansions plans in place, there has never been a better time to join the Ferrero Group and be extraordinary with us! As a Revenue Growth Planner, you will develop everyday pricing guidelines informed by brand strategy...

Pacific Asset Management, LLC

Tech Finance Senior Analyst: Budgeting, TBM & Cost Insight Job at Pacific Asset Management, LLC

A financial services company in Newport Beach is seeking a Senior Financial Analyst II to manage technology budgets and perform financial analysis. The role involves using advanced Excel and financial modeling skills, while leveraging tools like Oracle EPM and Power BI....

STAR Physical Therapy

Patient Care Coordinator Job at STAR Physical Therapy

 ...has not changed is our commitment to our patients, communities, and employees.We are...  ...medicine, and industrial rehabilitation care~ Developing "Great Mechanics Of The...  ...Job Description The Patient Care Coordinator facilitates the delivery of health care... 

McLane Global

Inside Sales Representative Job at McLane Global

 ...As one of the worlds largest food-grade logistics companies, McLane Global relies on the efficiency of its fulfillment centers. We...  ...perspectives fuel our growth and enrich our global culture. The Inside Sales Representative at McLane Global is responsible for generating... 

Robert Half

Data Entry Clerk Job at Robert Half

 ...is partnering with a reputable client seeking a detail-oriented Data Entry Clerk for a temp-to-hire contract. As a Data Entry Clerk, you'...  ...access to top jobs, competitive compensation and benefits, and free online training. Stay on top of every opportunity - whenever you...