
Data Engineer
STV
full-time
Posted on:
Location Type: Office
Location: Chicago • Illinois • Massachusetts • United States
Visit company websiteExplore more
Salary
💰 $89,487 - $119,317 per year
About the role
- Design, build, and maintain scalable data architectures in Azure, including Azure Storage Accounts, Azure SQL Databases, Azure Data Factory, and NoSQL technologies such as Cosmos DB and MongoDB
- Develop and optimize ETL/ELT pipelines for structured and unstructured data using Azure Functions, Python, and T-SQL
- Utilize Python for API development, scripting, and process automation, enabling seamless data integration and workflow orchestration
- Manage data warehouse setup, performance tuning, and maintenance, ensuring data quality, consistency, and accessibility
- Integrate data across systems using APIs and develop custom solutions in Python, .NET, and Java for application interoperability
- Collaborate with business stakeholders to translate analytical needs into technical specifications and data models
- Work closely with DevOps teams to implement CI/CD workflows through Azure DevOps and GitHub
- Administer and automate processes across SharePoint, Power Apps, and Power Automate environments
- Implement robust data governance, metadata management, and security frameworks aligned with organizational policies
- Support analytics and visualization teams by preparing optimized datasets for Power BI and other BI tools
- Lead migration and modernization efforts using ShareGate, Snowflake, and cloud-native technologies
- Explore and prototype emerging capabilities in Machine Learning and AI model development to enhance data-driven decision-making
- Document data systems, APIs, and pipelines, ensuring maintainability and knowledge sharing across teams
- Support proposals, business development, and client presentations related to data engineering and digital transformation initiatives.
Requirements
- Bachelor’s degree in Computer Science, Information Systems, Data Engineering, or a related technical field
- 4+ years of experience in data engineering, database development, and data integration in enterprise environments
- Hands-on experience with Azure SQL, Azure Storage, Azure Data Factory, and T-SQL
- Proven expertise in data warehouse design, ETL/ELT processes, and performance optimization
- Strong proficiency in Python for data processing, API development, and automation scripting
- Experience developing and integrating APIs using Python, .NET, and Java
- Familiarity with NoSQL databases including Cosmos DB, MongoDB, and Cassandra
- Solid understanding of Power Platform tools (Power Apps, Power Automate, Power BI) and SharePoint Administration
- Working knowledge of version control and deployment pipelines using GitHub and Azure DevOps
- Familiarity with Snowflake and cloud data ecosystem integration
- Excellent analytical, problem-solving, and communication skills, with the ability to translate technical concepts into actionable business insights.
Benefits
- Health insurance, including an option with a Health Savings Account
- Dental insurance
- Vision insurance
- Flexible Spending Accounts (Healthcare, Dependent Care and Transit and Parking where applicable)
- Disability insurance
- Life Insurance and Accidental Death & Dismemberment
- 401(k) Plan
- Retirement Counseling
- Employee Assistance Program
- Paid Time Off (16 days)
- Paid Holidays (9 days)
- Back-Up Dependent Care (up to 10 days per year)
- Parental Leave (up to 80 hours)
- Continuing Education Program
- Professional Licensure and Society Memberships
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills & Tools
data architectureETLELTPythonT-SQLAPI developmentdata warehouse designperformance optimizationNoSQLmachine learning
Soft Skills
analytical skillsproblem-solvingcommunicationcollaborationtechnical specification translation
Certifications
Bachelor’s degree in Computer ScienceBachelor’s degree in Information SystemsBachelor’s degree in Data Engineering