Jobs at Seneca Resources

View all jobs

Business Intelligence Developer

Birmingham, Alabama
Position Title: Business Intelligence Developer
Location: Remote
Position Status: Full Time

Position Description:
Seeking Business Intelligence Developer candidates for a remote position for a company based in Birmingham, AL.  Our client has a Business Intelligence Reporting offering for customers wanting to extend their base reporting options and to gain further insight into their business.

The Business Intelligence team handles Development, Implementation, Support and Training of both of their Enterprise IQ and Cloud IQ products.

The Enterprise IQ platform is a Tabular data model built using transactional SQL replication that publishes requested articles into a subscribing Data Warehouse. Using a star schema and SQL Server Analysis Services we create the tabular data model that is then accessed by users primarily using Microsoft Power BI and Excel.

Cloud IQ is their newest offering of a Microsoft Azure based Power BI model solution which allows their customers to utilize Analytics as a Service at a monthly subscription fee.

Job Overview:
  • Product development of new features for both Enterprise IQ and Cloud IQ product offerings which could consist of:
    • Creating/updating Power BI and Analysis Services data models (SSDT)
    • Creating/updating Stored Procedures for loading Dims/Facts
  • Investigation and resolution of product defects
    • Troubleshooting SQL queries
    • Using SSDT or Dax Studio to investigate discrepancies
  • Development of patch releases to address product defects
  • Custom development for specific customer requests
    • Works with BI Specialists and BI Analysts on feasibility of custom requests
    • Estimating custom efforts based on specifications

Required Education:
Bachelor’s Degree (Business, Information Systems, Computer Science, Computer Engineering or Data Analytics related degree preferred)

Required Skills:
  • Firm grasp of BI methodologies and will have had experience with the Microsoft BI Stack (SSIS, SSRS and SSAS).
  • Relational databases
  • T-SQL and Dynamic SQL
  • Data Warehouse and Data Mart solution design (Star Schema)
  • Tabular data modeling
  • Document investigation and findings for product defects and issues
  • Visual studio/SSDT
  • Experience with Microsoft BI stack, particularly SSIS and SSAS
  • SQL Server Management Studio
  • Familiarity with Microsoft Excel and Power BI
  • Ability to collaborate and work in a team environment
  • Experience in creating Stored Procedures and ETL
  • Excellent written and verbal communication skills
  • Investigation, troubleshooting, and analytical abilities to develop insightful conclusions and generate solutions
  • 5+ years’ Business Intelligence exposure or experience
  • 5+ years’ experience with SQL (T-SQL) experience
  • The right individual will possess experience in all stages of BI project work (requirements and logical design, physical design, implementation, testing and deployment).


About Seneca Resources:
Seneca Resources is a client driven provider of strategic Information Technology consulting services and Workforce Solutions to government and industry.  Seneca Resources is a leading IT services provider with offices in Virginia, Alabama, Georgia, Florida and Texas that service clients throughout the United States.

We are an Equal Opportunity Employer and value the benefits of diversity in our workplace.
 

More Openings

JavaScript Developer
Quality Assurance Analyst
Network Support Technician

Share This Job

Powered by