Business Intelligence Analyst

Redapt Woodinville , WA 98072

Posted 2 months ago

Primary Responsibilities:

  • This role includes working with business and development teams to design, and document dashboards, alerts, and reports.

  • Be able to determine business requirements, priorities, define key performance indicators (KPI), and develop BI and data warehouse (DW) strategy.

  • You will be responsible for designing solutions and overseeing the development and execution of projects.

  • Be able to build pilot solutions and proof-of-concepts with minimal direction.

  • Educate employees on how to use data as an analytical tool.

  • Conduct analyses of functional business processes and functional business requirements and participate in the development of business cases in the support of process changes and IT projects.

Required:

  • Ability to appropriately architect data solutions utilizing SQL Server architecture. This includes storage, replication, server tuning, upgrading, backup/restore, security, etc.

  • Ability to write complex SQL queries

  • TSQL knowledge, DML/DDL, triggers, CTE's, query tuning, etc.

  • Strong knowledge of SSRS, SSAS, SSIS: script tasks, checkpoints, recordset objects, package vs. project deployment.

  • Knowledge of SQL Server Reporting Service and Power BI.

  • Knowledge of Azure SQL, and other Azure offerings centered around Data and Analytics

  • BS or MS in Computer Science, Engineering or Mathematics or Equivalent field

  • Must work well in a team environment

Preferred:

  • Experience with Azure Data Lake Analytics

  • Experience creating Finance or CRM Power BI dashboards

  • Experience with multiple data sources such as SharePoint, Dynamics 365, SQL, Exchange, etc.

Who you are:

  • Excels with ambiguity and able to design a clear path to meet end goals

  • Have a broad understanding of BI and data technologies and how to match the right technologies to solutions.

icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Senior Business Intelligence Architect

Redapt

Posted 6 months ago

VIEW JOBS 11/2/2019 12:00:00 AM 2020-01-31T00:00 If you're interested in designing modern cloud database solutions on Microsoft Azure and love helping customers solve complex problems related to Business Intelligence, Advanced Analytics, and Data Science, we'd like to hear from you! We're looking for a versatile BI Data Architect who can design and implement modern architecture for a diverse set of customers and industries. The ideal candidate would have deep experience in designing enterprise data warehousing solutions utilizing, SQL Server, Azure SQL DW and Big Data platforms (i.e. Azure Data Lake, Azure Data Factory). This position will be responsible for leading customer conversations, creating and presenting project architecture, and leading delivery. Primary Responsibilities: * Interfacing directly with clients to solve broad business goals with database solutions. * You will be responsible for gathering requirements, designing solutions, and overseeing the development and execution of projects. * This role will be directly involved in the business development process; specifically delivering customer demos to show the value of how data can drive business goals. * Be able to build pilot solutions and proof-of-concepts with minimal direction. * Provide support to project manager through developing tasks, estimates, and dependencies to meet expectations Required Technical Skills: * Ability to appropriately architect complex data solutions utilizing SQL Server architecture. This includes storage, replication, server tuning, upgrading, backup/restore, security, etc. * Ability to write complex SQL queries * TSQL knowledge, DML/DDL, triggers, CTE's, query tuning, etc. * Strong knowledge of SSIS: script tasks, checkpoints, recordset objects, package vs. project deployment. * Practical knowledge of how to design complex SQL Server Integration Services (SSIS) packages * Knowledge of SQL Server Reporting Service and Power BI. * Knowledge of Azure SQL, and other Azure offerings centered around Data and Analytics (Azure Machine Learning, Data Lake, Data Factory, Streaming Analytics, Table Storage, Hadoop, etc.) * BS or MS in Computer Science, Engineering or Mathematics preferred, equivalent work experience will be considered Preferred: * Strong understanding of parallel processing utilizing Azure SQL Data Warehousing for both structured and unstructured data sources. * Experience writing U-SQL and Azure Data Lake Analytics * Experience with HDInsight, Spark, and Hadoop Redapt is a Microsoft Gold Certified Partner, so often projects are focused on delivering business solutions utilizing Microsoft Technologies. This role is expected to work with our counterparts in the Microsoft solution selling network. Who you are: * Excels with ambiguity and able to design a clear path to meet end goals * Have a broad understanding of BI and data technologies and how to match the right technologies to solutions. * Have proven experience with both the customer facing and solution engineering skill set This position is flexible to working in-office in Woodinville or remotely in Atlanta, Dallas, Denver, Irvine or Cincinnati. Redapt Woodinville WA

Business Intelligence Analyst

Redapt