Sr. Database Architect

Visa –
                  
No H1B/ TN


Job Title –           
Sr. Database Architect


Location –          
Hybrid, Rye, New York,   
Local candidates only


Duration –           12+
Months


Interview –         1.Video 2.On site



Local Candidates - Utilities Experience Must


 


Sr.
Database Architect


 


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:


o Dashboard
and worksheet creation


o
Calculated fields, parameters, and action filters


o Data
source management and troubleshooting


o
Performance optimization


• Advanced
expertise in Power BI, including:


o
Interactive dashboard and report development


o Data
modeling and DAX (as applicable)


o 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


• o Highly
skilled in visual analytics.


o Capable
of working with business users to gather requirements and create user stories.


o
Proficient in Azure DevOps or similar sprint management tools.


o Expertise
in Tableau Desktop (dashboard creation, report authoring and troubleshooting,
data source management).


o Expertise
in Power BI (dashboard creation, report authoring and troubleshooting, data
source management).


o
Proficient in SQL (able to write and edit queries).


o
Experience in building and publishing interactive dashboards on Tableau Server.


o Knowledge
of scheduling dashboards for automatic data refresh.


o
Proficiency in data blending.


o Ability
to create action filters, parameters, and calculations for preparing dashboards
and worksheets in Tableau.


o
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