Senior Bi Analyst

ARCHER Transnational Systems Pvt. Ltd; United States; Remote; USD 80,000 - 110,000; Full time

Job summary

An established industry player is seeking a Senior BI Analyst to lead the technical implementation of business intelligence solutions. This pivotal role involves collaborating with various teams to design and develop reporting solutions, utilizing advanced SQL, Power BI, and Tableau. The ideal candidate will possess a strong analytical mindset, exceptional communication skills, and a passion for continuous process improvement. Join a dynamic team where your contributions will drive data-driven decision-making and operational excellence, making a significant impact on the organization's success.

Qualifications

• 7+ years of advanced SQL experience with multiple platforms.
• Expert in DAX and Power Query for complex data models.
• Experience with cloud development, especially Azure.

Responsibilities

• Design and develop reporting solutions using SQL Server, Power BI, and Tableau.
• Analyze data to create mapping and business rules for ETL.
• Provide technical guidance and recommend enhancements.

Skills

SQL

DAX

Power Query

Data Visualization

Analytical Skills

Problem-Solving

Communication Skills

Education

Bachelor's in Information Technology

Bachelor's in Business

Bachelor's in Finance

Tools

Power BI

Tableau

SQL Server

SSIS

Azure

AWS

GCP

Python

JavaScript

Job description

POSITION SUMMARY

The Senior BI Analyst is responsible for the technical implementation of BI solutions by leveraging knowledge of data warehouse models, data visualization, data analysis, and software development methodologies. Additionally, this position will work with the Manager of Business Intelligence and Analytics, Archer Senior Leadership, Business Operations, and other pertinent parties to define, prioritize and develop business intelligence and analytics solutions.

JOB RESPONSIBILITIES

• Design and development of reporting solutions utilizing SQL Server, Power BI and Tableau
• Design and development of data integrations utilizing SQL and SSIS
• Develop, document, and maintain Power BI and Tableau dashboards utilizing best practices and industry standards.
• Analyze the existing transactional data repositories to identify and create data mapping and business rules for ETL, based on business needs.
• Contribute to and partner with Product and Development teams in creation of procedural automation and associated project lifecycle including but not limited to concept delivery, user testing, and deployment.
• Establish regular validation processes to ensure data integrity and recommend new reports, feeds, and processes to support the business model.
• Provide technical guidance to other members of the development team.
• Identify and implement potential enhancements in collaboration with stakeholders.

KNOWLEDGE, SKILLS AND ABILITIES

The Senior BI Analyst will be able to design a solution from scratch as well as understand data needs necessary to drive business decisions including forecasting, KPIs and operational excellence. This role is expected to collaborate closely with multiple teams inside and outside of the IT department and effectively influence on behalf of analytics and data driven thinking.

• Advanced SQL knowledge with 7+ years of experience working with multiple platforms (SQL Server, Oracle etc.) including modeling, creating, and operating a database.
• Expert level proficiency in DAX, Power Query, and SQL, with experience building efficient data models and performing complex queries.
• Hands-on experience with building and maintaining Dataflows and Datamarts on Power BI Service.
• Expertise in optimizing Power BI reports and queries for improved performance and faster response times.
• Experience in reporting and analytics tools such as Power BI, Tableau, and SSRS.
• Familiarity with systems integration utilizing tools and languages such as SSIS, C#, Python and JavaScript is preferred.
• Experience with cloud development such as Azure, AWS and GCP. Azure experience is preferred.
• Experience building Power Automate Flows would be nice to have.
• Excellent management and communication skills. Have a desire for continuous process improvement, optimization, and automation. Excellent analytical and problem-solving skills.
• Comfortable and highly proficient in working with large sets of data in spreadsheets and other information systems.
• Bachelors degree in Information Technology, Business, Finance or related field
• Ability to take loose or incompletely defined requirements and use knowledge and experience to create a finished product.
• Ability to give effective training and presentations to senior management and other groups.
• Strong analytical and multi-tasking skills.