Cloud Data Engineer at Guardian Alarm

General Purpose & Essential Duties

The Cloud Data Engineer conceptualizes and builds pipelines that contextualize and provide easy access to the data for the entire organization. They possess the ability to guide organizational growth and develop data solutions that translate complex data into user-friendly terminology. The Cloud Data Engineer will design, build and deploy data solutions that capture, explore, transform, and utilize data to support Artificial Intelligence, Machine Learning, and business intelligence/insights. The Cloud Data Engineer is also responsible for providing IT support based on the company’s needs.

• Build and operationalize complex data solutions/data warehouse, correct problems, apply transformations, and recommend data cleansing and data quality solutions using Azure Data Factory.
• Design complex data solutions, including incorporating new data sources and ensuring designs are consistent across projects and aligned to overall data strategy.
• Perform analysis of complex sources to determine value and use and recommend data to include in analytical processes.
• Incorporate core data management competencies including data governance, data security and data quality.
• Act as a data and technology subject matter expert (SME) within lines of business to support delivery and educate end users on data products and the analytic environment.
• Perform data and system analysis, assessment and resolution for defects and incidents of high complexity and correct as appropriate.
• Collaborate across team to support delivery and educate end users on complex data products/analytic environment.
• Build and maintain Power BI, SQL reports and SSIS packages as needed
• Documents, designs, monitors SQL servers’ processes and security
• IT support based on company needs

Required Education, Experience, Skills & Knowledge

• Strong problem solver who utilizes data and proofs of concepts to find creative solutions to difficult problems involving a significant number of factors with broad implications, reflects on solutions, measures impact, and uses that information to ideate and optimize.
• Excellent communication skills with the ability to develop business partnerships, describe technology concepts in ways the business can understand, document initiatives in a concise and clear manner, and empathetically and attentively listen to others thoughts and ideas.
• Ability to lead and take action even when there is no clear owner, inspire and motivate others, and be effective at influencing team members.
• Excellent time management skills with the proven ability to work on multiple projects and stay within scope, schedule, cost, and quality specifications.
• Proficient with Azure Data Factory, Pipelines, Microsoft SQL Server Management Studio, Visual Studio and SQL scripting.
• Advanced knowledge of tools, techniques, and manipulation including cloud platforms, programming languages, and modern software engineering practices.
• Strong delivery skills including the ability to determine the software design strategy and methodology to be used for efforts, use automated tests, analysis, and informed feedback loops to ensure the quality and production readiness of work before release, monitor the health of work efforts and that of adjacent systems.
• Bachelor’s Degree in STEM related field or equivalent training with data tools, techniques, and manipulation.
• 5+ years of data engineering or equivalent experience.
• Experience developing reports using Power BI/SQL Server Reporting Services
• Microsoft SSAS development experience a plus