What are the responsibilities and job description for the Senior Data Engineer position at CCS Global Tech?
Job Details
CCS Global Tech is a rapidly growing Information Technology company with a diverse portfolio of technology products and services and a large network of industry partnerships. With over 22 years of being a successful business with a global talent pool and presence, CCS is a certified Microsoft Gold Partner and specializes in delivering expert Microsoft based solutions for technical and business needs. We have been recognized by Inc. 500 Magazine as one of the fastest growing small companies in the Unites States.
we are a Tier 1 vendor for the City and County of San Francisco for Cloud Services, Staffing Services and Training Services. For this multi-year opportunity with a diverse set of needs to address, we are currently focusing on establishing partnerships with individuals as well as companies who can help us enhance our overall service portfolio, cut lead times, and ultimately help us deliver successfully. We currently hold sizable Government accounts in the San Francisco bay area including City and County of San Francisco, San Mateo County, and Santa Clara County.
We take great pride in our global reach and local influence. Your experience alongside our highly skilled and talented internal team who guide you along the way, offers key insights into what helps you stand out in a competitive job market.
If you are a partner company, please submit resumes with contact information of your own W2 Consultants only. Submitted consultants are expected to have excellent communication skills.
Position Summary
We are looking for a Senior Data Engineer to expedite our Data Platform Stack to support our developers, database architects, and data analysts on data initiatives. The selected candidate will ensure that optimal data delivery architecture remains consistent throughout ongoing projects in a dynamic environment.
Responsibilities
- Analyze and interpret complex data sets. Ability to identify data anomalies and resolve data issues.
- Understand specific business processes and domain concepts and relate them to data subject domains.
- Collaborate with Data Leads, Data Analysts, and QA Analysts to validate requirements; participate in user requirement sessions.
- Perform tests and validate data flows and prepare ETL processes according to business requirements.
- Perform ETL tuning and SQL tuning.
- Document data flows representing business logic in ETL routines.
- Design and implement a data conversion strategy from legacy to new platforms.
- Perform design validation, reconciliation, and error handling in data load processes.
- Design and prepare technical specifications and guidelines, including ER diagrams and related documents.
Qualifications
- Must be well-versed in data warehousing concepts, including design patterns (Star schemas, Snowflake design schemas). Must be aware of data modeling concepts, including the data modeling Normal forms.
- Knowledge of AWS Infrastructure, including S3, SNS, EC2, CloudWatch, and RDS.
- 7 years working in ETL/Data transformation projects with one or more related products such as Informatica, Talend, or Microsoft SSIS.
- 7 years working in business intelligence and data warehousing initiatives.
- Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL), as well as working familiarity with a variety of databases like Oracle, MS SQL Server, or Vertica.
- Good to have:
- At least 1 years working with the Matillion ELT tool and Snowflake Database.
- Experience in building AWS Data Pipelines using Python or Spark, SparkSQL in any Cloud Environment (AWS/Azure/Google).
- Experience with any of the NoSQL datastores such as Elasticsearch, MongoDB, DynamoDB, or Cassandra.
Education/Experience
- Bachelor's in Mathematics, Computer Science, or related technical field. Postgraduate degree preferred.
- Minimum 5 years of relevant experience.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
