Technical Support Engineer
PayNearMe
Technical Analyst – Data & Systems
Ascension Executive Recruitment
full-time
Posted on:
Location Type: Remote
Location: Remote • 🇺🇸 United States
Visit company websiteSalary
💰 $91,107 - $126,998 per year
Job Level
JuniorMid-Level
Tech Stack
Amazon RedshiftBigQueryCloudETLInformaticaPythonSQL
About the role
- Support enterprise data solutions with a strong focus on data profiling, system analysis, and hands-on work within Google BigQuery.
- Perform data profiling on incoming source datasets to assess data quality, completeness, value distributions, anomalies, and mapping readiness.
- Conduct detailed system and data flow analysis, identifying source/target relationships, data lineage, and dependencies.
- Write complex SQL queries, validate transformations, evaluate performance, and build reusable datasets and views in Google BigQuery.
- Partner with business analysts and product managers to translate business requirements into technical data requirements and support functional/data mapping.
- Document source-to-target mapping specifications, transformation logic, and data validation rules.
- Analyze data discrepancies, support root cause analysis, and identify data remediation strategies.
- Collaborate with data engineers and solution architects to define integration strategies, data orchestration logic, and support data model design.
- Monitor and report on data quality metrics; support data cleansing, enrichment, and stewardship activities.
- Assist in testing and validation efforts for new data pipelines, MDM match rules, and integrated views.
- Maintain technical documentation for profiling outputs, schema metadata, and systems inventory.
Requirements
- High School diploma equivalency with 2 years of cumulative experience OR Associate's degree/Bachelor's degree OR 4 years of applicable cumulative job specific experience required.
- 3+ years of experience in technical data analysis or data engineering roles, preferably in a healthcare or regulated environment.
- Expert-level SQL skills, with a focus on performance-tuned queries in Google BigQuery or other cloud-native data warehouses (e.g., Snowflake, Redshift).
- Strong hands-on experience in data profiling tools or techniques using SQL, Python, or third-party solutions (e.g., Informatica Data Quality, Talend, DQOps).
- Experience analyzing data across multiple systems (e.g., EHRs, ERPs, CRM, EMPI, MDM, Portals).
- Familiarity with data integration methods: APIs, ETL/ELT pipelines, batch ingestion, real-time streaming.
- Understanding of data modeling concepts (e.g., normalized, dimensional, star schema) and metadata management.
- Strong documentation skills, especially in data flow diagrams, data dictionaries, profiling summaries, and mapping specs.
- Excellent problem-solving skills and the ability to work independently with minimal supervision.
- Working knowledge of data governance and data stewardship practices is a plus.
- Experience in Agile development environments using Jira, Confluence, Git is preferred.
Benefits
- Paid time off (PTO)
- Various health insurance options & wellness plans
- Retirement benefits including employer match plans
- Long-term & short-term disability
- Employee assistance programs (EAP)
- Parental leave & adoption assistance
- Tuition reimbursement
- Ways to give back to your community
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
SQLdata profilingdata analysisdata engineeringdata integrationdata modelingdata governancedata stewardshipdata cleansingdata validation
Soft skills
problem-solvingdocumentationcollaborationindependencecommunication
