"Alerted.org

Description

***All FTE's of this client are required to be Indiana residents.*** Responsibilities: Architect and implement data pipelines, data lakes, and warehouse models using Azure Synapse Analytics, and Data Lake Storage. Develop and optimize complex T-SQL queries, views, stored procedures, and data transformations in both dedicated and serverless SQL pools. Leverage Apache Spark (via Synapse) to process and transform large-scale datasets using Scala and/or Python. Design and implement ELT/ETL workflows across structured, semi-structured, and unstructured data sources. Collaborate with business analysts, data scientists, and stakeholders to deliver reliable and performant data solutions. Monitor, troubleshoot, and optimize performance across Synapse pipelines, Spark pools, and Azure data services. Apply data governance, metadata management, and security practices including RBAC, encryption, and auditability. Work within Agile/Scrum teams using modern DevOps and CI/CD practices for data development and deployment. Perform other duties as assigned.

Skills

Python, Sql, Azure, data mining, data pipelines, data mapping

Top Skills Details

Python,Sql,Azure

Additional Skills & Qualifications

Required Skills/Qualifications Bachelors degree in information systems, Computer Science, Engineering or equivalent years of experience in data or software engineering roles. Advanced skills in T-SQL and experience tuning queries for performance in large-scale distributed environments. Proficient use of Apache Spark, preferably within Synapse or Databricks, using Scala and/or Python. Experience with source control (Git) and CI/CD practices using Azure DevOps. Strong communication and leadership skills, with the ability to engage technical and non-technical stakeholders across the organization. Preferred Skills/Qualifications Deep understanding of Azure Data Factory, Data Lake Gen2, and SQL pools (dedicated/serverless). Experience building end-to-end data pipelines that support analytics, reporting, and operational needs. Microsoft certifications such as: Azure Data Engineer Associate Azure Solutions Architect Expert Experience with additional Azure services such as: Azure Databricks, Azure Functions, Event Hubs, Logic Apps, Key Vault, and Power BI Exposure to data lakehouse architecture, Delta Lake, or other modern data platforms Understanding of data privacy and compliance frameworks (e.g., NERC, FERC, GDPR, CCPA, or smart meter data privacy protocols.)

Experience Level

Intermediate Level

Pay and Benefits

The pay range for this position is $85000.00 - $105000.00/yr.

Health, Dental & VisionDefined Benefit Pension Plan401(k) Retirement Plan with company matchShort Term Incentive Pay (STIP) PlanHealth Savings Account (HSA) with company contributionWellness ProgramAdoption and tuition assistanceEmployee Credit UnionVacation and Paid HolidaysFlexible Hybrid Work Schedule

Workplace Type

This is a hybrid position in Indianapolis,IN.

Application Deadline

This position is anticipated to close on Oct 10, 2025.

h4>About TEKsystems:

We're partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That's the power of true partnership. TEKsystems is an Allegis Group company.

The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.

About TEKsystems and TEKsystems Global Services

We’re a leading provider of business and technology services. We accelerate business transformation for our customers. Our expertise in strategy, design, execution and operations unlocks business value through a range of solutions. We’re a team of 80,000 strong, working with over 6,000 customers, including 80% of the Fortune 500 across North America, Europe and Asia, who partner with us for our scale, full-stack capabilities and speed. We’re strategic thinkers, hands-on collaborators, helping customers capitalize on change and master the momentum of technology. We’re building tomorrow by delivering business outcomes and making positive impacts in our global communities. TEKsystems and TEKsystems Global Services are Allegis Group companies. Learn more at TEKsystems.com.

The company is an equal opportunity employer and will consider all applications without regard to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.