BI Developer
Role details
Job location
Tech stack
Job description
What We Are Looking For: We are seeking an Associate Business Intelligence Developer to serve as a key resource providing support across our full BI stack to deliver valuable BI solutions to our business partners.
To Be Successful: You will have the ability to excel in identification of problems from a business perspective and mapping and implementing pragmatic BI solutions.
The Role:
The Associate Business Intelligence Developer must be able to communicate equally with business owners and IT professionals. An excellent blend of analytical, technical, and communication skills in a team-based environment are essential for this role.
Day-to-Day Job Responsibilities:
- Work with business analysts and end users from cross functional teams to capture reporting requirements, Translate business needs into technical specifications and architecture patterns for enterprise business intelligence implementation.
- Assist in conducting extensive data analysis including data profiling and data quality analysis.
- Participate in design of ETL logic and load strategies along with reporting functions.
- Develop, test and maintain reports and ETL solutions across a diverse BI toolset.
- Understand business problems and proactively offer technical solutions, using traditional and emerging concepts and technologies.
- Communicate complex technical concepts in a manner that a business expert can understand.
- Discover, communicate, and offer mitigations for data quality issues.
- Ability and strong desire to work on new tools/technologies.
- Communicate technical scope, risks, and overall project status to management.
- Manage individual workload and work effectively on multiple assignments, activities, or projects in a fast pace changing environment.
Requirements
- Bachelor's Degree (Math, Economics, Statistics, Engineering, Business, Computer Science, or similar)
- Master's Degree or MBA (preferred, not required)
Knowledge, Skills, and Abilities:
- Intermediate proficiency with SQL (query writing, database creation/management, and basic stored procedures/functions)
- Beginner proficiency with SQL Server ETL (Extract, Transform, Load)
- Beginner proficiency with tabular OLAP data models is a plus
- Beginner proficiency with Microsoft Excel including pivot tables and Power Query
- Experience with Power BI is a plus
- Experience with a programming language such as C++, Python, Java, or .Net is a plus
- Strong deductive reasoning ability
- Great attention to detail and accuracy
- Strong communication skills and a customer service attitude
- Comfortable with executive level communication
- Basic understanding of finance/accounting principles a plus
Benefits & conditions
Guardian provides employees with a comprehensive Total Rewards package, supporting our core value of, "Treat others as you would like to be treated."
Compensation & Financial
- Competitive pay
- 401(k) with company match
Family, Health & Insurance Benefits (Full-Time employees working 30+ hours/week only)
- Medical, Dental and Vision
- Health Savings Accounts and Flexible Spending Accounts
- Company-paid Basic Life and Accidental Death & Dismemberment
- Company-paid Long-Term Disability and optional Short-Term Disability
- Voluntary Employee and Dependent Life, Accident and Critical Illness
- Dependent Care Flexible Spending Accounts
Wellbeing
- Employee Assistance Program (EAP)
- Guardian Angels (Employee assistance fund)
Time Off
- Paid holidays and sick days
- Generous vacation benefits based on years of service