Data Architect

Data ArchitectNew York, NY or RemoteOverviewPosition Type Full TimeDescriptionSenior Data Engineer / Data ArchitectBright Power works with forward thinking owners and developers to identify, design, and implement custom energy and water solutions on a wide variety of systems. Our team is a diverse, talented, and hard-working group of individuals committed to growing this industry and to making a positive impact on the environment.Join UsBright Power is comprised of a team of diverse, talented, and hard-working individuals committed to growing this industry and making a positive impact on the environment. We are passionate about reducing energy and water usage by implementing energy efficiency and renewable energy technologies. Our goal is to improve the health, comfort, and value of our client's buildings, while cultivating a sustainable future. We believe deeply in doing well by doing good and come to work every day seeking to change the world.The RoleBright Power is seeking a Data Architect / Senior Data Engineer to work alongside Data Services and Software under the direction of the SVP, Data & Product Strategy in developing and maintaining a complex data infrastructure for all of Bright Power.As a Data Architect, you will be the primary decision-maker on how our data infrastructure is designed and built. You'll be trusted to weigh business needs and trade-offs, including cost, complexity, timeline, maintainability, and team capacity. You'll recommend and defend the approach that best serves Bright Power's actual business needs and play a key role in helping junior members of the Data Team grow their technical skills.Primary ResponsibilitiesOwn architecture and infrastructure decisions. Evaluate trade-offs, including cost, complexity, timeline, maintainability, and team capacity. Recommend and defend the approach that best serves Bright Power's actual business needs.Develop a thorough understanding of business needs and priorities across Data Services, Software, and service delivery teams in order to design and recommend approaches with the highest business impact.Design, build, and optimize data sets, ETL workflows and data pipelines, and architectures: Identifying, designing, and implementing internal process improvements including re-designing infrastructure for greater scalability, optimizing data delivery, and automating data pipelinesGain thorough understanding of business needs and priorities in order to recommend and design approaches with highest impactCollaborate with cross-functional teams to build pipelines and processes that are dependable, well monitored, and issues are clearly communicated to stakeholders when discovered and as they are repairedCreate and maintain automated/regression tests, setup alerts, monitor pipelines/workflows, and fix data pipeline problemsPerform root cause analysis on external and internal processes and data to identify opportunities for process improvement and test creation.Serve as both a technical expert on the data solutions team and as a technical guide to other data solutions team members.Serve as an escalation point and subject matter expert during major data pipeline incidents and coordinate the issue resolution with key internal and external stakeholders.Ensure data quality through collaboration with the company's premier data vendor partners by identifying data problems, communicating them to the vendor, and verifying when they are rectified.As part of an Agile project and operations team; design, develop, test, implement and support technical solutions across full-stack development tools and technologiesOther work as assignedQualificationsSkills/QualificationsProven experience as a data architect or senior data engineer, including experience owning architecture decisions and being accountable for their outcomes.Demonstrated ability to evaluate technical trade-offs and make sound, well-reasoned recommendations on infrastructure and architecture choices grounded in business needs and value.5+ years of proven administrative or development experience with Data infrastructure, complex data modeling, AWS environments, ETL workflows, and data APIsTechnically proficient in data systems administrationProficiency with AWS Athena, MySQL, and Postgres, Linux or WSL, Git, programming with Python using pandas, and building pipelines with AWS GlueProficiency with RDS, database documentation, and data lake architectureExcellent organizational and time management skillsStrong work ethic and able to work independently and multitaskCritical thinking and problems solving abilitiesExcellent verbal and written communication skills; ability to clearly articulate areas of opportunity across multiple technology domainsProven track record in working as part of a team to maintain and improve internal systemsInterest in learning about buildings, construction, and its relation to energy and environmental issues.Passion for sustainability, climate change mitigation, and/or creating healthier buildingsSalary : $100,000 - $130,000BenefitsIn addition to working with incredible people, Bright Power offers competitive benefits. Find the list of our benefits offered on our careers home pageEQUAL EMPLOYMENT OPPORTUNITIES Bright Power provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability or genetics. In addition to federal law requirements, Bright Power complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.Bright Power expressly prohibits any form of workplace harassment based on race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, genetic information, disability, or veteran status. Improper interference with the ability of Bright Power's employees to perform their job duties may result in discipline up to and including discharge.