Agile Programming Methodologies, Analysis Skills, Best Practices, Business Intelligence, Communication Skills, Computer Workstations, Customer Support/Service, Data Entry, Data Mart, Database Design, Database Extract Transform and Load (ETL), Database Technology, Dimensional Modeling, Identify Issues, Mathematics, Microsoft Excel, Microsoft PowerPoint, Microsoft Product Family, Microsoft SQL Server, Microsoft Transact-SQL (T-SQL), Microsoft Word, Multitasking, Organizational Skills, People Management, Performance Analysis, Power BI, Problem Solving Skills, Progress Reports, Query Optimization, Reporting Dashboards, Reporting Skills, Requirements Management, SQL (Structured Query Language), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Scrum Project Management and Software Development, Software Design, Software Development, Star Schema, Stored Procedures, User Interface/Experience (UI/UX)
Apply
Description
General Purpose of Job
Implement database processes, reports, dashboards and various other BI artifacts and processes for
internal and external clients based on business requirements using industry best practices.
Duties and Responsibilities (Daily and Monthly)
- Translate business requirements into tasks and estimate the size of the tasks.
- Research requirements for requests to provide the functionality expectations of each request, e.g., data extraction, report, dashboard.
- Decide the best use of available technologies to complete a variety of assigned tasks.
- Develop SSIS packages to meet BI project requirements.
- Design and implement data marts.
- Extend existing data mart implementations.
- Develop reports using SSRS development environment.
- Develop report and dashboards using Power BI.
- Develop code using the T-SQL language to meet BI project requirements.
- Design report layouts that provide a user-friendly experience.
- Analyze performance of each report or query and implement proper optimization techniques.
- Follow documented processes to generate reports, packets, charts to various business units.
- Troubleshoot and resolve technical issues.
- Report progress to team(s) on the implementation of assigned projects/work items through daily
scrum meetings.
- Maintain a positive work atmosphere by behaving and communicating in a manner that will
facilitate working with customers, clients, co-workers, and management.
- Responsible for the security of workstation and work area in regard to the confidentiality of the
data and the systems.
Requirements
Educational Requirements
- Associates Degree Preferred
- Bachelor's Degree Preferred
- Educational And Professional Experience Requirements
2 year degree in a related field plus 3 years of BI experience.
Computer Skills
- Data Entry
- Customer Service
- Microsoft Word
- Power Point
- Excel
- Access
Additional Requirements: Excellent oral, grammatical, written, and multi-tasking skills.
Knowledge, Skills & Abilities Desired
- Advanced knowledge of Microsoft SQL Server
- Advanced knowledge of databases, schemas, table definitions, views, and stored procedures
- Advanced knowledge of T-SQL
- Advanced knowledge of Microsoft SSIS or other ETL tools
- Advanced knowledge of Microsoft SSRS
- Knowledge of Microsoft Fabric and Power BI
- Basic understanding of Dimensional Modeling and Star Schema designs
- Advanced knowledge of Excel
- Familiarity with query optimization
- Ability to understand & translate reporting business requirements into ETL processes, reports,
and/or dashboards
- Ability to work with software developers on system designs to advise on BI-related processes
- Demonstrate logic and math skills along with the ability to be inquisitive in analyzing requirements
- Effective communication and organizational skills
- Experience in a financial environment is a plus
- Exposure to AGILE methodologies is a plus
E
Edfinancial Services LLC
Edfinancial Services provides exceptional customer-driven student loan servicing. In addition, we have created streamlined processes and higher education services specifically designed with schools in mind - such as call center capabilities, financial aid process outsourcing, and default prevention services.Perpetual motion is our constant state. We are absolutely driven to excel on behalf of our stakeholders - borrowers, schools, businesses, and state and federal agencies. We stay ahead of the technology curve in higher education. We anticipate new trends and respond with products that improve operational efficiencies and corporate compliance.Headquartered in Knoxville, Tennessee, Edfinancial Services has satellite facilities in Jacksonville, Florida, and Little Rock, Arkansas. Since the only constant in this business is change, we're not looking back. Edfinancial Services is focused on the future. We're seeing through the eyes of our customers to sharpen our focus and align our vision with your reality. A company in motion, Edfinancial Services is moving forward, putting vision into action. Come grow with us in 2011.
100 to 499 employees
https://www.edfinancial.com/Home