The Role
Designs, develops, and optimizes scalable ETL/ELT pipelines and analytics solutions on Azure cloud platforms. Builds Salesforce data integrations, Power BI dashboards, datasets, dataflows, semantic models, and transformations. Optimizes Synapse pipelines, SQL queries, storage, and performance. Troubleshoots pipeline failures, API issues, and Power BI refresh problems while supporting structured and semi-structured data processing.
Summary Generated by Built In
requires the assistance of a contract resource to serve as a Data Engineer responsible for the design, development, and optimization of data pipelines and analytics solutions/dashboards on cloud-based data platforms. This work will leverage Azure Synapse Analytics, Power BI, and integrations with Salesforce or Curam/Oracle to support program needs.
Key Responsibilities:
- Analyze source systems and design, develop, and maintain scalable ETL/ELT pipelines using Azure Synapse, Azure Data Factory, and related Azure services.
- Build and manage data ingestion workflows from Salesforce, including API integrations, schema alignment, and performance tuning.
- Develop and maintain data models, data transformations,and semantic layers to support Power BI reporting and analytics.
- Optimize Synapse pipelines, SQL queries, and data storage for performance, reliability, and cost efficiency.
- Troubleshoot pipeline failures, Salesforce API issues,and Power BI dataset/dataflow refresh problems.
Requirements
Skill
Required / Desired
Amount
of Experience
Strong Hands-on experience configuring, designing, developing and testing dashboards using Power BI
Required
5
Years
Required
5
Years
Experience supporting Power BI datasets, dataflows, and DirectQuery/Import models.
Required
5
Years
Required
5
Years
Experience working with structured and semi-structured data formats (JSON, CSV, Parquet, etc.).
Required
3
Years
Required
3
Years
Strong experience in designing and optimizing scalable data pipelines using modern platforms like Azure Synapse, Snowflake or Databricks workflows
Required
3
Years
Required
3
Years
SQL Mastery: Advanced query writing, ETL/ELT, performance tuning, and optimization.
Required
5
Years
Required
5
Years
Programming Languages: Strong proficiency in Python or Scala for data processing.
Required
3
Years
Required
3
Years
Hands-on experience in developing efficient PL/SQL procedures
Required
5
Years
Required
5
Years
Experience with Programming and Scripting (SQL, T-SQL, and data query optimization)
Required
2
Years
Required
2
Years
Solid understanding of Azure cloud services (Synapse, Data Lake, Data Factory, Azure SQL, monitoring tools).
Required
2
Years
Required
2
Years
Experience in Azure Data Lake Storage (ADLS), Delta Lake, and data modeling concepts and Warehousing (star schema, snowflake schema)
Required
2
Years
Required
2
Years
Skills Required
- Five years of hands-on experience configuring, designing, developing, and testing Power BI dashboards
- Five years of experience supporting Power BI datasets, dataflows, and DirectQuery or Import models
- Three years of experience working with structured and semi-structured data formats such as JSON, CSV, and Parquet
- Three years of experience designing and optimizing scalable data pipelines using Azure Synapse, Snowflake, or Databricks workflows
- Five years of advanced SQL query writing, ETL/ELT, performance tuning, and optimization
- Three years of strong proficiency in Python or Scala for data processing
- Five years of experience developing efficient PL/SQL procedures
- Two years of programming and scripting experience with SQL, T-SQL, and data query optimization
- Two years of experience with Azure cloud services including Synapse, Data Lake, Data Factory, Azure SQL, and monitoring tools
- Two years of experience with Azure Data Lake Storage, Delta Lake, data modeling, and data warehousing concepts including star and snowflake schemas
Similar Jobs
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Novalink Solutions LLC is a global consulting, engineering, and AI product development company specializing in information technology and telecommunications. They provide AI-powered products, automation platforms, intelligent workflow systems, IT consulting, managed engineering, and staff augmentation services.
