Business Intelligence Developer (Informatica & Azure Data Factory)
About The Position
A public sector client of TEKsystems requires one business intelligence and analytics contractor to enhance delivery capacity in support of an ongoing portfolio of work. The successful candidate must have demonstrated experience developing extract, transform, and load (ETL) scripts using PowerCenter Informatica. The ideal candidate will also have experience with Microsoft data platforms technologies and/or SAP BusinessObjects. Preference will be given to candidates with experience in multiple platforms. The scope of work for this contract will be to perform the analysis and implementation of reporting and analytics solutions.
Requirements
- Five (5+) years’ experience in the last 7 years developing and delivering successful business intelligence and analytics solutions using one or more relevant technologies.
- Experience using PowerCenter Informatica to create or modify extract, transform, and load (ETL) scripts (5+ years).
- Experience using SAP BusinessObjects to create and/or manage a data warehouse universe and to create or modify reports(5+ years).
- Experience with Microsoft data platform tools including Azure Data Factory, Azure Synapse Analytics and Microsoft Fabric (5+ years).
- Five (5+) years’ experience applying data modelling principles such as Kimball Dimensional Modelling.
- Five (5+) years’ experience working with database technologies and scripting, such as Oracle or SQL Server.
- Two (2+) years’ experience mentoring other business intelligence and analytics developers.
Nice To Haves
- Knowledge of cloud data architecture (lakehouse, modern data warehouse)
- Experience with Azure security: managed identities, RBAC, data controls
- Familiarity with CI/CD and DevOps (Azure DevOps, Git)
- Up to date Azure AZ-104 and Microsoft DP-600 & 700 certification
- Data virtualization using Denodo
- Strong verbal and written communication skills for diverse audiences
Responsibilities
- Coordinate with SMEs to define reporting requirements.
- Work with IT Governance team to validate solution architectural proposals.
- Review and update data marts as needed.
- Develop ETL scripts for new tables.
- Develop pipelines within Azure Data Factory.
- Prepare technical documentation for maintenance.
- Train internal support staff.
Benefits
- The pay range for this position is $70.00 - $85.00/hr.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Education Level
No Education Listed
