About the Role
We are seeking a Data Engineer to design, develop, and maintain data pipelines and enterprise data solutions. This role contributes to the evolution of our data architecture and analytics platform, partnering with stakeholders to build scalable data solutions and support analytics initiatives. The position offers opportunities to influence architectural decisions and gain experience with emerging technologies like Microsoft Fabric, Databricks, and Snowflake.
Responsibilities
- Design, develop, and maintain ETL/ELT pipelines using Azure Data Factory, SQL Server, SSIS, and Python.
- Develop SQL queries, stored procedures, views, and database objects to support enterprise reporting and analytics.
- Build and maintain reliable data integrations from internal and external data sources.
- Partner with business users to gather requirements and translate business needs into technical solutions.
- Support the design and enhancement of enterprise data models and data architecture.
- Collaborate with BI developers to provide optimized datasets for Power BI reporting and semantic models.
- Utilize Azure DevOps and Git for source control, deployments, and CI/CD processes.
- Monitor, troubleshoot, and optimize data pipelines for performance and reliability.
- Contribute to data quality, governance, documentation, and engineering standards.
- Explore and leverage AI-assisted development tools to improve engineering productivity and solution quality.
- Continuously learn and evaluate emerging data platform technologies.
Requirements
- Bachelor's degree in Computer Science, Information Systems, Engineering, or a related field (or equivalent experience).
- 3+ years of professional experience in data engineering or a related technical role.
- Strong experience with SQL, Microsoft SQL Server and T-SQL development.
- Experience developing ETL/ELT pipelines using Azure Data Factory or similar integration tools.
- Experience programming with Python.
- Experience working within Azure cloud environments.
- Experience using Git and Azure DevOps or similar source control and CI/CD platforms.
- Working knowledge of Power BI datasets and data modeling concepts.
- Experience gathering business requirements and working directly with stakeholders.
- Strong analytical, communication, and problem-solving skills.
- Experience or familiarity with AI-assisted development tools such as Microsoft Copilot, GitHub Copilot, ChatGPT, Codex, or similar technologies.
- Experience with Microsoft Fabric, Databricks, or Snowflake.
- Knowledge of enterprise data architecture and data modeling principles.
- Experience with Azure Data Lake Storage.
- Familiarity with dimensional modeling and data warehouse concepts.
- Experience integrating REST APIs and semi-structured data.
- Interest in AI, advanced analytics, and modern cloud data platforms.
Skills
- SQL
- Microsoft SQL Server
- T-SQL
- ETL/ELT
- Azure Data Factory
- Python
- Azure
- Git
- Azure DevOps
- CI/CD
- Power BI
- Data Modeling
- AI-assisted development tools
- Microsoft Fabric
- Databricks
- Snowflake
- Azure Data Lake Storage
- REST APIs
- Semi-structured data
Location
- In-office
Work Type
- Full-time
Experience Level
- 3+ years of professional experience
Education Level
- Bachelor's degree in Computer Science, Information Systems, Engineering, or a related field (or equivalent experience)
Benefits
- Exceptional Retirement Plan: 2-to-1 company match on up to 4% of eligible compensation and additional profit-sharing contribution.
- Comprehensive Health Coverage: Low-cost medical, dental, and vision insurance options.
- Time Off: Personal leave, flexible scheduling, floating holidays, and half-day Fridays.
- Financial Wellness: Student loan matching in our 401(k), and performance-based bonuses.
- Professional Development: Tuition reimbursement and extensive internal training programs.
- Family-Friendly Benefits: New Parent Leave, family building benefits, and childcare resources.
About the Company
- At Kimley-Horn, people, clients, and employees are at the forefront. We prioritize achieving client goals and growing their success, while providing an environment for everyone to flourish. Our commitment to quality is driven by our people, fostering a culture that values passionate, hardworking, and proactive employees. Kimley-Horn has been recognized on the Fortune “100 Best Companies to Work” list for 19 years due to our employee retention, robust benefits, and company values.
