Azure Data Modeler

The role's primary focus is to support our clients Cognos to Power BI Conversion project that's underway which uses data in our Azure Synapse (dedicated SQL pool) warehouse. The data in Synapse is raw, flattened, and has minimal curation. We need to build a semantic layer to support the Power BI solutions that need to be created. Another team is delivering a logical data model to our team, and we need an Azure Data Modeler to convert that to a physical data model. This is a contract position and has the opportunity to convert FTE. The hourly range for this role is between $60-$79/hr.

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to HR@insightglobal.com .

To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/ .

Required Skills & Experience

The Data Modeler will be responsible for the developing/maintaining the physical model and will partner closely with the team who will deliver the logical model (and potentially provide feedback).

Knowledge of Power BI architecture will be helpful to understand performance implications

We don't have an in-house data modeling tool at this time but are exploring tools to procure. Candidate needs Dimensional Data Modeling experience.

The Data Modeler will need advanced SQL skills to conduct data analysis. Azure Data Factory knowledge may be helpful as well.

Benefit packages for this role will start on the 31st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.