Data Architect - Cloud Lakehouse & BI (Onsite)

Biogensys; Tallahassee (FL); On-site; USD 120,000 - 180,000; Full time

Job summary

Biogensys is hiring an onsite Data Architect in Tallahassee, FL. The role focuses on designing and delivering data warehouse and lakehouse solutions, leveraging Snowflake, Databricks, and Informatica IDMC within a healthcare operations context.

The ideal candidate has 5+ years in data modeling, data warehousing, and cloud data platforms, with strong SQL and Python skills. This contract position is based onsite and requires excellent communication abilities.

Qualifications

• Bachelor's degree in CS/analytics/IS/public health informatics or related field.
• Certification such as CDMP or 18+ hours of related webinars/conferences.
• 5+ years collaborating with lines of business and analytics community; translate requirements to data/analytics solutions.
• 5+ years modeling/data warehousing (normalized and dimensional); 2+ years Snowflake.
• 3+ years designing/engineering cloud-based data lakes (AWS S3, Parquet).
• 2+ years data lakehouse (Delta Lake, Hudi, Iceberg) with Databricks.
• 7+ years data modeling (ER, logical, conceptual, physical) with Erwin.
• 5+ years data pipeline/integration tools (ETL/ELT; Informatica IDMC suite).
• 5+ years SQL; 3+ years Python; AWS Lambda helpful.
• 5+ years relational and NoSQL databases.
• 3+ years AWS cloud infrastructure.
• 2+ years metadata/datacatalog for lakehouse/warehouse, ML.
• 2+ years MDM/RDM in Informatica IDMC (Cloud) Customer & Reference 360 SaaS.
• 4+ years cloud analytics BI tools (Qlik, Tableau).
• 2+ years DSML platforms (Dataiku).
• Excellent communication skills.

Responsibilities

• Translate use case requirements into data/analytics solutions.
• Model, engineer, implement, and support data warehouses and lakehouses.
• Collaborate with BI/ETL teams to ensure data quality and performance.
• Build and optimize data pipelines and data governance processes.

Skills

SQL programming

Python

Data modeling

Data warehousing

NoSQL databases

Data Lakehouse

ETL/ELT

Cloud platforms

Education

Bachelor's degree in Computer Science or related field

Tools

Informatica IDMC

Snowflake

Databricks

AWS S3/Parquet

Erwin Data Modeler

Job description

Biogensys is hiring an onsite Data Architect in Tallahassee, FL. The role focuses on designing and delivering data warehouse and lakehouse solutions, leveraging Snowflake, Databricks, and Informatica IDMC within a healthcare operations context.

The ideal candidate has 5+ years in data modeling, data warehousing, and cloud data platforms, with strong SQL and Python skills. This contract position is based onsite and requires excellent communication abilities.