Data Engineer

O2 Technologies,Inc; Chapel Hill (NC); Presencial; USD 90.000 - 140.000; Jornada completa

Descripción de la vacante

O2 Technologies,Inc in Chapel Hill, NC is seeking a data engineer to design cloud-based data pipelines and model warehoused data. You will develop Power BI dashboards and manage dataflows for health and public sector programs.

Responsibilities include ETL/ELT development, data integration with Salesforce/Curam/Oracle, and performance tuning to optimize costs. A Bachelor's degree in a related field is required; a Master's is preferred.

Formación

• Bachelor's degree in a related field is required.
• Experience with cloud-based data warehouses and BI tooling.
• Strong SQL and scripting skills essential.

Responsabilidades

• Design cloud-based data pipelines and ETL/ELT processes.
• Develop and maintain Power BI dashboards and dataflows.
• Model and warehouse data using star/snowflake schemas.
• Integrate Salesforce/Curam/Oracle data sources.
• Optimize performance and cost of data architectures.
• Troubleshoot pipelines and dashboard refreshes.
• Build a robust semantic layer for analytics.

Conocimientos

Cloud pipelines

ETL/ELT

Data modeling

Power BI dashboards

Dataflows/DirectQuery

Analytics reporting

Performance tuning

Data integration

Troubleshooting

Semantic layer

Educación

Bachelor's Degree in CS/IS/Data Science/Software Engineering

Herramientas

Azure Synapse

Azure Data Factory

Azure Data Lake Storage

Azure SQL

Monitoring Tools

Power BI

SQL (T‑SQL/PL/SQL)

Python/Scala

Snowflake/Databricks

Delta Lake

Salesforce API Integration

Descripción del empleo

• Data Modeling & Warehousing (Star & Snowflake Schemas)
• Power BI Dataflows & DirectQuery Management
• Analytics Reporting for Child Welfare & Medicaid Programs
• Performance Tuning & Cost Optimization
• Data Integration with Salesforce / Curam / Oracle
• Semantic Layer Design

Key Responsibilities & Skills

• Cloud-based Data Pipeline Design
• ETL / ELT Development & Optimization
• Data Modeling & Warehousing (Star & Snowflake Schemas)
• Power BI Dashboard Development
• Power BI Dataflows & DirectQuery Management
• Analytics Reporting for Child Welfare & Medicaid Programs
• Performance Tuning & Cost Optimization
• Data Integration with Salesforce / Curam / Oracle
• Troubleshooting Pipelines & Dashboard Refreshes
• Semantic Layer Design

Technical Skills

• Azure Synapse / Data Factory / ADLS / Azure SQL / Monitoring Tools
• Power BI (Dashboards / Datasets / Dataflows)
• SQL (T‑SQL / PL/SQL)
• Python / Scala
• Snowflake / Databricks
• Delta Lake
• Salesforce API Integration

Education

Bachelor's Degree in Computer Science, Information Systems, Data Science, Software Engineering, Business Analytics. Preferred: Master's in Data Science, Master's in Computer Science, Master's in Business Analytics, MS in Information Systems.

Industry Experience

• Health & Human Services
• Child Welfare
• Medicaid Programs
• Public Sector
• Government Analytics

#JoinOurTeam #NowHiring #ApplyToday