Senior BI/ETL Data Engineer

Job ID: S#5638 - Senior BI Data Engineer

PLEASE NOTE: This is a 6 month renewable contract and needs to meet Client full-time conversion policies. Those dependent on a work permit sponsor now or anytime in the future (ie H1B, OPT, CPT, etc) do not meet Client requirements for this opening.

Senior, hands-on BI Data Engineer responsible for designing, building, and supporting data pipelines (≈80%) that power enterprise analytics. The role owns the full data development lifecycle (DDLC) for analytics pipelines and partners closely with a Principal Data Architect on modernization initiatives.

MUST-HAVE SKILLS

• Informatica PowerCenter (core ETL tool)
• Design, build, optimize, and support end-to-end ETL pipelines
• Handle complex transformations, error handling, and performance tuning
• Advanced SQL
• Complex queries, stored procedures, and optimization
• Relational Databases
• SQL Server, Oracle, PostgreSQL, or MySQL
• Data Warehousing & Modeling
• Dimensional modeling (star/snowflake schemas)
• Analytics-ready datasets and semantic layers
• Cloud Data Platforms (at least one)
• Azure preferred (Synapse, Data Factory, Blob Storage)
• AWS acceptable

PREFERRED SKILLS

• Informatica Cloud (IICS)
• Snowflake, Databricks, or similar modern data platforms
• BI tools support: Power BI, Tableau, Cognos, SSRS
• Experience modernizing legacy BI/data environments
• Healthcare or other regulated industry experience

EXPECTATIONS

• Own pipelines end-to-end (design → build → test → deploy → support)
• Troubleshoot production issues and optimize performance
• Ensure data accuracy, validation, and certification
• Support Tier 2–4 BI/data pipeline issues