SUMMARY

The Sr. Data Engineer is responsible to manage, align and order the enterprise Data Warehouse models, Data ingestion and orchestration from variety of Data Sources and multiple Data formats against the business priorities, while coordinating the development of these requirements with the Data engineering team, Analytics team and overseeing the implementation of Data Warehouse solutions. Leads in collecting compliance evidence for SOX and/or HIPAA audits. Support the daily Operations on the modern cloud BI platform.

MINIMUM KNOWLEDGE AND SKILLS REQUIRED BY THE JOB

The requirements listed below are representative of the knowledge, skill, and/or abilities required to perform the job:

EDUCATION AND EXPERIENCE:

• 6+ years of Data warehouse design and data modeling experience in a fast-paced technology company and/or consulting.
• 8-10 or more years’ experience in development of ETLs using MS BI Stack.
• Demonstrated technical competence with the latest technologies (Azure, Power BI, SQL Server, SSIS, SSRS, SSAS, Azure/AWS Cloud, Devops (ADO), Snowflake, Mobility & Security)

SKILLS & ABILITIES:

• Expert in Snowflake Data Warehouse, data transformation through Snowflake medallion architecture layers
• Expert with Azure Cloud Development infrastructure
• Expert with Designing Azure DataLake Storage (Gen2), Azure SQL Server, Azure Data Factory, Azure Logic App, Azure Analysis Services, Automation accounts, PowerShell, JSON and integrations with Azure resources.
• Expert with Azure Data Factory working on various datasources and targets
• Expert SQL, T-SQL and PL/SQL knowledge against a variety of databases like SQL Server, Oracle, Hyperion and Cache.
• Expert with ETL tools like Kettle or Data stage is a plus
• Experience with Hyperion and Kronos is a plus
• Outstanding SQL, PL/SQL and T-SQL experience
• Expertise Oracle and EBS with a concentration on HR
• Should feel comfortable with relational design with high transaction databases
• Experience with SQL; inner joins, outer joins, group by’s, sub queries etc.
• Experience with Jira, Confluence, EasyVista or similar application preferred.
• Experience with SQL Server, Cache and Oracle
• Ability to adapt to new tools
• Excellent Verbal and Written communication skills.

OTHER REQUIREMENTS:

• Travel as needed

PHYSICAL REQUIREMENTS:

• Sedentary work. Exerting up to 10 pounds of force occasionally and/or negligible amount of force frequently or constantly to lift, carry, push, pull or otherwise move objects, including the human body. Sedentary work involves sitting most of the time. Jobs are sedentary if walking and standing are required only occasionally and all other sedentary criteria are met.

AMERICANS WITH DISABILITIES ACT STATEMENT

External and internal applicants, as well as position incumbents who become disabled, must be able to perform the essential job functions either unaided or with assistance of a reasonable accommodations to be determined on a case by case basis

N/A