Business Intelligence Architect

Redapt Redmond , WA 98053

Posted 3 weeks ago

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


  • 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 working from Dallas or as remote employee anywhere in the US.

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

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
Program Manager Business Intelligence

Microsoft Corporation

Posted 6 days ago

VIEW JOBS 4/16/2019 12:00:00 AM 2019-07-15T00:00 Organization Summary: If you love the pursuit of excellence and are inspired by the challenges that come through driving innovations that impact how the world lives, works and plays, then we invite you to learn more about Microsoft Operations - and the value we deliver across Microsoft and to our customers and partners. We offer unique opportunities to work on interesting global projects in an environment that appreciates diversity, focuses on talent development and recognizes and rewards great work. We make doing business with Microsoft easy. Position Description: Do you want to be at the forefront of Microsoft's Digital Transformation? Do you believe data insights and analytics can unlock the power to success for our customers and partners as much it helps Microsoft internally to be efficient and effective? Do you have strong subject matter expertise in business intelligence architecture? Are you execution-oriented with attention to detail to drive platform enhancements and improvements across the BI stack from data acquisition through data visualization? If you answered yes to the above then you might be the right person to join the Global Business Intelligence Platform as a Technical Program Manager in Microsoft Business Operations. Business Intelligence (BI) and Data Insights are key to the Digital Transformation of Operations. The Global Business Intelligence Platform BI team enables data insights to drive revenue opportunities, operational efficiency, Compliance requirements and use of Predictive analytics to inform both our current and future business strategies. We are looking for a seasoned professional with strong product, program, and project management experience to drive business analytics solutions. An appropriate candidate will have deep technical knowledge of BI systems design, Microsoft Business Intelligence stack as well as BI layer data modeling. The candidate should have excellent organizational and communication skills and feel comfortable in a fast pace continues delivery agile environment. Basic Qualifications: * 5 years' minimum experience with Business Intelligence (BI). * 5 years' minimum experience in Program Management. * A minimum of a Bachelor's degree in Operations, Business, Supply Chain, Finance, or a related field, or equivalent alternative education, skills, and/or practical experience is required. Preferred Qualifications: * 8 years' minimum Business Intelligence (BI) experience. * Flexible, agile and fast learner. * Team player and able to establish a high level of collaboration with an engineering team. * Knowledge of Microsoft's Business Intelligence stack, data modeling methodologies, data quality management, and big data. * Excellent cross-group collaboration, outstanding verbal and written communication. #CSEO #CDAS Microsoft is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to age, ancestry, color, family or medical care leave, gender identity or expression, genetic information, marital status, medical condition, national origin, physical or mental disability, political affiliation, protected veteran status, race, religion, sex (including pregnancy), sexual orientation, or any other characteristic protected by applicable laws, regulations and ordinances. We also consider qualified applicants regardless of criminal histories, consistent with legal requirements. If you need assistance and/or a reasonable accommodation due to a disability during the application or the recruiting process, please send a request via the Accommodation request form. Benefits/perks listed below may vary depending on the nature of your employment with Microsoft and the country where you work. Key Responsibilities: * Responsible for the defining and analyzing technical BI requirements for engineering implementation with emphasis on quality and business value impact. * Define SLA for performance, data freshness, data availability and infrastructure requirements for BI solutions to ensure appropriate design and quality of the BI solution. * Develop proof of concept solutions to test and ascertain requirements for BI needs. * Implement funding, capacity, roadmaps and change management based on strong business cases, ROI and long term organizational goals. * Define and establish engagement models with BI stakeholders, partner organizations (i.e. MSIT, finance, etc.), and business analyst teams within MS Ops and facilitate strong team work between Engineering delivery team and users through engineering development cycle. * Support and lead requirements for data security, data governance, release readiness and user readiness. Microsoft Corporation Redmond WA

Business Intelligence Architect