Business Intelligence Developer/Analyst

Analysis

• Track and resolve processing problems, coordinating with all areas
• Track and resolve programming problems
• Develop and document business objectives, processing requirements, and specifications
• Develop and document system and data diagrams, program flows
• Develop test plans, scripts and test bases
• Analyze files and map data from one system to another
• Draft or modify internal procedures; implement new procedures including workflows, manuals and training
• Utilize corporate data tools to ensure quality and documentation standards are achieved.
• Provide backup support to SME’s in two or more of areas as assigned:
• BI Project Management
• BI Production Reporting
• Application Architecture
• Application Architecture and Support
• Training
• Provide backup support to SME’s in one or more datamarts

Technical/Programming

• Learn process and data flow; and how it affects surrounding systems and operational areas.
• Map logical data models to physical data models.
• Maintain existing programs/routine changes and major enhancements.
• Document programs, systems, manuals, etc.
• Review code for proper design, standards, content and functionality.
• Design and code complex programs.
• Responsible for production cycles, solving abends and notification of problems.
• Responsible for production support documentation in accordance with department standards and industry best practices.
• Review code for proper design, standards, content and functionality.
• Program in multiple programming languages (SQL, VB.net, 3GL/4GL).
• Translate business needs into technical solutions with knowledge of Bl Tools (SQL, ETL, and OLAP).
• Implement and maintain operational and disaster-recovery procedures.
• Manage Metadata
• Conduct capacity planning
• Write or modify procedures for internal use, user operational areas, and computer operations, as applicable.
• Utilize ODBC and OLE DB methodology.

Business Intelligence / Database

• Educate users on data warehouse capabilities; gain consensus among users on common data definitions
• Understand business opportunities for information usage
• Schedule data updates and report generation
• Develop business intelligence and EIS applications
• Convert existing reporting applications to use the data warehouse and datamarts
• Develop periodic reporting systems
• Develop monitoring systems to ensure data has been updated as expected
• Monitor data quality
• Implement data access tools
• Develop metadata management processes and/or systems

Project Management

• Develop programs, time estimates and project schedules based on prioritization and business requirements.
• Use sound project management methodology and demonstrate solid time management skills.
• Creates and delivers presentations.
• Monitor and create priority list(s) that are agreed to by user management

User Support

• Assist users with data requests and end-user support
• Create basic ad-hoc reports for internal usage and external usage

Performs job functions with general supervision

• Train data warehouse users
• Ensure the department leverages internal tools and applications effectively
• Build, support, and maintain moderately complex processes, programs, and data
• Participate or lead small to medium scoped projects
• Create moderately complex ad-hoc reports for internal usage and external usage
• Research and become proficient in two or more of areas as assigned:
• BI Project Management
• BI Production Reporting
• Application Architecture
• Application Architecture and Support
• Training
• Research and become proficient in one or more data marts

• Bachelor’s Degree in Computer Science, Information Systems, Business, or related field (Preferred)
• 2-5 years of experience as a BI Developer
• Strong SQL (write queries to extract data from MSFT SQL data warehouses)
• Strong experience in Power BI - ability to build out Power BI Dashboards
• Data Integration Experience
• Experience in Snowflake (nice to have)
• Ability to build out agents in Snowflake (nice to have)