Senior BI Developer – Informatica, Microsoft BI, Azure Full Time

SALARY:  100-110K, plus full benefit package

Our client is an agency of the government of Canada responsible for a large segment of the international transportation of goods into our country.   The Senior BI developer is instrumental in developing solutions and providing technical support for the enterprise data management platform and BI solutions, including Extract, Transform, Load (ETL), reports, dashboards, and analytical solutions. This developer will be implementing scalable analytics through data management platforms like Informatica or other Microsoft BI/ reporting solutions and common services such as Data Governance and Data Quality in hybrid data architecture (cloud and on-premises).

This position:

• Develops and maintains complex data solutions, tools and automations which impact several functional areas throughout the organization, thereby, providing exceptional client-centered service on a consistent basis to all internal and external stakeholders.
• Involves working on multiple enterprise strategic projects involving the implementation of new or enhancement of existing systems, solutions and processes.
• Translates business requirements into technical specifications and is responsible for implementing software upgrades, developing strategies for data security, and ensuring compliance with pertinent IS security and privacy policies.
• Reports to Manager, Data Infrastructure

ACCOUNTABILITIES

Planning/Development

• Work with business and IT stakeholders to scope out projects including functional and technical deliverables, cost estimates, resources, and identification of benefits
• As part of the data infrastructure team, participate in analysis, planning and developing detailed roadmaps for the modernization of the existing data platform
• Share the technical ownership of organization’s data lake with other team members for both on-premises (SQL server enterprise) and cloud-based environments (Azure/AWS)
• Work closely with the manager, data engineer and infrastructure architect to create, design, implement, and test data models and database management systems
• Support the full analytics cycle of data design, ETL development, validating and reporting (either Agile or Waterfall)
• Help improve overall design and delivery standards
• Ensure all upgrades, additions, and changes to data infrastructure, tools and reporting portals are consistent in supporting the IS department’s service level commitments to the organization
• Research new technologies, implement proofs of concept/MVPs and make recommendations to build scalable and supportable infrastructure, as appropriate
• Perform root-cause analysis for service interruption and develop solutions to complex technical problems and to take appropriate urgent actions
• Configure, perform and monitor system level backups and restore via enterprise level backup solutions

Data Infrastructure, Database Design and Administration

• Proactively maintain data infrastructure: database servers, performance monitoring, security configuration, database software (SQL) – installation, patching, upgrades and decommissioning
• Develop feasible data backup and recovery procedures to prevent data loss – high availability and disaster recovery procedures
• Implement and maintain database security (user access, roles and privileges) and audit functions
• Plan for storage and capacity for raw data sources ingestion into data lake
• Monitor, tune and optimize the performance of databases
• Create and update database objects
• Write/deploy database procedures and scripts where required

Data/BI Development

• Participate in the collection, extraction, analysis, and documentation of analytics solutions from design through to code level
• Create/enhance and document logical and physical database models
• Utilize excellent SQL skills to extract structured/unstructured data from data sources and systems, architect, design and implement data marts using Informatica/SSIS to extract, transform, and load (ETL) business-critical information into on-premises SQL Server database or Cloud (AWS/Azure) based data lake solutions
• Create semantic layer views for reporting/dashboard and analytics
• Participate in forming strategies for data availability, security, archival, recovery and migration

Visualization

• Build and deploy visualizations/reports using PowerBI or Tableau to on-premises and/or cloud environments
• Write either MDX / DAX in PowerBI or calculated fields in Tableau
• Create multi-dimensional and tabular models as required

General

• Keep project management boards like JIRA up to date to reflect changes and complete work.
• Perform other assigned duties as required.

SPECIFIC COMPETENCIES

Excellent organizational skills with the flexibility to perform multiple tasks and meet deadlines are required.  Proven diagnostic, problem solving, team skills are essential, along with an excellent “customer service” approach.  The individual must be self-motivated, self-starter and work with minimal supervision with an excellent written and verbal communication skills, along with the ability to communicate both technically and non-technically, as appropriate.

EDUCATION & EXPERIENCE

Must have a degree or a diploma in Information Technology or an acceptable degree in related field from a recognized post-secondary educational institution, along with a minimum of 5-7 years of senior BI development experience in a mid to large corporate enterprise environment.

Must have demonstrated experience with: 

• Physical and logical design of database architecture for relational databases, data warehouses and data lakes
• Database optimization, data replication, database recovery and performance tuning
• Cloud data platforms (Azure and AWS) along with on-premises data integration
• Data warehousing & data Integration – dimensional modelling, facts, dimensions, helper tables, and SCD concepts
• Automated data pipeline creation using Informatica PowerCenter (cloud IICS) – usage of mapplets, various data ingestion methods – batch, real-time, APIs, reusable transformations, aggregates, lookups, caches, performance tuning, joiners, rank, router, update strategy, and workflows
• Informatica Data Quality IDQ 10.X – mapping, workflows, application, data profiling, data cleansing and standardization and building reusability logic, IDQ advanced transformations, and AddressDoctor
• Informatica components: IICS, Axon, enterprise data catalogue and IDQ with on-premises data lake and visualization tools
• Microsoft BI technology stack (SSIS, SSAS, SSRS, SQL Server, TSQL, MDX, DAX, Power BI, Power Pivot, Power Query)
• Azure DevOps, Git/CICD or TFS as code version controlling tool
• On-premises and on cloud dashboard deployments
• Functional programming languages (R, Python etc.), APIs and web services
• Data security principles, efficiency, quality and governance
• Complex technical and architectural documentation skills

The following will be considered as an asset:

• Informatica certifications (PowerCenter cloud developer/Admin, IDQ developer)
• Experience in implementing enterprise data governance framework
• Cloud architecture/developer certifications (Azure or AWS)
• Experience with AI/ML enabled Data Management, data lakes, big data, real time/ near real time analytics and IOT Integration projects

WORKING CONDITIONS

Normal working office conditions and participation in 7×24 on-call support

SECURITY CLEARANCE 

The incumbent must obtain and maintain a valid Security Clearance as this position is required to access restricted areas and information.