Sr. Database Architect - Con Edison

Sr. Database Architect

Duration – 12+ Mos. NO Visa Restrictions # of Openings: 1 Position Type: Contract – Hybrid Location- Rye, New York Probable Interview Process – 1st. Video. 2nd -- On-Site Mandatory Local Candidates - Utilities Experience Preferred Remember to include the following with your submittal; Effective immediately we will require the following statement with your submissions : I have interviewed the attached candidate and in my opinion (candidate name) meets all the requirements within the job description, and (candidate name) understands that the interview process is 1. Video, 2nd On-Site. Submittals sent without above statement will not be accepted. Thank you for your anticipated cooperation.

JOB SUMMARY

Visual Analytics Designer/Dev

JOB DESCRIPTION

Energy Services – BP&T is a forward thinking organization dedicated to leveraging data to drive strategic decisions and business success. We are seeking a highly skilled Visual Analytics Developer to join our dynamic team. This role is ideal for someone who is passionate about transforming complex data into clear, compelling, and actionable visual insights for business and leadership audiences. If you thrive at the intersection of data, design, and business problem solving, we would love to hear from you.

Responsibilities

• Design, develop, and maintain high quality Tableau and Power BI dashboards that visually communicate performance trends, operational insights, and business outcomes.
• Translate complex datasets into intuitive, visually compelling analytics that enable stakeholders to quickly understand key drivers, risks, and opportunities.
• Partner closely with business stakeholders to understand analytical needs and define visualization requirements, including KPIs, metrics, and storytelling approaches.
• Create business solutions that improve efficiency, productivity, and decision making across operating organizations.
• Collaborate with business our data analytics team and IT to ensure data sources, view tables, and models are accurate, performant, and aligned with business definitions.
• Gather, document, and validate detailed business requirements and translate them into technical specifications and System Requirement Specifications (SRS).
• Develop and maintain system interfaces and business process specifications related to analytics and reporting solutions.
• Ensure dashboards follow best practices in visual design, usability, and accessibility, including consistency, clarity, and effective use of color, layout, and interaction.

Required Skills / Experience

• 2–5 years of demonstrated experience in visual analytics, business intelligence, or data visualization roles.
• Strong expertise in visual analytics and data storytelling, with the ability to present insights in a clear, concise, and business focused manner.
• Strong visual design sensibility and familiarity with data visualization best practices (e.g., chart selection, layout, hierarchy, and storytelling).
• Proven ability to work directly with business users to gather requirements, facilitate discussions, and create user stories that translate business needs into analytics solutions.
• Proficiency in Azure DevOps or similar sprint and backlog management tools.
• Advanced expertise in Tableau Desktop, including: dashboard and worksheet creation, calculated fields, parameters, and action filters, data source management and troubleshooting, performance optimization.
• Advanced expertise in Power BI, including: interactive dashboard and report development, data modeling and DAX (as applicable), report troubleshooting and optimization.

Additional Skills (Preferred but Not Required)

• Well organized, detail oriented, and able to manage multiple priorities in a fast paced environment.
• Comfortable working directly with both business stakeholders and IT teams.
• Excellent written and verbal communication skills, with the ability to present insights to technical and non technical audiences.
• Experience leading or facilitating requirements gathering and analytics discovery sessions with business users.
• Strong SQL skills, with the ability to write, modify, and optimize queries.
• Experience publishing and managing interactive dashboards on Tableau Server.
• Knowledge of scheduling dashboards and managing automated data refreshes.
• Proficiency in data blending and combining multiple data sources into cohesive visual analytics solutions.
• Experience testing, cleaning, validating, and standardizing data to meet business and reporting standards.

Technical Skills Must Have

• Ability to manage stakeholder relationships.
• Analytical and critical thinking skills.
• Analytical programming.
• Analytical skills process improvement management.
• Analytical testing.
• Highly skilled in visual analytics.
• Capable of working with business users to gather requirements and create user stories.
• Proficient in Azure DevOps or similar sprint management tools.
• Expertise in Tableau Desktop (dashboard creation, report authoring and troubleshooting, data source management).
• Expertise in Power BI (dashboard creation, report authoring and troubleshooting, data source management).
• Proficient in SQL (able to write and edit queries).
• Experience in building and publishing interactive dashboards on Tableau Server.
• Knowledge of scheduling dashboards for automatic data refresh.
• Proficiency in data blending.
• Ability to create action filters, parameters, and calculations for preparing dashboards and worksheets in Tableau.
• Experience in testing, cleaning, and standardizing data to meet business standards.

SAS Visual Analytics Nice To Have

• 3+ years of experience with C#,.Net, HTML, CSS, and JavaScript/jQuery.
• 3+ years of experience with creating stored procedures in SQL.
• Ability to create action filters, parameters, and calculations for preparing dashboards and worksheets in Tableau.
• ADO.
• Advanced Power BI skills.
• Agile database development and management.
• Azure DevOps.
• Azure SQL Database.
• Certified SQL.
• Data blending.
• Visual Analytic Skillset