The BI Developer uses warehouse data to solve organizational problems through reports, analysis and data visualization. The BI Developer will provide enterprise-wide data warehouse expertise with emphasis on data design, access, usage, security and quality of information assets.
Requirements
- Knowledge of SQL and data warehousing concepts
- Demonstrated detailed knowledge of BI areas including ETL design, analytics and reporting
- MS SQL Server, Integration Services and Reporting Services
- Strong TSQL scripting abilities and understanding of complex stored procedures, views, data aggregation/manipulation through table joins/queries, database design, normalization and de-normalization techniques
- Demonstrated experience in data extraction and manipulation, ETL techniques
- Demonstrated attention to detail on ensuring the accuracy and efficiency of the data warehouse and the individual work units
- Experience: 3+ years of Power BI Development (Power BI certifications preferred)
Responsibilities
- Performs technical troubleshooting, code debugging, and problem solving for custom built data warehousing solutions
- Assists in implementing effective business analytics practices that drive improved decision making, efficiency and performance
- Communicate with nontechnical business users to determine specific business requirements for reports and business intelligence solutions
- Communicates regularly with technical, applications and operational staff to ensure database integrity, security and optimized performance at the application and database level
- Identifies, communicates, and resolves data quality and data reconciliation issues
- Performs independent audits and reviews and validates databases to ensure data integrity
- Processes data extracts using data retrieval and management tools
Other
- Works collaboratively with stakeholders to develop reporting systems that provide accessible information for decision-making.
- Bachelor’s degree in Business, Management, Economics, Accounting, Finance, or Computer and Information Science required
- Possesses strong oral and written communication skills, clearly and accurately communicating complex and/or technical information to both technical and nontechnical audiences
- Possesses strong analytical and troubleshooting skills
- Self-motivated; able to work within a project-based environment
