Note: The job is a remote job and is open to candidates in USA. Talent Portus is seeking an IT Consultant 2 – Birth Defect Analyst to support public health data and healthcare reporting initiatives. The role focuses on Snowflake and ANSI SQL development, data analysis, query translation, reporting validation, data quality checks, testing, and collaboration with epidemiologists and business stakeholders.
Responsibilities
- Translate existing SQL queries from HUE/Cloudera to execute on the Snowflake platform
- Collaborate with epidemiologists to develop SQL queries incorporating program-based logic models based on reporting requirements and underlying data structures
- Answer questions from epidemiologists regarding the structure, syntax, logic, and design of SQL queries during collaborative development
- Create queries for line-listed data, incorporating variables from multiple data tables
- Develop summary queries for aggregate data using multiple stratification criteria
- Validate summary queries against existing reports to ensure accuracy
- Develop innovative data-cleaning queries within complex data structures to identify sites and/or cases requiring follow-up
- Modify and troubleshoot queries during User Acceptance Testing to validate functionality and expected results
- Provide detailed documentation within each query clearly defining the logic and expected outputs for each section of code, including: Exclusions Calculated variables Subqueries Stratification logic
- Perform data quality and validation checks to ensure accurate and consistent reporting
- Collaborate with business users to resolve data, reporting, and query-related issues
- Support reporting and analytics requirements through complex SQL development and data analysis
Skills
- Experience collecting and managing birth defect data within public health applications and integrated data systems
- Experience collecting and managing birth defect data through enterprise data platforms
- Experience using Snowflake and ANSI SQL to select, transform, and analyze data
- Data conversion
- Pivots
- Logical assignments
- Complex queries
- Subqueries
- Data stratification
- Experience creating views and temporary tables within sandbox databases or schemas to support complex queries
- Experience working with business users and stakeholders to gather, understand, analyze, and document analytics and reporting requirements
- Experience developing complex reports and dashboards for state and federal reporting
- Unit testing
- System testing
- User Acceptance Testing
- Test case and test scenario development
- Defect reporting and tracking
- Issue triaging and resolution
- Experience training business users on analytics tools and data structures
- Excellent written and verbal communication skills
- Minimum 5 years of IT experience with consulting experience
- Minimum 5 years of experience developing and executing SQL queries with minimal supervision
- Minimum 5 years of experience working with business stakeholders to gather, analyze, and document reporting requirements
- Minimum 5 years of experience performing quality assurance checks to ensure data accuracy, completeness, and consistency
- Minimum 1 year of experience working with ANSI SQL on the Snowflake platform
- Bachelor's degree in Computer Science, Engineering, Business, or another relevant field
- LinkedIn: Mandatory
- Local candidates only
- Experience working with birth defect data, public health data, and complex healthcare-related reporting environments is highly preferred
Benefits
- 100% remote work arrangement
Company Overview