The BI Analyst is responsible for the technical implementation of BI solutions by leveraging knowledge of data warehouse models, data analysis, and software development methodologies. Additionally, this position will work with the VP of Data and Integration, 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 and Tableau
• Design and development of data integrations utilizing SQL and SSIS
• Develop, document, and maintain Tableau dashboards utilizing performance 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 

• Advanced SQL knowledge with 5+ years of experience working with multiple platforms (SQL Server, Oracle etc.) including modeling, creating, and operating a database.
• Experience in reporting and analytics tools Tableau (70% use case), Power Bi (30% use case).
• 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.
• 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.
• Bachelor's degree 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.