SQL Developer With Google BigQuery

E-Solutions Group - Denver, CO

Full-time

Denver, CO

Computing Infrastructure Providers, Data Processing, Web Hosting, and Related Services

About the position

The SQL Developer with Google BigQuery position is a critical role within our data management team, focusing on the development and optimization of SQL queries and data processes. This role requires a deep understanding of SQL and PL/SQL, as well as experience with data warehousing (DWH) and extract, transform, load (ETL) processes. The successful candidate will be responsible for ensuring data integrity across various sources, implementing data governance standards, and collaborating with stakeholders to enhance data quality. In this hybrid position based in Denver, CO, the SQL Developer will leverage their expertise in Google Cloud technologies, specifically BigQuery and Spanner, to run complex data queries and perform data validation checks. The role demands a proactive approach to problem-solving, with the ability to analyze data discrepancies and coordinate reconciliation efforts effectively. The ideal candidate will possess exceptional analytical skills and a solid understanding of data models, enabling them to contribute to the overall data strategy of the organization. Additionally, the SQL Developer will need to be familiar with relevant laws and regulations, including HIPAA, to ensure compliance in handling protected health information. This position offers the opportunity to work both independently and as part of a team, requiring strong communication skills and the ability to prioritize tasks effectively to meet project deadlines.

Responsibilities

• Proficient and extensive experience in SQL and PL/SQL skills.
• Sound knowledge in DWH and ETL concepts.
• Knowledge of best practices in SQL development and testing.
• Some experience on Google Cloud (BigQuery and Spanner).
• Running data queries to identify data integrity issues between various data sources, coordinating the reconciliation and exception handling.
• Collaborating with multiple stakeholder groups to identify and help implement data governance and data quality standards.
• Good understanding of data models to write/perform data validation and checks.
• Exceptional critical thinking, analytical, conceptual, and problem-solving skills.
• Self-starter; works well in teams and independently on tasks.
• Takes direction well and could prioritize work for delivery.
• Knowledge of State and Federal, including HIPAA, laws and regulations pertaining to confidentiality of protected health information.

Requirements

• Proficient in SQL and PL/SQL with extensive experience.
• Strong understanding of data warehousing (DWH) and ETL processes.
• Familiarity with Google Cloud technologies, specifically BigQuery and Spanner.
• Ability to run data queries and identify data integrity issues.
• Experience in data governance and data quality standards implementation.
• Good understanding of data models for validation and checks.
• Strong analytical and problem-solving skills.
• Ability to work independently and as part of a team.
• Knowledge of HIPAA and other relevant regulations.