Work in Washington Veterans Jobs

Job Information

McKinstry Data Focused Software Engineer in Seattle, Washington

Build the future, spark innovation and align your career with purpose. McKinstry is innovating the waste and climate harm out of the built environment and creating lasting impact. Together, we\'re building a thriving planet. Buildings are a leading contributor to the climate crisis, generating nearly 40% of total global energy-related carbon emissions. We\'re making a lasting impact on our industry and within our communities by addressing the climate, affordability and equity crises through: renewables and energy services engineering and design construction and facility services To get where we\'re going, we need big thinkers, problem solvers and collaborative mindsets. Does that sound like you? The Opportunity with McKinstry McKinstry is seeking a Data Focused Software Engineer to join our evolving Technology division in Seattle, Washington. In this role, you will work on key enterprise systems providing analysis, design, development, and configuration support for internal business partners and external clients. You will support the development and implementation of technical business intelligence and data warehousing solutions using a combination of on-premise and hosted technologies. To succeed in this role, you must have experience with SSIS and ETL processing, as well as a strong understanding of Microsoft data technologies. Additional responsibilities you will have include: Develop complex data extracts, applications, and ad-hoc queries as requested by internal and external customers using the Microsoft suite of data tools (SQL, SSIS, Azure SQL, Azure Data Factory, etc.) Design, develop, test, implement and manage ETL processes sourcing data from internal and external systems (SQL server, Excel/CSV, SOAP, API, SharePoint, SFTP, etc.). Participate in the production operations of Business Intelligence products and solutions (Datawarehouse, Data Integration, Power BI) including resolving production issues and responding quickly to priority problems Participate in the maintenance and publication of logical and physical data models, entity relationship diagrams, and a common data dictionary Participate in maintenance and publication of data flow diagrams depicting source to target mappings supporting a tiered data architecture compromised of source systems, an operational data store (ODS), a data warehouse (DW) and data marts (DM) Research, troubleshoot, and resolve data issues impacting extract delivery Work with Business System Analysts to understand the requirements regarding solutions and ensuring data quality to match back to transaction results Work with key business users to understand their information needs while providing intuitive data solutions Collaborate on the definition, development, and maintenance of standards and processes Drive improvement and automation in BI solutions and processes What You Need to Succeed at McKinstry BA/BS degree in Information Technology or related field, or equivalent work experience 3 years of experience using Microsoft data technologies in support of business reporting and analytics objectives such as writing T-SQL scripts Expereince using different ETL tools Designing and building data pipelines using SSIS is ideal 1 year of building datasets, reports and dashboards using Power BI Experience with C# coding, performance tuning and optimizing T-SQL scripts, data modeling techniques 2 years data integration experiences in a data warehousing environment Demonstrated ability to influence direction within a team and persuade others in researched areas and growing consensus building and facilitation. Nice to Have Experience with using Azure Cloud products such as Data Factory, Analysis Services, Data Lake, Data Catalog, Azure Databricks etc. preferred Experience with Azure DevO