Sr. Business Intelligence Developer - Power BI - Full Time Opportunity - Onsite

Company Description

Arthur Grand is an IT services firm specializing in Digital Transformation initiatives for Federal, Commercial, State & local customers. Since 2012, Arthur Grand has been successfully supporting and delivering IT services to our customers in the areas of enterprise modernization and transformation with a core focus on emerging technologies including Cloud Solutions (AWS, Azure), Agile Development, Custom Programming, Full Stack Development, DevOps, DevSecOps, CI/CD, Web Development, Mobile APP Development, Data Visualization, Data Warehousing, Financial/ERP System Implementation and Infrastructure Management. Arthur Grand’s culture of delivery excellence, combined with a commitment to bring the best talent to provide services, has earned our company an unparalleled reputation for delivering transformative results.

Job Description

Arthur Grand Technologies is currently seeking a highly motivated and skilled Sr. Business Intelligence Developer– Full Time – Onsite  for one of our clients.

Sr. Business Intelligence Developer

Location: Rochester, NY – Onsite

Full Time Opportunity

We are searching for an experienced Sr. Business Intelligence (BI) Developer to utilize Power BI and other resources to perform data modeling and financial and sales reporting to transform data into actionable insights. This is an Onsite position in Ogden, NY that supports strategic decision-making across the organization.

Essential Job Functions

• Develop, maintain, and optimize Power BI dashboards and reports for financial, sales data and more
• Design and implement data models to support efficient reporting and analytics
• Work closely with various business leaders to understand reporting needs and deliver meaningful insights
• Extract, clean, and transform data from multiple sources, ensuring data integrity and accuracy.
• Optimize DAX calculations and Power BI performance for large datasets.
• Automate data refreshes and reporting processes using Power BI Service and scheduled data pipelines.
• Collaborate with IT and data engineering teams to integrate new data sources into reporting structures
• Provide training and documentation to end-users to promote self-service BI adoption
• Take ownership of existing SQL-based database objects (e.g., tables, views, stored procedures, functions, and triggers) built and maintained by a long-term contributor
• Analyze, document, and optimize existing SQL code to ensure maintainability and performance
• Maintain and enhance SQL queries supporting reporting, integrations, and business processes
• Design and implement new database objects as needed to support evolving business requirements
• Ensure database security, integrity, and compliance with data governance policies
• Perform impact analysis and regression testing when modifying legacy SQL code
• Perform similar/related duties as requested

Education/ Special Licenses Or Certification

• Bachelor’s degree in Computer Science, Information Systems, or Mathematics preferred
• Microsoft Certified: Power BI Data Analyst Associate
   

Qualifications

• 3-5+ years of experience in Business Intelligence, Data Analytics, or related fields
• Advanced Power BI skills, including DAX, Power Query (M), and data visualization best practices
• Strong understanding of data modeling (Star Schema, Snowflake, etc.) and ETL processes
• Experience working with financial and sales data to provide key business insights
• Proven experience writing and maintaining complex SQL queries, stored procedures, views, and functions (preferably in Microsoft SQL Server, PostgreSQL, or a similar platform)
• Strong understanding of relational database design, normalization, and performance tuning
• Experience working with legacy code and reverse-engineering existing database structures
• 2-3 years’ experience building and maintaining objects in SQL Server Management or similar platforms
• Experience with Google Cloud is a plus but not required

Arthur Grand Technologies is an Equal Opportunity Employer (including disability/vets)

About Arthur Grand Technologies:

Arthur Grand Technologies is a leading provider of staffing and technology consulting services. Our company is managed by a team of professionals who have worked for big 5 consulting firms for 20+ years. We are a minority-owned staff augmentation and technology consulting company.

At Arthur Grand Technologies, we value our employees & contractors and strive to provide them with challenging, interesting wor