BI Architect

About Onix: Onix is a trusted cloud consulting company and leading Google Cloud partner that helps companies get the most out of their technology with cloud-powered solutions, best-in-class services, and the Datametica Birds, data migration products that unleash AI potential.

We are able to deliver exceptional results for our customers because of our 20+ year partnership with Google Cloud, depth of technology expertise, and IP-driven data and AI solutions.

We offer solutions across a wide range of use cases and industries that are tailored to the unique needs of each customer. From advanced cloud security solutions to innovative AI capabilities and data migration products, we have you covered. Our global team of experts are the most reliable, talented and knowledgeable in the industry.

Summary: Do you have a passion for data and a knack for translating it into actionable insights? Are you excited about designing the foundation for an organization's data-driven decision making? If so, then a BI Architect role might be the perfect fit for you!

We are seeking a talented BI Architect to join our team and play a pivotal role in designing, developing, and implementing our Business Intelligence (BI) strategy. You will be responsible for the entire BI architecture, from data acquisition and storage to analysis and presentation, leveraging Looker or Teableau capabilities alongside other industry-leading BI tools.

Location: Remote, San Francisco Bay Area, Atlanta, Miami, NYC, Northern NJ/Princeton, DC Metro Area/Northern Virginia: Remote, San Francisco Bay Area, Atlanta, Miami, NYC, Northern NJ/Princeton, DC Metro Area/Northern Virginia

Primary Responsibilities:

• Design and implement a scalable, secure, and future-proof BI architecture, utilizing Looker or Tableau as the primary platform

• Install, configure and maintain Tableau Server Environments

• Monitor Server Performance, troubleshoot issues & ensure availability and reliability

• Monitor and optimize server performance and ensure proper access controls and permissions

• Develop data models in DBT or LookML, optimize ELT/ETLs and data transformation, and integrate data warehouses and lakes with Looker or Tableau

• Collaborate with business stakeholders to understand their needs and translate them into actionable insights using dashboards and reports alongside other relevant BI tools

• Ensure data governance, security, and quality standards are met within the Looker or Tableau environment and across the entire BI ecosystem

• Develop and maintain data models, data dictionaries, and technical documentation, while staying up-to-date on best practices for BI tools and design

• Mentor and guide junior BI developers and analysts on BI best practices and provide guidance on other relevant BI tools

• Experience with SQL, PLSQL, UDFs, Stored Procedures and Python

Preferred Skills and Experience:

• Minimum 10+ years of experience in BI design and development

• Proven experience in data modeling, ETL processes, and data warehousing

• Strong understanding of data governance and security best practices

• Either: Expert knowledge of Looker (including LookML development, data visualization, and administration) or expert knowledge of Tableau (including data model development, data visualization, and administration)

• Experience with integrating Looker or Tableau with various data sources

• Expert level experience with DBT

• Experience with Apache Airflow

• Experience with other leading BI tools (e.g., Microsoft Power BI, Qlik, MicroStrategy, Oracle)

• Excellent communication, collaboration, and problem-solving skills

• Experience with cloud-based BI solutions (e.g., BigQuery, Azure Synapse Analytics, Amazon Redshift)

• Experience with big data technologies (e.g., Hadoop, Spark)

• Experience with data visualization techniques

Education: Bachelor's degree in Computer Science, Information Technology, Mathematics, Statistics, or a related field (or equivalent experience) Travel Expectation: up to 10%

It is the policy of Onix to ensure equal employment opportunity in accordance with the Ohio Revised Code 125.111 and all applicable federal regulations and guidelines. Employment discrimination against employees and applicants due to race, color, religion, sex, (including sexual harassment), national origin, disability, age (40 years old or more), military status, or veteran status is illegal. Onix will only employ those who are legally authorized to work in the United States or Canada. This is not a position for which sponsorship will be provided.

• Individuals with temporary visas such as E, F-1, H-1, H-2, L, B, J, or TN or who need sponsorship for work authorization now or in the future, are not eligible for hire.