BI Developer

Qualifications

• • Advanced direct work experience developing business focused automated reports using tools as well as building necessary SQL data objects used by reports.

• • Advanced direct work experience with Data Warehouse and related technologies such Microsoft SSIS, SQL, ETL, and OLAP data structures.

• • Advanced direct work experience any of the BI tools: Dundas BI, Tableau, Spotfire, Microsoft PowerBI, PowerPivot or Microsoft SQL Server Reporting Services (SSRS).

• • Advanced SQL development experience. Demonstrated experience creating, debugging, and modifying complex stored procedures and views, as well as querying and updating data using SQL.

• • Experience in front end and back end dashboard development.

• • Creating and using DAX to optimize calculations and measures effectively.

• • Strong experience optimizing storage size and performance in dashboard data models and deploying dashboards to the cloud.

• • Experience working with data gateways.

• • Strong ability to quickly get acquainted with unfamiliar data and evaluate data quality.

• • Strong knowledge of data migration between databases

• • Experience with production support and troubleshooting common report / data process issues.

• • Familiar with fact / dimension data modeling, and validating results of data transformation processes.

• • Exposure to extracting data from enterprise level system, such as CRMs, HRIS, or ERP a plus.

• • Understands software development methodologies and best practices as it pertains to database and report development, to include reviewing and testing deliverables.

• • Ability to document technical requirements for business processes and development needs.

• • Ability to create presentation-ready visuals, mock-ups, charts, graphs and summary reports in tight timeframes.

• • Ability to organize time to meet project timelines and effectively find solutions to common business intelligence problems with minimal to no guidance.

• • Ability to build strong relationships with team members and decision makers across the business.

• • Ability to develop and explain analytics needed by the business for decision making.

• • Willingness to tackle complex projects to successful completion and to learn new technologies.

• • Knowledge of Microsoft productivity tools such as Excel, PowerPoint, as well as willingness to learn approved third-party solutions.

• • Experience at working both independently and in a team-oriented, collaborative environment is essential, as well as having strong interpersonal skills

• • Very good communication skills and ability to collaborate with a global team

• • Displays appropriate communication skills geared towards specifics audiences including teammates, peers, and management.

• Other desirable skills:

• • Familiar with data migration from On Premise to Azure

• • Familiar with platforms like Databricks and concepts such as delta lake and medallion layers

• • Familiar with PL/SQL in the Oracle 11g/12c environment

• • Experience with web development and Powershell scripting

• • JavaScript, HTML/CSS, Python programming experience

• • Creative and critical thinking. Attention to detail.

• • Ability to effectively work on multiple projects simultaneously

• • Strong analytical and problem-solving skills.

• • Commitment to quality and continuous improvement.

• • Ability to work independently, with a sense of accountability in delivering quality work on time

• • Continuous improvement mindset – has focus on efficiency and effectiveness and recommends process improvements

• • Exposure to Microsoft Azure technologies

• • Exposure to SSAS (Tabular and multidimensional solutions)

• • Working with REST API