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