BI Developer

JOB TITLE: BI Developer Senior

JOB LOCATION: Boston MA

WAGE RANGE*: $75-$80

JOB NUMBER: ITS77-EHS-FY26-APP DEV - 012 - BI

REQUIRED EXPERIENCE:

• 5 years of experience in Cloud Data warehousing, data analysis, BI Reporting, enterprise and business information system architectures, and system engineering
• Possess High level SQL (Preferably in Oracle and Snowflake).
• Have experience with data warehouse-based operations, analytic functions and query generation.
• Advanced knowledge of Dashboard performance optimization.
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks * Strong DW-BI Skills; Data modeling and advanced Reporting experience
• Extensive experience in Tableau portal functionality
• Experience with Cognos Query Studio, Powerplay Studio, Event Studio * Knowledge of ETL & Snowflake Concepts.
• 3-5 years of experience developing Cloud-based (AWS) data solutions.
• Strong problem solving & analytical skills

Preferred experience/skills:

• Tableau reporting experience and Certification
• Amazon Web Services (AWS) Certification
• Snowflake certification
• Good to have Cognos Reporting Experience

JOB DESCRIPTION

As a member of the Executive Office of Health and Human Services Enterprise Data Management & Engineering (EDME), the Senior BI Developer will be responsible for development of BI Reports and Dashboards, Framework Manager Models, cubes, and the design and implementation of overall BI solutions. Creates tactical solutions to achieve long-term objectives and an overall data management roadmap. Establishes methods and procedures for effective design, development, deployment and support of Reporting solutions. The ideal candidate must demonstrate confidence, creativity, and keen problem-solving abilities.

• Involve in Design and development of cloud-based data management systems.
• Create complex formulas and calculations within Tableau to meet the needs of complex business logic and good knowledge on Level of Detail Expressions.
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Creates effective Business Intelligence (BI) solutions and analytical dashboards / analytical tools for business users in Tableau.
• Strong SQL skills for developing and validating the Tableau Dashboards.
• Build and publish customized interactive Tableau reports and dashboards along with data refresh scheduling using Tableau Desktop and Tableau Server
• Create Tableau Scorecards, Dashboards using stack bars, bar graphs, scattered plots, geographical maps, line/pie graphs, and Gantt charts
• Perform detailed data analysis (i.e., determine the structure, content, and quality of the data through examination of source systems and data samples)
• Create reports using a variety of graphical and data modelling techniques using Tableau
• Create new KPIs and monitor them consistently in datasets using Tableau
• Effectively utilizes features and Best Practices of Tableau and visual analytics to maximize impact and utility of visualization products
• Create, test, and publish dashboards and reports, as well as schedule refreshes using Tableau
• Schedule & Monitor Daily, Weekly, Monthly Reports Factored upon Data Refresh Cycles and server contention.
• Security administration, release management, troubleshooting and general systems maintenance
• Develop Tableau & Cognos content specifically Reports in Report Studio, Cognos Cubes using Transformer, Events in Event Studio, Extracts, Visualizations and Workbooks in Tableau
• Analyze business requirements and write technical specifications for BI tools like Tableau and Cognos to develop Reports, Extracts, Dashboards, Cognos Cubes, Framework Manager Package

Equal opportunity employer as to all protected groups, including protected veterans and individuals with disabilities

* While an hourly range is posted for this position, an eventual hourly rate is determined by a comprehensive salary analysis which considers multiple factors including but not limited to: job-related knowledge, skills and qualifications, education and experience as compared to others in the organization doing substantially similar work, if applicable, and market and business considerations. Benefits offered include medical, dental and vision benefits; dependent care flexible spending account; 401(k) plan; voluntary life/short term disability/whole life/term life/accident and critical illness coverage; employee assistance program; sick leave in accordance with regulation. Benefits may be subject to generally applicable eligibility, waiting period, contribution, and other requirements and conditions. Benefits offered are in accordance with applicable federal, state, and local laws and subject to change at TCM's discretion.PDN-a083d206-995e-4fa0-bad4-c090fad3a2f5