Sofka Technologies logo
Sofka Technologies

To transform people’s lives being the most trusted technology partner

Analista de Datos, DWH, DLK

Data AnalystData AnalystFull TimeRemoteSeniorTeam 1,001-5,000Since 2013H1B No SponsorCompany SiteLinkedIn

Location

Mexico

Posted

19 days ago

Salary

0

Seniority

Senior

Bachelor Degree3 yrs expSpanishBigQuerySQL

Job Description

Analista de Datos, DWH, DLK

Sofka Technologies

• Analizar la integridad de los datos mediante estrategias de paralelos entre SAS y BigQuery para el cierre contable. • Validar la consistencia de sumatorias críticas en tablas de alto volumen para garantizar reportes sin diferencias. • Interpretar código en SAS Guide y SAS Base para extraer y replicar reglas de negocio en el entorno de BigQuery. • Realizar Data Profiling estadístico para detectar nulos, duplicados y anomalías en la calidad del modelo de información. • Desarrollar flujos de trabajo optimizados y automatizados para la comparación masiva de registros financieros. • Investigar discrepancias en los datos y proponer soluciones técnicas basadas en el comportamiento de los sistemas. • Gestionar la comunicación técnica con el negocio para explicar el origen de las variaciones encontradas.

Job Requirements

  • Título profesional en Ingeniería de Sistemas, Estadística, Matemáticas, Economía o carreras afines con enfoque analítico.
  • Mínima de 3 años desempeñándose como Analista de Datos en proyectos de migración, conciliación de información o auditoría de datos financieros.
  • Dominio Avanzado de SQL (BigQuery) para optimización de consultas y manejo de precisión NUMERIC.
  • Manejo de SAS Guide / SAS Base para la lectura y extracción de lógica programada.
  • Técnicas de Data Profiling (análisis de consistencia, completitud y eficiencia).
  • Conocimiento sólido en mecanismos de Migración de Datos y ciclo de vida del dato.
  • Automatización de procesos avanzados de datos mediante scripts y flujos lógicos.
  • Conocimiento en DWH Y DLK.

Benefits

  • Retos técnicos y personales que te mantendrán en constante crecimiento.
  • Un equipo conectado, enfocado en tu bienestar físico y mental.
  • Cultura de mejora continua, fresca y colaborativa, con oportunidades de aprendizaje y gente dispuesta a apoyarte.
  • KaizenHub, un programa diseñado para potenciar tus talentos, con feedback, mentorías y coaching a través de Sofka U.
  • Programas como Happy Kaizen y WeSofka que cuidan tu bienestar físico y emocional.

Related Categories

Related Job Pages

More Data Analyst Jobs

Clinical Data Analyst

UnitedHealth Group

UnitedHealth Group is a healthcare and well-being company that’s dedicated to improving the health outcomes of millions around the world. We are comprised of two distinct and com

Data Analyst19 days ago

Role Description This position is a clinical data analyst for the SDS Ops Team. This role assists with the coordination of HEDIS® and STARs data gathering process remotely, within DataRAP, Cozeva and additional applications as needed. This role performs weekly reporting on total members data mined, calls made, total charts retrieved, and efficacy, as well as quality and productivity reporting. Throughout the year, they perform QA checks and data analysis as needed, ensuring accurate reporting and identifying any potential trends. This role partners with the Manager of Data Analytics, Sr. Clinical Analyst, and leadership team to accurately track and report on year-round data collection and abstraction. You’ll enjoy the flexibility to work remotely from anywhere within the U.S. as you take on some tough challenges. - Create, analyze, and report out on the SDS Ops work, quality and productivity reporting - Create weekly assignments, based on open gaps and members available to data mine remotely - Analyze data for possible discrepancies and deficiencies and report findings - Develop and document process improvement - Work to refine HEDIS®/STAR data collection software and data collection strategies, as needed - Support hybrid processes as needed, including reporting on total charts reviewed, and efficacy - Participate in user acceptance testing, assist with team coordination of system changes, and system upgrades - Complete training on HEDIS®/STAR measures - Perform all other related duties as assigned Qualifications - 2+ years of Business or Clinical Analytics experience - 2+ years of healthcare experience to include experience in a managed care setting - 2+ years of process improvement experience - 1+ years of HEDIS® experience or participation with similar regulatory reporting - Intermediate experience using Microsoft office applications, including databases, word-processing - Intermediate experience using Visio and Excel - Proven excellent presentation skills with solid communication capabilities and practices, both oral and written Requirements - Registered or Licensed Vocational Nurse - Certified Professional Coder - PMP - Advanced experience using Microsoft office applications, including databases, word-processing - Advanced experience using Excel® Physical & Mental Requirements - Ability to lift up to 25 pounds - Ability to sit for extended periods of time - Ability to use fine motor skills to operate office equipment and/or machinery - Ability to receive and comprehend instructions verbally and/or in writing - Ability to use logical reasoning for simple and complex problem solving Benefits - Comprehensive benefits package - Incentive and recognition programs - Equity stock purchase - 401k contribution (all benefits are subject to eligibility requirements) Application Deadline This will be posted for a minimum of 2 business days or until a sufficient candidate pool has been collected. Job posting may come down early due to volume of applicants.

United States
$60.2K - $107.4K / year
Full TimeRemoteTeam 51-200Since 2010H1B No Sponsor

• Complex data structures are your specialty. • You analyze datasets and dependencies using SQL queries. • In collaboration with product teams and customers, you specify mapping logic for data transformation. • You define test scenarios to verify the integrity and quality of migrated data throughout the entire process. • You bring your findings from error analysis to the team so solutions can be developed together. • You create KPI dashboards and reports and present them to internal and external stakeholders.

Switzerland
Job Closed
EXL logo

Senior Manager – Data Analyst, Medical Health Claims

EXL

We make sense of data to drive your business forward. #MakeSenseofData #DriveYourBusinessForward #PartnerYourWay

Data Analyst19 days ago
Full TimeRemoteTeam 10,001+H1B No Sponsor

• Support the business team in evaluating trends on utilization of products / services based on historical data. • Retrieve, organize and perform research/analysis on Medical Health Claim data. • Identify root cause and is a proactive thinker, self-starter, who enjoys working in a fast-paced and challenging environment. • Work independently in various areas such as Inpatient, Outpatient, SNF, Rehab, Professional, DME, HCD/HIT areas.

United States
$120K - $125K / year

Finance Analyst

BreachLock

A fast-growing cybersecurity company focused on delivering high-quality offensive security solutions.

Data Analyst19 days ago

Role Description You will be part of the high performing finance team that is responsible for managing end-to-end accounting processes including Procure-to-Pay (P2P), Record-to-Report (R2R), and Direct and Indirect Tax compliances for the global entities. The key deliverables include: - Manage day-to-day accounting operations including journal entries, reconciliations, and ledger scrutiny - Ensure accurate and timely month-end and year-end close processes as per IFRS and IndAS - Maintain general ledger and ensure compliance with accounting standards - Oversee vendor invoice processing, validations, and payments - Ensure proper accounting and reconciliation of vendor accounts - Manage vendor queries and ensure timely resolution - Prepare financial reports and support audits - Ensure completeness and accuracy of financial statements - Consolidation of Financial Statements - Handle GST compliance, including GST return filings (GSTR-1, GSTR-3B, etc.), Input tax credit reconciliation - Manage TDS compliance, including deduction, deposit, and return filing - Support Income Tax compliance, including Advance tax computation and payments, Coordination for tax assessments and audits - Ensure compliance with statutory regulations and timelines Qualifications - Bachelor of commerce or CA/ICWA-Intermediate - Strong knowledge of accounting principles - Proficiency in MS Excel (advanced functions like Pivot Tables, VLOOKUP/XLOOKUP, data analysis) - Experience working with Tally and ERP systems (e.g., SAP, Oracle, Xero or similar) - Ability to work in a team and demonstrate the strong team player Requirements - Strong communicator with the ability to collaborate, build relationships, and support in achieving broader organizational goals - Good experience and understanding of working in an agile environment - Self-starter, who can take initiative and get things done with minimal guidance - Good attention to detail and ability to meet deadlines

India