• Senior Data Analytics Engineer

    Insight Global (Sacramento, CA)


    Job Description

    - Design, develop, and maintain interactive Power BI reports and dashboards using Desktop, Service, and Embedded Power BI.

     

    - Implement robust data models with calculated columns, measures, and relationships to support business KPIs and time intelligence.

     

    - Manage deployment processes to Power BI Service workspaces, including scheduling refreshes and configuring access management.

     

    - Develop and optimize data solutions leveraging Azure Synapse Analytics, including schema design, indexing, and distribution strategies.

     

    - Build and orchestrate ETL pipelines using Azure Synapse Pipelines/Azure Data Factory for efficient data integration and transformation.

     

    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 [email protected] 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/.

     

    Skills and Requirements

     

    - 3+ yrs of experience with Power BI (Desktop, Service, Embedded), including DirectQuery and Import modes.

     

    - Strong knowledge of data modeling principles and implementation of Row-Level Security (RLS).

     

    - Expertise in Azure Synapse Analytics (star/snowflake schema, column store indexing, distribution methods, partitioning).

     

    - Proficiency in Azure Data Lake Storage Gen2, including hierarchical folder structures and Parquet file optimization.

     

    - Proven ability to design fault-tolerant ETL pipelines with error handling, logging, and integration with monitoring tools.