We love technology, and we enjoy what we do. We are always looking for innovation. We have social awareness and try to improve it daily. We make things happen. You can trust us. Our Enrouters are always up for a challenge. We ask questions, and we love to learn.
We pride ourselves on having great benefits and compensations, a fantastic work environment, flexible schedules, and policies that positively impact the balance of work and life outside of it. We care about who you are in the office and who you are as an individual. We get involved to know our people; we want every Enrouter to become part of a great community of highly driven, responsible, respectful, and above all, happy people. We want you to enjoy working with us.
We are looking for a Business Intelligence Developer to create and manage BI and analytics solutions that turn data into knowledge.
What you'll do:
- Database architecture and data warehousing
- Relational and dimensional data modeling
- Create ETL
Requirements
- Strong knowledge of SQL programming (Transact-SQL preferred)
- Experience with GIT.
- Experience working with Azure SQL.
- Minimum of 5 years of experience in data warehouse design.
- Minimum of 5 years of experience working with BI solutions.
- At least one year of Experience in Azure Data Factory.
- Familiar with any of these reporting tools: SSRS, Tableau, Spotfire, or Power BI.
- Ability to communicate findings and provide work statuses clearly to both technical and non-technical audiences.
Required Tech Skills:
- Microsoft SQL Server (Transact-SQL)
- GIT
- Azure Data Factory
Preferred Skills
- SSRS
- Spotfire
- Synapse
Key Responsibilities:
-Create and/or maintain complex data loading processes with T-SQL for Operational Data Stores, Data Warehouses and Data Marts.
-Analyze and maintain existing SQL data load code for legacy source systems.
-Execute, update, maintain, create and monitor ADF pipelines for daily data load processes in multiple environments.
-Troubleshoot and fix data issues in the Data Warehouse (production support).
-Collaborate with other teams to integrate requirements into deliverables.
-Keep code updated in version control.
-Create and maintain reports
Benefits
Equal employment
Enroute is vowed to provide equal employment opportunities to all qualified individuals and to administer all aspects and conditions of employment without regard to the following: Race, religion, color, national origin, age, sex, sexual orientation, gender, gender identity, pregnancy, genetic information, including family medical history, physical or mental disability, military or veteran status, citizenship and/or migration status, child and spousal support withholdings, expunged criminal records, any other protected class, in accordance with applicable federal, state, and local laws.