Data Architect

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

We are hiring a Data Architect (Onsite) for one of our clients in Tallahassee, FL.

Job Description

• Minimum of Bachelor's (4-year) degree in Computer Science, Analytics/Data Science, Information Systems, Business Administration, Public Health Informatics, or another related field.
• Current data and/or analytics certification such as Certified Data Management Professional (CDMP).
• Eighteen or more hours of participation in webinars or conferences over the last 3 years related to data and analytics may be substituted for the certification.
• Five or more years of experience collaborating with various lines of business and the analyst/data science community; must demonstrate an understanding of general business operations related to healthcare and administration, the ability to translate use case requirements into data and analytics D&A) solutions, and the ability to articulate D&A solutions, tool usage and data models to a non-technical audience.
• Five or more years of experience modeling, engineering, implementing, and supporting data warehouses (both normalized and dimensional) including two or more years of experience with Snowflake Data Warehouse.
• Three or more years of experience designing, engineering, implementing, and supporting cloud-based data lakes, including lake layers and bucket structures in AWS S3 and related Apache Foundation tools such as Parquet.
• Two or more years of experience modeling, engineering, implementing, and supporting cloud data lakehouse structures (Delta Lake, Hudi, and Iceberg) utilizing Databricks.
• Seven or more years of experience in data modeling (including Entity Relationship, Logical, Conceptual, and Physical models) for analytical purposes, and data profiling/reverse engineering for both schema-on-read and schema-on-write environments. The experience must include advanced proficiency with Erwin data modeler.
• Five or more years of experience with data pipeline/Integration tools, including source to target mapping, coding, data quality and enrichment transforms, observability, orchestration, performance optimization, and testing, via various methods (i.e., ETL/ELT/batch, CDC, Streaming) using Informatica tools.
• This experience must include two or more years of experience using Informatica IDMC suite of tools including Cloud Data Integration (CDI), Cloud Data Quality (CDQ), Cloud Data Profiling (CDP), and Cloud Data Ingestion and Replication (CDIR).
• Five or more years of experience with SQL programming, three or more years of experience with Python or a similar object-oriented high-level programming language. Experience with AWS Lambda functions is helpful.
• Five or more years of experience in relational engineering (both row and columnar store) and NoSQL (i.e., Document, Graph, Vector, Key-Value) databases.
• Three or more years of experience working within the AWS cloud infrastructure.
• Two or more years of experience utilizing Dev or DataOps processes.
• Five or more years of data and analytics testing/quality assurance and acceptance experience, including best practices, tools, and automation.
• Two or more years of experience working with metadata and a data catalog that support the data lakehouse and data warehouse operations, as well as supporting machine learning.
• Two or more years of experience implementing and supporting Master Data Management (MDM) and Reference Data Management (RDM) in Informatica IDMC (Cloud) Customer and Reference 360 SaaS.
• Four or more years of experience supporting cloud-based Analytics & Business Intelligence (ABI) tools: Qlik and Tableau, including secure data warehouse connections, performance and user access controls.
• Two or more years of experience supporting cloud-based Data Science and Machine Learning platforms (DSML): Dataiku, including statistical model life-cycle management, endpoints, and machine learning.
• Must possess excellent communication skills, including verbal, written and diagramming.

Additional Information

• Location: Tallahassee, FL (Onsite)
• Interview: In-person
• Duration: 9 months to 12 months contract with possible extension

About Us

We are specialized in recruiting and deliver the best professional talent of industry and we are committed to deliver best experience for our clients and job seekers. With over two decades of experience in the recruitment industry, we proudly help you to find the next job that matches your professional skills. Our team understands your needs or requirement before starting the recruitment, that enables to find the high quality of talent with high success rate of talent delivery, keeps us continue to be the best in the industry. By responding to this job posting, you are consenting to receive text/SMS messages from us. Thank you.