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

The Trustees of Reservations

Campaign Director Job at The Trustees of Reservations

 ...campaign collateral. Strong interpersonal skills and ability to collaborate with Board members, donors, volunteers, staff, and consultants. Highly organized and deadline-driven, with the ability to manage multiple priorities and projects. Proficient in... 

North Kern State Prison

LIBRARY TECHNICAL ASSISTANT (SAFETY) Job at North Kern State Prison

 ...supervision of the School Principal or his/her designee and the operational direction of the Senior Librarian, the Library Technical Assistant (LTA) is responsible for the operation of a leisure book distribution service in the Reception Center housing units. The LTA... 

Peloton Interactive

Senior Machine Learning Engineer Job at Peloton Interactive

 ...without limitation, experience and business objectives and if the location for the job changes. Our base salary is just one component of Pelotons competitive total rewards strategy that also includes annual equity awards and an Employee Stock Purchase Plan as well as other... 

Maine's Public Universities

Postdoctoral Research Associate Job at Maine's Public Universities

 ...Maine System's flagship institution. UMaine is the state's public research university and a Carnegie R1 top-tier research institution,...  ...employee and dependent), comprehensive insurance coverage including medical, dental, vision, life insurance, and short and long term... 

EV.Careers

Power Electronics Engineer Job at EV.Careers

 ...EV.Careers is partnering with a leader in sustainable EV charging technology to find a Power Electronics Engineer with deep expertise in high-voltage, high-power electronics. This is a systems-level role where you'll establish and lead failure analysis processes for MW...