Position Summary
KorTerra is seeking a Senior Data & Analytics Engineer to join our dynamic Business Insights team. If you possess the skills and passion to drive public safety and contribute to our zero damage prevention objectives, we invite you to be part of our team.
Roles and Responsibilities
As a member of the Data & Analytics team, you will:
·
Collaborate with cross-functional teams to design and implement data analytics solutions.
Develop and maintain data pipelines, ETL/ELT processes, and data integrations using Azure Data Factory and other technologies.
Leverage your expertise in SQL and PLSQL to transform raw data into meaningful insights.
Create and maintain dashboards and reports using Power BI for data visualization.
Contribute to discussions on designing and optimizing data-related features.
Conduct code reviews, providing constructive feedback to team members, and ensuring code quality.
Play an active role in incident resolution outside of regular hours when necessary.
Collaborate closely with developers, Product Owners, and Product Managers to align data solutions with business objectives.
Make direct contributions to the success of the KorTerra product and the organization.
Actively participate in the Agile planning and development process, testing activities, and CI/CD methodologies.
Role Requirements:
3+ years’ experience with SQL and PLSQL.
2+ years hands-on experience in Azure Data Factory or other ETL tools.
Familiarity with data warehouse technologies, including Snowflake.
2+ years’ experience with Power BI or other data visualization tools.
Strong verbal and written communication skills.
Familiarity with commonly used code testing methodologies.
Ability to work collaboratively in a team environment using tools like Jira and Confluence.
Experience in source control management tools such as Bitbucket.
Preferred Qualifications:
Bachelor of Science in Computer Science or equivalent education
Experience working in a Scrum/Agile environment.
Experience embedding external content in a site using iframes is a plus.
Experience with big data transformation is a plus.
Experience with cloud technologies such as Azure DevOps, SQL Server is a plus.
Programming experience in one or more object-oriented languages is a plus: Python, C#.
Prior experience in automated test development is a plus.
- Comprehensive Medical Benefits Package
- Unlimited Paid Time Off
- 401k with company match
- Paid Sick and Safe Leave
- 401k plan with company match
- Monthly company events
- Hybrid and flexible work schedule
- Professional development stipend
- and much more!