IT Specialist

W. H. GREEN & SONS, INC.
Portland, ME, United States
2 months ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Experienced
Experience required
3 years minimum
Working hours
Regular working hours
Job source

Tech stack

Query Performance Agile Methodology Amazon Web Services Business Analytics Applications Data Analysis Microsoft Azure Business Intelligence Development Cloud Computing System Configuration Data Integration Data Warehousing Disaster Recovery
+19 more
IBM Cognos Business Intelligence Python (Programming Language) Performance Tuning Systems Development Life Cycle Role-Based Access Control Release Management Power BI SQL Databases Systems Integration Tableau (Software) Enterprise Data Management SSL Certificate Management System Availability Delivery Pipeline Powerquery Data Layers Information Technology Data Analytics Tools for Reporting

Job description

  • Design, develop, test, and deploy Enterprise Business Intelligence (BI) solutions, with a primary focus on building reports, dashboards, KPIs, and semantic models using Cognos Analytics, along with complementary development using Power BI and Tableau, across development, QA, UAT, production, and DR environments.
  • Lead report and dashboard development activities, including data modeling, complex calculations, Power Query transformations, DAX development, and performance optimization to support enterprise and program-level reporting needs.
  • Collaborate with business users and analysts to gather, analyze, and translate reporting requirements into scalable BI solutions, ensuring accuracy, usability, and alignment with business objectives.
  • Support BI platform administration and operations, including environment setup, configuration, capacity planning, high availability (HA), disaster recovery (DR), and performance tuning to ensure stable reporting platforms.
  • Manage and maintain Power BI On-Premises Data Gateway, Cognos components, Tableau services, and Dremio clusters, ensuring reliable data refresh schedules, optimized query performance, and system availability.
  • Perform user access and security administration, including role-based access control (RBAC), authentication integration, audit support, and security validation across BI platforms.
  • Participate in BI platform migrations and upgrades, including Cognos Analytics version upgrades, Tableau platform transitions, and reporting modernization initiatives, following SDLC and change management processes.
  • Support deployment, release, and validation activities, coordinating with Project Management, Change Management, QA, and Infrastructure teams in Agile, Waterfall, and hybrid environments.
  • Troubleshoot and resolve L2/L3 production issues, including report failures, data refresh problems, performance bottlenecks, and security-related incidents, ensuring minimal downtime.
  • Perform SSL certificate management and security checks for BI platforms to maintain secure access and compliance with enterprise standards.
  • Work closely with internal teams and vendors to deliver enhancements, optimizations, and ongoing production support, including planned maintenance and occasional after-hours releases.
  • Provide on-call and production support for BI platforms, including incident response, report execution issues, data availability concerns, and failover validation activities., * BI & Data Analytics Platforms : IBM Cognos Analytics (11.x / 12.x), Data Modules, Dremio, Power BI (Service & Desktop), Tableau Server / Tableau Cloud.
  • Data & Integration : Cognos Framework Manager,SQL, Enterprise Data Warehouses, Cloud & On-Prem Data Sources, Semantic Models, VDS, Reflections.
  • Administration & Operations : Cognos admin support,Power BI On-Premises Data Gateway, BI Capacity Metrics, High Availability (HA), Disaster Recovery (DR), Security & RBAC.
  • Cloud & Infrastructure : Azure, AWS-hosted BI environments, Hybrid BI architectures.
  • Automation & Scripting : * Python, SQL, Configuration based automation. Processes & Governance. SDLC, ITIL, Change Management, Release Management, SOX Compliance.

Requirements

Do you have experience in Systems integration?, Do you have a Bachelor’s degree?, IT Specialist with Bachelor’s Degree in Computer Science, Computer Information Systems, Information Technology, or a combination of education and experience equating to the U.S. equivalent of a Bachelor’s degree in one of the aforementioned subjects., * Minimum 5+ years of experience in Business Intelligence development, platform administration, and production support, delivering enterprise-scale analytics solutions.

  • Minimum 3+ years of experience in BI platform troubleshooting, performance tuning, release coordination, and L2/L3 production support in regulated or large enterprise environments.
  • Proven hands-on experience developing and administering BI platforms, including Power BI, Tableau, Cognos Analytics, and Dremio, with responsibility for security configuration, performance optimization, and platform governance.
  • Experience working with cloud-based and hybrid BI architectures, including platform migrations, modernization initiatives, and integration with enterprise systems.
  • Strong understanding of data modeling, SQL, semantic layers, data source integration, and enterprise data warehouse concepts to support scalable and reusable reporting solutions.
  • Experience with capacity planning, usage monitoring, gateway administration, deployment pipelines, and automation, aimed at improving reliability and reducing manual operational effort.
  • Proficiency in scripting and automation using Python, SQL, and configuration-based automation techniques to streamline BI development and administration activities.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on indeed.com

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

1:34 min

Pivoting careers into specialized platform engineering roles

Xavier Portilla Edo · LIVE

1:58 min

Shifting security permissions from applications to the data layer

Neena Thomas Neena Thomas · WWC Europe 2026

1:24 min

Moving the semantic layer upstream to avoid vendor lock-in

Piotr Menclewicz Piotr Menclewicz · Europe 2026 Virtual

3:09 min

Balancing data science skillings alongside systems engineering rigor

Nico Schmidt · LIVE

55 sec

Integrating recommended UI architectures with Jetpack Compose

Crístian Viana · WWC 2023

3:48 min

Standardizing data access schemas with OData

Florian Bader Florian Bader · WWC Europe 2026

Videos

See all

Related articles

See all