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.