Senior Business Data Analyst
Business Enterprise Analytics & Reporting
The ideal candidate would have a dedication to producing high-quality output and proactive involvement towards the successful delivery of the organizations goals. The candidate will lead new and current project development. The candidate will facilitate and lead working groups within the organization and act as the primary resource dedicated to designing, developing, testing, and deploying reports and reporting tools. The candidate is responsible for designing and implementing database structures and reporting systems, which will provide the organization with the information and insights required to make strategic decisions. The candidate must have thorough knowledge of BI stack; connecting to data sources, loading data into data warehouses, writing complex queries to extract data, developing reports such as KPIs, dashboards, or complex analysis.
SUMMARY OF ESSENTIAL JOB FUNCTIONS
Able to formulate design recommendations that meet business requirements.
Able to communicate solutions and details on various views of the data environment to audiences.
Able to lead and interpret business requirements into actionable technical requirements.
Able to design and build reporting and analysis tools that help streamline business operations.
Able to lead data modeling and data process automations to meet business objections.
Able to identify risks and opportunities of potential logic and data issues within data environment.
Able to propose solutions, and alternatives, to requirements with an eye to scalability.
Able to deliver time sensitives requests that often require a phased release schedule.
Able to guide, influence, and grow team members and business colleague’s knowledge base.
Able to work with business owners and technical teams in the pursuit of excellent solutions.
Able to utilize an advanced knowledge of data analysis, profiling and conceptual modeling.
Able to design, develop, maintain, and deploy enterprise level reports within Microsoft Access, Excel, SSRS Reporting Services, and Tibco Spotfire..
Able to design, develop, maintain, and deploy Microsoft Access database tools.
Able to design, develop, maintain, and deploy SQL data structures.
Able to design, develop, maintain, and deploy SQL stored procedures
Able to perform complex SQL scripting using SQL Studio Manager.
Bachelor's degree in area of specialty or 4-7 years of experience in related area.
3+ years of Energy Industry Experience preferred.
Demonstrated knowledge of BI solutions and best practices for database solutions.
Strong Object / Relational mapping experience and ETL principles/knowledge
Data modeling experience using modeling tools and methodologies
Excellent verbal and written communication skills. Must be a persuasive speaker and presenter
Gathering, Documenting and Designing Data Requirements
Strong quantitative and analytical skills with accuracy and attention to detail
Ability to work well independently with minimal supervision and can manage multiple priorities
Flexible in a dynamically changing environment
Ability to work well within a team environment
Ability to work a minimum of 40 hours per week
Ability to meet highest attendance requirements
Ability to handle multiple tasks concurrently
Ability to use personal computer, calculator, etc
Could involve some lifting up to 20 pounds
Ability to sit for extended periods without much movement
Ability to work in time-sensitive environment with non-flexible deadlines