Business Intelligence Solutions Architect

EtiVenture Analytics; United States; Remote; USD 130,000 - 180,000; Full time

Benefits offered by this job

Medical insurance

Dental insurance

401k

Job summary

EtiVenture Analytics is seeking a Business Intelligence Lead/Solutions Architect to shape the business through analytics initiatives. You will partner with leadership, IT, ERP teams, and vendors to drive enterprise-wide data maturity and architecture.

This is a remote role with the option to be a full-time employee or long-term contractor. If full-time, benefits such as medical, dental, and 401k are offered.

Qualifications

• 10+ years in Business Intelligence, Data Architecture, Analytics Engineering, or Enterprise Data Management roles.
• 5+ years as a senior or lead architect.
• Advanced SQL and data profiling skills.
• Preferred experience with Qlik Sense, Power BI and Snowflake.
• Snowflake Expert: deep Snowflake development, SQL, data warehousing best practices.
• Power BI: mastery of DAX and Power Query; large-scale Published Gallery.

Responsibilities

• Define and own the enterprise BI and analytics architecture strategy.
• Serve as the organization's SME for analytics architecture and data strategy.
• Contribute to EDW team building data warehouse solutions.
• Communicate objectives, plans, and risks clearly to team and stakeholders.
• Scope projects with business users and ensure designs meet specifications.
• Create data models and architecture for analysts and data scientists.
• Collaborate with analysts and developers to determine extraction and transformation requirements.

Skills

Advanced SQL

Data profiling

Qlik Sense

Power BI

Snowflake

DAX & Power Query

Data warehousing

ETL/ELT

Cloud data platforms

APIs

Git/GitHub

Jira

Tools

Qlik Sense server administration

Git, GitHub

Job description

We are looking for a Business Intelligence Lead/ Solutions Architect to join our team to help shape the business and drive high-impact analytics initiatives. This individual will partner closely with leadership, IT, business stakeholders, ERP teams, and external vendors to drive enterprise-wide data maturity.

This is a remote position with the option to be an FTE or long-term contract role. If FTE is selected, benefits such as Medical, Dental and 401k are offered.

Fun Things You Will Do:

• Define and own the enterprise BI and analytics architecture strategy.
• Serve as the organization's subject matter expert for enterprise analytics architecture and data strategy.
• Be an active member of an EDW team focused on building best in class data solutions on a large data warehouse and analytics projects
• Effectively communicate objectives, plans, status, issues and risks in a timely manner to team members, stakeholders and management.
• Work with business users, analysts, developers and management to scope projects, and ensure designs are implemented and tested to specifications.
• Create solutions utilizing industry-standard dimensional models and data architecture to support business users including data scientists, analysts and non-technical functional users
• Communicates clearly in a timely manner in both verbal and written communication with other software & database development Engineers.
• Collaborate with business analysts, subject matter experts, and other team members to determine data extraction and transformation requirements.

Technical Skills:

• 10+ years of working experience in Business Intelligence, Data Architecture, Analytics Engineering, or Enterprise Data Management roles.
• 5+ years as a senior or lead architect.
• Advanced SQL and data profiling skills.
• Preferred experience working with Qlik Sense, Power BI and Snowflake.
• Snowflake Expert: Deep experience with Snowflake development, including advanced SQL, data warehousing best practices, and performance tuning for large datasets.
• Power BI Power-User: Mastery of DAX and Power Query. You should be comfortable managing a large-scale "Published Gallery" and ensuring a seamless user experience for executive-level dashboards.
• Strong expertise in data warehousing, data modeling, ETL/ELT frameworks, SQL, cloud data platforms, and enterprise reporting strategies.
• Good communication skills in verbal and written
• Preferred Experience in big data implementation in data warehouse and/or Qlik product
• Knowledge with web server integration in cloud platform (AWS) and Qlik Sense.
• Experience in Qlik Sense server administration and configuration.
• Experience in building APIs to leverage Qlik Sense for deployment automation, user updates and scheduling.
• Preferred Experience in data warehouse implementation or being familiar with data warehouse concepts.
• Experience with Jira and source control environments like Git, GitHub etc.

Who We Are

EtiVenture Analytics is a premier consulting and staffing organization specializing in Data, Analytics, and Cloud technologies. Our expertise enables our clients to achieve their goals by building better data solutions, customer experiences and efficient processes using proven and emerging technologies. We also specialize in talent management for data and IT professionals working with some of the best companies in the world. Matching talented, high performers with the right company is what we do best.

At EtiVenture, all team members are valued. We promote a collaborative culture where people can be creative, learn new ways of working smart and grow professionally. We support healthy work and home life balance by providing comprehensive health insurance plans, retirement plans, paid holidays, vacation, and sick time. We also have fun in the workplace like our weekly techno trivia contests with entertaining rewards.

EtiVenture is an equal opportunity employer that is values diversity in the workplace. All qualified applicants are reviewed without consideration to race, religion, color, sexual orientation, pregnancy, national origin, veteran or disability status or any other characteristic protected by federal, state or local laws.