What are the responsibilities and job description for the Sr. AWS Data Engineer with Snowflake Quincy WA (Hybrid) - W2 fulltime only position at TEK Hire Solutions?
Role: AWS Data Engineer with Snowflake
Location: Quincy MA (Hybrid)
Contract Terms: W2 full time.
Preferred Skills/Certifications/Experience
Location: Quincy MA (Hybrid)
Contract Terms: W2 full time.
Preferred Skills/Certifications/Experience
- Amazon Web Services (AWS) Certification
- Snowflake and/or SAS certification
- Cognos and/or Tableau reporting experience
- Experience with Federal Reporting for Medicaid is a plus
- Involve in Design and development of cloud-based data management systems.
- Understand and translate business requirements into user acceptable solutions.
- Generate data to meet specific business needs that require sourcing data from appropriate source systems.
- Document code and processes that can be used by all interested parties, including the business, Federal Reporting team, data warehouse team members and others as directed.
- Provide query writing support to other analysts and end users.
- Be able to understand and implement user requests technically and operationally.
- Be available to attend meetings and participate on calls with users and others as requested or directed.
- Participate in team meetings and technical reviews as requested.
- Communicate effectively with business, peers and management, so they are kept aware of requirements, project status, concerns, processing roadblocks.
- Ensure timely delivery of solutions meeting requirements and expectations
- Expertise in basic MassHealth knowledge, practices and processes.
- Focused attention to detail in all assignments that fall under the purview of the EDME reporting team.
- Continually develop skills in SAS and/or SQL, Tableau and Snowflake.
- Support analytic and business requirements gathering efforts for ongoing reporting.
- Interact with business users and communicate business needs to the Federal Reporting and Data Warehouse development teams when necessary.
- The data analyst/developer is responsible for generating tables, files, reports and datasets upon request and as directed by team lead, senior staff or management.
- Deliver product to satisfy business request by required deadline.
- Generate code in SAS or in SQL to read data from the EHS Data Warehouse and output files in a format as requested by users or others.
- 5 years of experience in Cloud Data warehousing, data analysis, BI Reporting, enterprise and business information system architectures, and system engineering
- Possess High level SQL (Preferably in Oracle and Snowflake) and/or SAS skills.
- Have experience with data warehouse-based operations, analytic functions and query generation.
- 3-5 years of experience developing Cloud-based (AWS) data solutions.
- 5 years of Cloud database platform experience such as Snowflake.
- Experience in creating and maintaining end-to-end data pipelines.
- Strong communication skills comfortable explaining/proposing solutions to technical stakeholders, vendors, and business consumers.
- Experience working with a large, multi-terabyte enterprise data platform in Cloud.
- Experience working with highly sensitive health care information and familiar with HIPAA and other data privacy controls.
- Ability to build trusted relationships with stakeholders, managers, and employees at all levels
- Ability to quickly assess/summarize information and effectively identify issues, risks, solutions
- Demonstrated strength in multi-tasking and application of strong logical reasoning skills
- Familiarity with eligibility and claim based system and Medicaid Federal Reporting processes